|
|
Office Certification Access Excel Outlook PowerPoint Word Vista
Index Beginning Microsoft Access 2007 Exam 77-605
Guide
|
Compact and repair databases,
110
Control: Anchor,
124
Controls: Use the Ribbon,
104
Controls: Align,
123
Controls: Conditional Formatting,
130
Controls: Format Font,
68
Controls: Format foreground,
68
Controls: Format currency,
107
Controls: Group and ungroup,
126
Controls: Tab order,
71
Create tables in Design view,
24
Create tables from templates,
53
Create tables that do not contain repeating
groups (3NF),
42
Currency field options,
99
Data: Find and Replace,
21
Data: Find using criteria,
21
Data: Find using wildcards,
40
Data: Delete records,
19
Data: Navigate records,
17
Data: Navigate to a specific record,
21
Data: Navigate to the first or last,
20
Default AutoNumber key,
30
Define 3NF tables,
43
Define a field as the primary key,
31
Define and modify primary keys,
30
|
Define join type,
51
Define table fields,
28
Define tables based on the data,
42
Enforce referential integrity,
49
Cascade delete,
50
Cascade update,
50
Fields: AutoNumber,
30
Fields: Currency,
99
Fields: Number,
25
Fields: Text,
26
Fields: Text,
78
Filter data within tables,
23
Filter data: Remove filters,
23
Forms: AutoFormat,
66
Forms: Design View,
62
Forms: Layout view,
65
Forms: Simple form design,
59
Memo field options,
100
Modify properties: Captions,
40
Modify properties: Data Validation,
39
Modify properties: Input Mask,
34
Modify properties: Text length,
33
Modify relationships,
48
Modify table properties,
28
Multi-field primary keys,
99
Multi-value fields,
38
|
Queries: Add all fields to queries,
95
Queries: Add fields to queries,
90
Queries: Based on one table,
89
Query design: Add tables,
89
Query design: Criteria,
93
Query design: Delete tables,
90
Query design: Use aliases,
98
Query: UPDATE,
101
Report Layout- Arrange controls,
118
Reports: AutoFormat,
119
Reports: Define Group Headers,
126
Reports: Simple report design,
117
Select the correct number type,
25
Sort data within queries,
92
Table Analyzer,
46
Tables: Delete,
90
Tables: Rename,
54
Use Boolean Operators,
96
Use Text or Number fields,
25
What data needs to be stored?,
25
|
|
