|
|
MS Office Certification Access Beginning Access Intermediate Access Advanced I Access Advanced II
|
|
1.
Structuring a Database
What data should be calculated?,
44
Relationships:
One to one,
27
Relationships:
One to many,
28
Define join type,
93
2.
Formatting Database Elements
Fields: Date/Time,
15
Forms: Design View,
16
Forms: Datasheet View,
31
Forms: Multiple Item,
39
Forms: Split Forms,
41
Forms: Subforms,
29
Forms: Layout view,
75
Reports: Use the Report Wizard,
96
Reports: Create aggregate fields,
47
Reports: Print Layout,
97
Controls: Add fields from a table,
19
Controls: Use the Ribbon,
24
Control: Bind controls to fields,
43
Microsoft Access 2007 Study Guide
Microsoft Certified
Application Specialist (MCAS): Microsoft Access 2007 Exam 77-605
Guide topics
|
4. Creating and Modifying Queries
Queries: Add fields to queries,
22
Queries: Based on more than one table,
92
Query: CROSSTAB,
120
Query parameters,
107
Query joins: LEFT,
100
Query design: calculated fields,
99
Query design: Add fields to calculations,
99
Query design: Use arithmetic,
101
Query calculations: SUM,
123
Query calculations: AVERAGE,
123
Query calculations: Min/Max,
123
Query calculations: COUNT,
117
5. Presenting and Sharing
Data
Sort data within forms,
104
Save objects as other file types,
80
Save as an XPS file,
80
|
6. Maintaining Databases
Open databases: Exclusively,
126
Open databases: Shared access,
125
Save databases as a previous version,
79
Encrypt databases using passwords,
127
Enable error checking,
122
Navigation pane: show/hide,
73
Startup display form,
71
Database properties,
77
Database properties,
77
Database Documenter,
128
|
|
