|
|
MS Office Certification Access Beginning Access Intermediate Access Advanced I Access Advanced II
|
|
1.
Structuring a Database
Define table fields,
28
What data needs to be stored?,
25
Use Boolean Operators,
96
Use Text or Number fields,
25
Select the correct number type,
25
Currency field options,
99
Memo field options,
100
Multi-value fields,
38
Define tables based on the data,
42
Define 3NF tables,
43
Create tables that do not contain repeating
groups (3NF),
42
Modify relationships,
48
Enforce referential integrity,
49
Cascade update,
50
Cascade delete,
50
Define join type,
51
Define and modify primary keys,
30
Define the primary key,
31
Multi-field primary keys,
99
Microsoft Access 2007 Study Guide
Microsoft Certified
Application Specialist (MCAS): Microsoft Access 2007 Exam 77-605
Guide topics
|
2.
Formatting Database Elements
Controls: Add fields
104
Controls: Align,
123
Controls: Conditional Formatting,
130
Controls: Format Font,
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
Fields: AutoNumber,
30
Fields: Currency,
99
Fields: Number,
25
Fields: Text,
26
Forms: AutoFormat,
66
Forms: Design View,
62
Forms: Layout view,
65
Modify properties: Captions,
40
Modify properties: Data Validation,
39
Modify properties: Input Mask,
34
Modify properties: Text length,
33
Modify table properties,
28
Multivalued fields,
38
Report Layout- Arrange controls,
118
Reports: Define Group Headers,
126
Reports: Simple report design,
117
Table Analyzer: 46
Tables: Rename,
54
|
3. Entering and Modifying Data
Data: Delete records,
19
Data: Navigate records,
17
Data: Navigate to a specific
record,
21
Data: Navigate to the first or
last,
20
Data: Find using criteria,
21
Data: Find using wildcards,
40
Data: Find and Replace,
21
4. Creating and Modifying Queries
Queries: Based on one table,
89
Queries: Add all fields to queries,
95
Query: UPDATE,
101
Query design: Add tables,
89
Query design: Criteria,
93
Query design: Use aliases,
98
5. Presenting and Sharing
Data
Sort data within queries,
92
Filter data within tables,
23
Filter data: Remove filters,
23
6. Maintaining Databases
Compact and repair databases,
110
|
|
