Index

A

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