Index – MOS Study Guide for Microsoft Access Expert Exam MO-500

Index

A

action queries, creating, 7102

adding. See inserting

anchoring form controls, 132133

append queries

creating, 101

described, 9299

appending records, 4749

arithmetic operators, 112

attachments, 124

automatic field values, 8082

Azure, 52, 54

B

buttons, 124

C

categories in Navigation Pane, 710

check boxes, 124

child tables, 18

referential integrity, 2526

columns

deleting, 110

inserting, 109

multiple in reports, 148149

Combo Box Wizard, 119

combo boxes, 124

Command Button Wizard, 118

comparison operators, 112

composite keys, 12

controlled tables, 18

controlling tables, 18

controls

on forms

headers/footers, 133135

images, 135136

inserting, 118120

labels, 126

margins/spacing, 132133

moving, 120121

setting properties, 122126

tab order, 129131

types of, 123124

on reports

inserting, 143145

labels, 145146

margins/spacing, 149151

selecting, 152

crosstab queries, creating, 295

Crosstab Query Wizard, 394, 95

customizing

Navigation Pane, 710

print options, 2931

D

data

exporting, 3136

filtering in queries, 112114

finding/replacing, 6366

importing, 26, 4041

appending records, 4749

into new table, 4147

sorting in queries, 111

database objects. See objects

dBASE, 52, 54

delete queries

creating, 102

described, 99

deleting

columns, 110

fields, 7477

in queries, 109

objects, 67

dependencies, 22

viewing, 22, 2425

dependent tables, 18

descriptions, inserting, 6061

Design view

opening in, 13

queries

creating, 86

crosstab queries, 94, 95

running, 87

saving, 105

select queries, 9192

table descriptions, inserting, 60

disabling error–checking for labels, 146

displaying. See viewing

E

editing

field properties, 7980

labels

on forms, 126

in reports, 145146

relationships, 24

entity classes, 16

error–checking, disabling for labels, 146

Excel data, linking to, 51

Export Text Wizard, 3334

exporting objects, 3136

F

fields

automatic values, 8082

descriptions, inserting, 6061

filtering on, 6872

formatting, 8082

freezing, 57, 58

hiding, 5758

inserting/deleting, 7477

properties, editing, 7980

in queries

changing, 109110

filtering, 112114

formatting, 114115

sorting, 111

viewing/hiding, 110111

renaming, 77

reordering, 110

sorting on, 6668

unfreezing, 58

validation rules, 7778

viewing hidden, 58

filtering

queries versus, 70

query fields, 112114

records, 6872

Find and Replace dialog box, 6366

finding data, 6366

footers, inserting

in forms, 133135

in reports, 154155

foreign keys, setting, 1718

formatting

fields, 8082

form controls, 122126

query fields, 114115

reports

headers/footers, 154155

images, 155156

multiple columns, 148149

orientation, 153154

properties, 151153

forms

controls

inserting/removing, 118120

labels, 126

margins/spacing, 132133

moving, 120121

setting properties, 122126

tab order, 129131

headers/footers, inserting, 133135

images, inserting, 135136

layouts, 121

printing, 2931

records, sorting, 131

freezing fields, 57, 58

G

grouping records in reports, 140143

groups in Navigation Pane, 710

H

headers, inserting

in forms, 133135

in reports, 154155

hiding

fields, 5758

objects in Navigation Pane, 710

query fields, 110111

HTML document data, importing into new table, 44

hyperlinks, 124

I

images, 124

on forms, 135136

in reports, 155156

Import Objects dialog box, 23

Import Spreadsheet Wizard, 41

Import Text Wizard, 42

importing

data, 26, 4041

appending records, 4749

into new table, 4147

objects, 26

queries, 3

tables, 3, 5254

inner joins, 21, 103

Input Mask Wizard, 81

input masks, 8082

Insert Hyperlink dialog box, 119

inserting

columns, 109

fields, 7477

in queries, 109

form controls, 118120

headers/footers

in forms, 133135

in reports, 154155

images

on forms, 135136

in reports, 155156

labels in reports, 145146

report controls, 143145

table descriptions, 6061

Total rows, 5859

J

join lines, 21

joins

in multiple–table queries, 102104

types of, 21

junction tables, 1920

K

keys

composite, 12

foreign, setting, 1718

primary

removing, 13

setting, 1213

L

labels, 123

editing

on forms, 126

in reports, 145146

inserting in reports, 145146

landscape orientation, 153

Layout view

form controls

headers/footers, 133135

images, 135136

inserting/removing, 118120

labels, 126

margins/spacing, 132133

moving, 120121

setting properties, 122126

tab order, 129131

reports

grouping/sorting records, 140143

headers/footers, 154155

images, 155156

inserting controls, 143145

labels, 145146

margins/spacing, 149151

multiple columns, 148149

orientation, 153154

properties, 151153

