| |
main
home page / cover page
/ Microsoft Office Specialist Certification
Microsoft Office Specialist Certification GUIDE
The logo on the cover of Benchmark Series Microsoft
Access 2000 by Meredith Flynn and Nita Rutkosky means that Microsoft
has approved it as courseware that teaches students the skills necessary
to pass the Microsoft Office Specialist Core Certification
exam in Access 2000. These skills and the corresponding page numbers
of related instruction in the text are presented in a chart on the
page that precedes chapter 1 of each level and are also presented
below.
The Microsoft Office Specialist program is used to test and validate a
student’s skills and thereby supply objective proof to an employer
(or prospective employer) that the student knows how to use a program
efficiently and productively. For more information on the Microsoft Office Specialist program
and on certification testing sites, visit Microsoft’s Web site
at www.microsoft.com
or the specific Microsoft Office Specialist site at www.mous.net.
Access 2000: Core Level Microsoft Office Specialist Skills
Correlations
|
Coding No.
|
Objective/Sub-Objective
Topic
|
Content Pages
|
Exercise Pages
|
Chapter
|
|
AC2000.1
|
Planning and designing databases
|
|
|
|
|
AC2000.1.1
|
Determine appropriate data inputs for your
database
|
4-7, 83-84
|
|
1, 3
|
|
AC2000.1.2
|
Determine appropriate data outputs for your
database
|
18-21, 105, 122, 118-120
|
|
1,31
|
|
AC2000.1.3
|
Create table structure
|
7-14
|
10-12, 13-14
|
1
|
|
AC2000.1.4
|
Establish table relationships
|
47-49, 53-60
|
57-62
|
2
|
|
AC2000.2
|
Working with Access
|
|
|
|
|
AC2000.2.1
|
Use the Office Assistant
|
32-38
|
|
1
|
|
AC2000.2.2
|
Select an object using the Objects Bar
|
87, 91, 105, 108
|
91-92, 108-109
|
3
|
|
AC2000.2.3
|
Print database objects (tables, forms, reports,
queries)
|
18-21, 84-85
|
19, 21, 85
|
1, 3
|
|
AC2000.2.4
|
Navigate through records in a table, query,
or form
|
84-85
|
85
|
3
|
|
AC2000.2.5
|
Create a database (using a Wizard or in Design
View)
|
7-21, 133-140
|
10-14,16-18, 137-140
|
1, 4
|
|
AC2000.3
|
Building and modifying tables
|
|
|
|
|
AC2000.3.1
|
Create tables by using the Table Wizard
|
66-74
|
66-68, 70-72
|
2
|
|
AC2000.3.2
|
Set primary keys
|
49-52
|
50-52
|
2
|
|
AC2000.3.3
|
Modify field properties
|
23-29
|
|
1
|
|
AC2000.3.4
|
Use multiple data types
|
5-7, 10-11
|
10-11
|
1
|
|
AC2000.3.5
|
Modify tables using Design View
|
23-31
|
28-29, 30-31
|
1
|
|
AC2000.3.6
|
Use the Lookup Wizard
|
25-29
|
|
1
|
|
AC2000.3.7
|
Use the input mask wizard
|
23-29
|
|
1
|
|
AC2000.4
|
Building and modifying forms
|
|
|
|
|
AC2000.4.1
|
Create a form with the Form Wizard
|
87-93
|
91-93
|
3
|
|
AC2000.4.2
|
Use the Control Toolbox to add controls
|
100-103
|
101-102, 103-104
|
3
|
|
AC2000.4.3
|
Modify Format Properties (font, style, font
size, color, caption, etc.) of controls
|
96-103
|
96-103, 102-104
|
3
|
|
AC2000.4.4
|
Use form sections (headers, footers, detail)
|
100-103
|
101-102
|
3
|
|
AC2000.4.5
|
Use a Calculated Control on a form
|
103-104
|
103-104
|
3
|
|
AC2000.5
|
Viewing and organizing information
|
|
|
|
|
AC2000.5.1
|
Use the Office Clipboard
|
152-153
|
|
4
|
|
AC2000.5.2
|
Switch between object Views
|
14, 23, 27
|
27-29
|
1
|
|
AC2000.5.3
|
Enter records using a datasheet
|
15-18
|
|
1
|
|
AC2000.5.4
|
Enter records using a form
|
86-87
|
86-87
|
3
|
|
AC2000.5.5
|
Delete records from a table
|
22-23
|
22-23
|
1
|
|
AC2000.5.6
|
Find a record
|
22-23
|
22-23
|
1
|
|
AC2000.5.7
|
Sort records
|
31-32
|
32
|
1
|
|
AC2000.5.8
|
Apply and remove filters (filter by form and
filter by selection)
|
182-186
|
182-183, 184-186
|
5
|
|
AC2000.5.9
|
Specify criteria in a query
|
167-178
|
171-175, 177, 178
|
5
|
|
AC2000.5.10
|
Display records in a subdatasheet
|
63-65
|
|
2
|
|
AC2000.5.11
|
Create a calculated field
|
179
|
179
|
5
|
|
AC2000.5.12
|
Create and modify a multi-table select query
|
173-175
|
173-175
|
5
|
|
AC2000.6
|
Defining relationships
|
|
|
|
|
AC2000.6.1
|
Establish relationships
|
53-60
|
57-60
|
2
|
|
AC2000.6.2
|
Enforce referential integrity
|
55-60
|
57-60
|
2
|
|
AC2000.7
|
Producing reports
|
|
|
|
|
AC2000.7.1
|
Create a report with the Report Wizard
|
105-111
|
108-109, 110-111
|
3
|
|
AC2000.7.2
|
Preview and print report
|
108-109
|
108-109
|
3
|
|
AC2000.7.3
|
Move and resize a control
|
113-117
|
|
3
|
|
AC2000.7.4
|
Modify format properties (font, style, font
size, color, caption, etc.)
|
113-117
|
114-117
|
3
|
|
AC2000.7.5
|
Use the Control Toolbox to add controls
|
113-117
|
114-117
|
3
|
|
AC2000.7.6
|
Use report sections (headers, footers, detail)
|
113-117
|
114-117
|
3
|
|
AC2000.7.7
|
Use a Calculated Control in a report
|
113-117
|
114-117
|
3
|
|
AC2000.8
|
Integrating with other applications
|
|
|
|
|
AC2000.8.1
|
Import data to a new table
|
149-150
|
149-150
|
4
|
|
AC2000.8.2
|
Save a table, query, form as a Web page
|
154-158
|
|
4
|
|
AC2000.8.3
|
Add Hyperlinks
|
155-158
|
|
4
|
|
AC2000.9
|
Using Access Tools
|
|
|
|
|
AC2000.9.1
|
Print Database Relationships
|
56-60
|
57-60
|
2
|
|
AC2000.9.2
|
Backup and Restore a database
|
158-159
|
|
4
|
|
AC2000.9.3
|
Compact and Repair a database
|
159
|
|
4
|
|
