Microsoft Access 2010 Bible

1323

Index

join line, 158–159

moving tables, 159

removing tables, 159–160

Query event, 464

query joins. See also join tables.

ad hoc, 161–162

auto-join line, 161

Cartesian products, 161, 164

creating, 160–161

deleting, 164

equi-joins, 160

outer, 163

type, specifying, 162–163

QueryDef object, 503–505

question mark (?)

optional letter indicator, 67

wildcard character, 181, 195–198

Quick Access Toolbar. See also the ribbon.

adding commands, 1018–1019

illustration, 1018

modifying, 1018–1020

R

radio buttons, 298–299. See also option groups.

RaiseError action, 562

raising events, 1002–1003

RAM, minimum requirements, 841

RDBMS (relational database management system), 5

read-only properties, 987

read/write properties, 987

rearranging fields, 235–236

rebooting, 874

record display width, modifying, 238

Record Locks property, 310, 652

record pointers, 223

Record Selector, 305–306

Record Selectors property, 306

Record Source property, 309

RecordCount property, 498–499

record-lock. See locking issues, record-lock.

record-locked fields in multiuser environments, 676

records (rows). See also fields; tables.

coloring, 239–241

current position indicator, 295

in datasheets, 216–217

definition, 8

display width, modifying, 238

freezing, 242

primary keys, editing, 156–158

removing, 136, 159–160

queries, updating

primary keys, 158

rules for, 157

Queries option, 36

Query by Example (QBE). See QBE (Query by

Example).

Query Criteria option, 655

Query Design Font option, 650

Query Design ribbon

Append button, 138

Crosstab button, 138

illustration, 137

Make Table button, 138

Run button, 138

Save (in the Quick Access Toolbar)

button, 138

Select button, 138

Show Table button, 138

Update button, 138

View button, 138

Query Designer

adding tables, 136, 160

creating queries, 135–138

Datasheet view, 136

description, 137

Design view, 136

displaying field names, 136

Enable Autojoin option, 650

Field List window, 136

field lists, 159

illustration, 136

join line, 158–159

launching, 135

moving tables, 159

options, 650

Output All Fields option, 650

QBE (Query by Example) grid, 137

Query Design Font option, 650

removing tables, 136, 159–160

Show Table Names option, 650

SQL Server Compatible option, 650

SQL view, 136

Query Designer, table/query pane

adding tables, 160

description, 137

field lists, 159

illustration, 136

52_475348-bindex.indd 132352_475348-bindex.indd 1323 4/1/10 2:02 PM4/1/10 2:02 PM