layouts for forms, 121

left–outer joins, 21, 103

Linked Table Manager dialog box, 50

linked tables, creating, 4952

linking tables, 1920

List Box Wizard, 119

list boxes, 124

logical operators, 112

M

make-table queries

creating, 100

described, 98

many-to-many database model, 1920

margins

for form controls, 132133

for report controls, 149151

modifying. See editing

moving form controls, 120121

multiple columns in reports, 148149

multiple-table queries, creating, 102104

N

navigation buttons, 124

Navigation Pane

customizing, 710

queries, running, 87

table descriptions, inserting, 60

O

objects. See also specific types of objects

deleting, 67

dependencies, 22

viewing, 22, 2425

exporting, 3136

hiding/viewing in Navigation Pane, 710

importing, 26

printing, 2931

saving queries as, 105

one-to-many database model, 19

one-to-one database model, 19

opening

Relationships window, 23

tables in Design view, 13

operators in queries, 112

orientation of reports, 153154

orphans, 25

outer joins, 21, 103, 104

Outlook folder data, importing into new table, 4647

P

padding

for form controls, 132133

for report controls, 149151

Page Numbers dialog box, 154

parameter queries, creating, 697

parent tables, 18

referential integrity, 2526

PDF files, saving queries as, 106

portrait orientation, 153

primary keys

removing, 13

setting, 1213

primary tables, 18

printing objects, 2931

properties

of fields, editing, 7980

of form controls, setting, 122126

of images, 135136

of reports, formatting, 151153

Q

queries

action queries, creating, 97102

append queries

creating, 101

described, 9299

crosstab queries, creating, 9295

delete queries

creating, 102

described, 99

fields

changing, 109110

filtering, 112114

formatting, 114115

sorting, 111

viewing/hiding, 110111

as filters, 72

filters versus, 70

importing, 3

make-table queries

creating, 100

described, 98

multiple-table queries, creating, 102104

operators in, 112

parameter queries, creating, 9697

running, 87

saving, 104106

select queries, creating, 8892

update queries

creating, 101

described, 99

Query Designer, 86, 8889

R

records

appending, 4749

filtering, 6872

grouping in reports, 140143

printing, 2931

sorting, 6668

in forms, 131

in reports, 140143

referential integrity, 2526

relation tables, 1920

relational database models, 16, 1820

relationships, 1317. See also keys

editing, 24

queries and, 88

in Relationships window, 2324

removing, 24

setting, 2025

Relationships window

opening, 23

relationships in, 2324

tables in, 23

removing

form controls, 118120

primary keys, 13

relationships, 24

tables

from queries, 104

from Relationships window, 23

renaming fields, 77

reordering fields, 110

replacing data, 6366

reports

controls

inserting, 143145

labels, 145146

selecting, 152

formatting

headers/footers, 154155

images, 155156

margins/spacing, 149151

multiple columns, 148149

orientation, 153154

properties, 151153

printing, 2931

records, grouping/sorting, 140143

right-outer joins, 21, 103

running

append queries, 101

delete queries, 102

make-table queries, 100

queries, 87

saved exports, 35, 36

saved imports, 6

update queries, 101

S

saving

export operations, 33, 35, 36

filters as queries, 72

import operations, 4, 56

queries, 104106

select queries, creating, 8892

selecting report controls, 152

setting

foreign keys, 1718

form control properties, 122126

primary keys, 1213

relationships, 2025

tab order, 129131

showing. See viewing

Simple Query Wizard, 8889, 9091

sorting

query results, 111

records, 6668

in forms, 131

in reports, 140143

spacing

for form controls, 132133

for report controls, 149151

SQL Server, 52, 53

subforms/subreports, 124, 144145

Subreport Wizard, 143144

summary values, inserting Total rows, 5859

T

tab order, setting, 129131

tables

data

appending records, 4749

importing into new table, 4147

descriptions, inserting, 6061

fields

freezing, 57, 58

hiding, 5758

unfreezing, 58

viewing hidden, 58

foreign keys, setting, 1718

importing, 3, 5254

linked, 4952

multiple-table queries, creating, 102104

opening in Design view, 13

parent/child, 18

primary keys

removing, 13

setting, 1213

referential integrity, 2526

relationships, 1317

editing, 24

queries and, 88

removing, 24

setting, 2025

in Relationships window, 23

Total rows, inserting, 5859

tabs, 124

text boxes, 123

text data

importing into new table, 4546

linking to, 5051

Total rows, inserting, 5859

U

unfreezing fields, 58

update queries

creating, 101

described, 99

V

validation rules, creating, 7778

viewing

dependencies, 22, 2425

hidden fields, 58

objects in Navigation Pane, 710

query fields, 110111

relationships in Relationships window, 23

tables in Relationships window, 23

W

web browsers, 124

X

XML data, importing into new table, 4445

XPS files, saving queries as, 106