ACCDB file format, 2, 29
ACCDB files, 253, 278, 281
ACCDE file format, 2
ACCDE files, 331
Access 2007
changes from Access 2003, 2
as a front end to other databases, 132
three-tiered applications and, 15
Access 2007 VBA
changes from Access 2003, 2–3
programming concepts, 3–25
uses of, 1
Access database files. See ACCDB files
Access databases
attaching SharePoint lists to, 231
changes to existing prior to migration, 277
connecting to, 132
importing a SQL Server database, 203–204
importing data from, 201
separating into two database files, 319–322
upsizing, 277–284
Access designer, 271
Access field data types. See field data types
Access forms, generating prototype screens, 336–340
Access macros, VBA instead of or with, 1
Access Options, Advanced, 316–317
Access Project file, 278, 281
Access Projects
based on SQL Server databases, 260, 262–263
creating, 259–263
described, 253
displaying new, 278, 284
as a front end to SQL Server, 253–254
migrating existing Access databases to, 277–284
reusing code across multiple, 308
storage locations for objects seen from, 254
working with SQL Server objects, 264–277
Access runtime, 330
Access tables
checking dates in, 277
exporting contents to a spreadsheet, 205, 206
ActionSuccess event, 116, 120–121
Activate event, 247
active plans, retrieving, 472
ActiveConnection property, 143, 147, 151, 155
ActiveX controls, 305–308
ActiveX Data Objects. See ADO
Activity Diagrams, 7–8, 9, 10
actor in a Use Case Diagram, 5
Add Comment button, 337
Add Current Contact To Project button, 339, 340
Add method, 112, 113
add mode, 442–443, 449–450
Add mode flag, 169, 176
Add New navigation button, 137
Add Table dialog box, 275
Add Watch dialog box, 69, 71
AddEmptyProjectRecord procedure, 419, 433
Add-in Manager, 313
add-ins, 312–313
Add-Ins tab, 289
AddItem method, 189, 190–191, 192–193
AdditionalData parameter, 209
Add/Manage Contacts button, 453, 455
AddNew method, 141–142
AddParameters procedure, 497–499, 517
AddRecord procedure
calling from OnClick, 144, 152
indicating Add mode, 166, 172
adLockBatchOptimistic value for the LockType property, 134, 317
adLockOptimistic value for the LockType property, 134, 317
adLockPessimistic value for the LockType property, 134, 317
adLockReadOnly value for the LockType property, 134, 317
ADO (ActiveX Data Objects)
adding a reference to, 358
connecting to the ProjectTrackerDb, 344
described, 129–130
storing database errors, 75
treating data sources as virtual tables, 163
versions of, 130–131
ADO Command object, 269
ADO Connection object, 313
ADO object library, 130
ADO object model, 130–131
ADO Parameter object, 269
ADO recordsets
based on SQL statements, 272
binding a form to, 138
specifying as a report’s data source, 236–237
Adobe Acrobat, launching, 457
ADODB library. See ADO object library
ADO.NET, 130
adOpenDynamic value for the CursorType property, 133
adOpenForwardOnly value for the CursorType property, 133
adOpenKeyset value for the CursorType property, 133
adOpenStatic value for the CursorType property, 133
ADOX library, 177–178
ADP file, opening, 278
ADPs. See Access Projects
All Object Types tab, 326
All Records option, 317
AllForms collection, 97
AllPrinters collection, 247
AllReports collection, 238
Analyze Performance, 326
And statements in a Where clause, 161
announcements in SharePoint, 221, 229–232
ANSI SQL, 159
application(s)
determining the purpose of, 3
distributing, 329–331
elements of, 11–12
exposing as a web service, 214
finishing, 315–332
identifying the objectives of, 3
maintaining, 331
modeling the design of, 4–11
optimizing, 322–327
securing, 327–329
writing to handle multiple users, 315–322
application architecture, 11–18
application design, 4–11
application logic, 104
Application object, 94
architecture for applications, 11–18
arrays, 51–53
arrows in an Activity Diagram, 8, 9, 10
AS predicate, 160
ascending order, 162
Attachment data type, 50, 222
attachments
database objects as, 210–211
procedure for previewing, 385, 401
procedures for saving, 439
Auto Order option, 198
AutoExec macro
creating, 46–47, 185
opening a switchboard form, 187
specifying form to open, 182
automation, 294–305
automation client, 294
automation objects, 294–295
automation server, 294
AutoNumber (Long Integer) field data type, 51
AutoStart parameter, 249