O

object dependencies, 207–209

Object Dependencies pane, 209

Object Designers category (Access Options dialog box), 90–91, 193–195, 415, 1489–1490

object frame, 534

Object list (Visual Basic Editor), 946–947

object methods, 993–1005

about Visual Basic, 993

executing commands with DoCmd object, 1005

using ADO recordsets, 1001–1005

working with DAO recordsets, 994–997

object model hierarchies, 978–987

Access, 978–981

ADO, 985–987

DAO, 981–985

object shortcuts

creating in custom groups, 63–67

hiding, 69–72

renaming, 70–72

revealing hidden, 72–75

Object Type category (Navigation Pane)

adding groups to, 57

displaying tables only, 105–106

filtering form objects, 114, 115

groups included in, 57

maximizing search for objects from, 82

unable to reorder display, 61

viewing objects organized in groups in, 105

object variables, 991–993

object-oriented programming, 560–562

objects.

See also ActiveX Data Objects (ADO);

Data Access Objects (DAO)

cutting and moving, 210

defined, 99

designing tabbed documents for finding other, 86

dimmed, 73–74

dragging and dropping into custom groups, 66

embedding in reports, 744–745

filtering

by group, 81–82

form, 114, 115

list of Navigation Pane, 49, 50, 52–53

with Search Bar, 79–80

form, 574–578

importing

Access, 271–273

linking vs., 292

read permission required when, 273

selecting for import, 272–273

macro actions

modifying, A115–A117

opening/closing Access, A102–A104

macro objects, 897

maximizing search for all, 82

Me, 990

members for HTML, 1132

module, 942–943

names

delimiting for SQL Server, 1460

preceding with exclamation point, 989–990

putting in brackets, 372

Navigation Pane

categories, 53–58

exploring in, 105

initial placement in, 62–63

jumping to from, 46

opening with single-click, 106

propagating changes for table, 204

referencing form and report, 919

relationship among Access, 100–101

renaming, 212

searching for database, 78–82

shortcuts

creating in custom groups, 63–67

revealing hidden, 72–75

sorting, 76–78

system

displaying in Navigation Pane, 1267

recommended settings for, 1269

types of Access, 99–100

ODBC. See Open Database Connectivity (ODBC)

ODBC databases

exporting data to, A82–A83

query properties when connecting to, 462

ODBC Driver Manager, 254

ODBC Timeout property, 462

Office. See Microsoft Office system

Office Clipboard task pane, 395

OLE Object data type

about, 158, 160

changing Attachment data type to, 533

difficulties with Web applications, 1069

OLE object field

entering data in, 546

indexes undefinable using, 189

On Error statement, 1029–1030

OnError macro action

about, A118

adding macro error handling with, 914, 915

specifying macro in same macro object in, 911

one-to-many relationships

database efficiency and, A28

defining, 185–186

linking table fields for, 184

one-to-one relationships, A28

Open Database Connectivity (ODBC)

about, 253–255

Access compatibility with, 9

Access won’t use for all file types, 268

architecture of, 255

ODBC databases

creating data source as link to, 255–259

exporting data to, A82–A83

query properties when connecting to, 462

specifying source for tables with IN clause, A46, A47

using with dynamic Web pages, 1159, 1160

Open dialog box

finding and opening files from, 23

selecting databases from, 102–103

OpenForm action, 922–923

opening

Access for first time, 19–20

Access Options dialog box, 27, 84

.accfl files, 153

Collecting Data Using E-Mail Options dialog box, 313

Contacts.adp project file, 133

events for form and report, 870–871

existing databases, 22–25

Export-SharePoint Site wizard, 1183

File New Database dialog box, 144

Form window in Layout view, 563

Form Wizard, 688–689

IssuesSample.accdb database, 46

Navigation Options dialog box, 55–56

objects

with macro, A102–A104

with single- or double-click, 106

property sheets, 116–117, 575

queries in Design view, 112–113

query property sheet, 452

reports in Report view or Print Preview, 746

SQL Server Configuration Manager, 266–267

subdatasheets and filtering, 407

Switchboard Manager, 1307

Table Analyzer Wizard, 234–235

Trust Center, 36, 96

OpenRecordset method

parameter settings for, 994–995

syntax of, 994

operators.

See also specific operators

AND

constructing multiple constraint expressions with, 1481

expressing in query designer, A55

results using OR vs., 357–359

truth tables for, A56

arithmetic expression, 365

Boolean

as selection criteria, 356

truth tables for, A56

using in query designer, A55

comparison

Between, In, and Like, 360–361

criteria selection with AND and OR, 357–360

Mod

function of, 365

integer as result of operations with, 373

OR

constructing multiple constraint expressions with, 1481

OR abbreviation vs., 356

results using AND vs., 357–359

truth tables for, A56

order of precedence in expressions, 367

symbols for comparison, 169

Option Button command, 714

option buttons

about, 526–527

setting field’s status with, 605–607

toggle buttons and check boxes vs., 606

Option Explicit statements (VB), 963

option groups

about, 526–527

displaying form values in, 714–716

Options dialog box.

See also Access Options dialog box

customizing work with modules in, 948

tab options in, 948–950

OR operator

constructing multiple constraint expressions with, 1481

OR abbreviation vs., 356

results using AND vs., 357–359

truth tables for, A56

Oracle, importing data from, 266–270

ORDER BY clause

overview, A50-A52

specifying calculated column alias name with, A62

TOP n PERCENT clause and, 1510, 1511

using column names of clause in UNION queries, A52, A63, A69

ordering columns in project queries, 1503–1504

organizing tasks, A11–A13

Orientation property, 463

outer joins, 425–431

avoiding between two tables, 185

building simple, 425–426

defined, 425

finding unmatched, 426–430

full, 1502

Outlook

Access Data Collection Replies folder in, 331

automatic e-mail reply processing, 312–313, 325–326

Data Collection Status column, 341

filling out HTML forms, 322–325

moving HTTP-based messages to Outlook Inbox, 325

selecting as source for e-mail address, 315–316

output

controlling query, 452–454

data as task, All

Output All Fields query property, 452–453

overlaying text boxes, 1096