Ubk

About form of Choose My Adventure program, 263 controls/properties of, 265 AbsolutePosition property, 254, 274 Access. See Microsoft Access AccessConnection property, 241 Access Data Access Page wizard, 327 ACCESS FORMS, 33 Access table graphical interface, and management of table data, 11 .ACS file extension, for Microsoft agents, 305 Actions, 278

ActiveX Data Objects. See ADO

Adding items, to list and combo boxes, 105-108

AddItem method, 104, 105, 106, 110, 111, 118

Addition operator (+), 59

Add method, parameters of, 291

AddNew method, 259, 274

Add Procedure dialog box, accessing, 149-150

AddTwoNumbers method, 285

Add Watch dialog box, 188

adLockBatchOptimistic, 245

adLockOptimistic, 245

adLockPessimistic, 245

adLockReadOnly, 245

Admins group, Access 2003, 336, 346

Admin user account, 346

password, 337, 347 ADO

adding records, 257-259 browsing through rows in recordset, 254 connecting to database, 240-244 cursors, 246-247 database programming, 239-275 deleting records, 261-263 key terminology, 240 opening recordset, 252-253 overview, 239-240 retrieving/browsing data, 247-257 updating records, 257-259 working with recordsets, 244-245 ADODB library name, 240

ADO library, 278 ADO object model, 240 adOpenForwardOnly cursor, 246 after parameter, 291 Agents, 305

Aggregate functions, in SQL, 222-225, 236 ALTER TABLE statement, 234-235, 236 Ampersand (&) character, 50 Analysis, before creating database, 4-5 AND command, 216 AND keyword, SQL queries, 220 And operator, 70, 95 truth table for, 71 Animated Math program, 319-323 code for, 320-323 controls and properties of, 319 Animation property, animations assigned to, 306-307 ANSI (American National Standards Institute)

values, 192 ANSI SQL, 213

API (application programming interface), 240 Application Category, 24 Application object, 317 Arguments, 152-154, 177 arrays passed as, 163-164 passing by value and by reference, 152-154, 177, 178 Arithmetic operators, 59 Arrays, 58, 157-164, 178 dynamic, 161-163 passing as arguments, 163-164 single-dimension, 158-160 two-dimensional, 160-161 Asc function, 135, 140, 144, 193

common character codes used with, 349-350 ASC keyword, 226 AS clause, 221, 236 As clause, 53

asOpenDynamic cursor, 246 ASP (Active Server Pages), 239 Assert method, 197 Assignment operator (=), 44 Assignment statements, 40, 44

Assistant character, 323 Assistant object, 304-310, 323 choosing character, 305 NewBalloon property from, 310 Assistant property, 306

Asterisk (*) character, selecting fields in table for query with, 28

ATM (automated teller machine) menu, 98 Attributes, 16, 278 AutoNumber, 23 data type, 23, 32 field type, 231 AVG function, 222

0 0

Post a comment