Index

O

Object Browser, 123–126

object calls, 140

Object Database Connectivity. See ODBC

object models, 368

object-identifying prefixes, 39

object-model relationship. See entity-relationship model

objects, 18–19, 67–68

Access objects, 70–71

ADO objects, 68–70

AnswerWizard object, 302

Application object, 67

Assistant object, 302

attributes, 67

Catalog object, 177

categories of, 5–6

Column object, 177

CommandBar object, 254, 304–307

Connection object, 158, 159, 163

CurrentProject object, 67

Data Access Objects (DAO), 69

Debug object, 196

defined, 5

DocumentProperty object, 302

Err object, 187–189

FileSearch object, 302–304

HTMLProject object, 302

Index object, 177

Key object, 177

Me object, 149–150

methods, 67–68

object reference, 153

Recordset object, 157–159, 163

Script object, 302

shared, 302–307

Table object, 177

in VBA, 139–140

VBA objects, 70

WebPageFont object, 302

See also entities

ODBC, 4

On Close event, 227–228

On Load event, 227–228

one-to-many relationships, 33

one-to-one relationships, 33

online computer-based training, 24–25

online help, 24

OpenDataAccessPage, 401–402

OpenDiagram, 402

OpenForm, 402–404

OpenFunction, 404

OpenModule, 405

OpenQuery, 405–406

OpenReport, 406–407

OpenStoredProcedure, 408

OpenTable, 408–409

OpenView, 409–410

optimized VBA code, writing, 364–366

optional parameters, 171–172

Options dialog box, 272–274

Advanced tab, 278

Datasheet tab, 276

Edit/Find tab, 275

Error Checking tab, 278–279

Forms/Reports tab, 277

General tab, 274–275

International tab, 278

Keyboard tab, 276

Pages tab, 277

setting options programmatically, 355

Spelling tab, 279

Tables/Queries tab, 280

View tab, 274

OR operator, 95–97

ORDER BY keyword, 156

orphans, 219

Outlook, connecting with, 310–312

OutputTo, 410–412

overhead, 174