Microsoft MOS Access Certification Training
MOS Access 2003 Course Overview
 This curriculum maps to the Microsoft Office Specialist certification objectives for
the Access 2003 Specialist exam. It presents the learner with the fundamentals of Microsoft Access 2003. The student learns how to create tables and relationships,
how to manipulate tables, and how to create simple and advanced queries. The curriculum teaches how to create forms and reports and how to format controls on
both forms and reports, and the student is also introduced to importing and exporting data to and from Access. This curriculum consists of two Skill Builder courses: Microsoft Access 2003 Fundamentals; Microsoft Access 2003 Proficient User
Learning Time Certification Training
6 to 8 Hours
Microsoft Access MOS Fundamentals Certification Course
Unit 1: Table Basics 1 hour
Identify options in the New File task pane.
Identify functions of database object views.
Identify options in the Table Wizard.
Create a table in Design view.
Identify options in the Table Properties dialog box.
Identify methods of managing data in Datasheet view.
Create a one-to-many relationship.
Unit 2: Manipulating Tables 1 - 1.5 hours
Create an input mask for a table field.
Identify options in the Lookup Wizard.
Identify options in the Find and Replace dialog box.
Filter records by form.
Identify options on the Formatting (Datasheet) toolbar.
Sort records in a table.
Filter records by selection.
Identify the options for navigating records.
Identify table field properties.
Unit 3: Querying Data 1 - 1.5 hours
Identify options in the Simple Query Wizard.
Identify elements in Select Query Design view.
Apply an aggregate function to a query.
Identify components of a calculated field.
Identify options in the Crosstab Query Wizard.
Identify options in the Find Unmatched Query Wizard.
Create a multiple-table query.
Identify options in the Find Duplicates Query Wizard.
Microsoft Access MOS Proficient Certification Course
Unit 1: Forms 1 - 1.5 hours
Identify options in the Form Wizard.
Identify AutoForms in the New Form dialog box.
Identify elements of a PivotChart.
Sort records in a form.
Identify options on the Formatting (Form/Report) toolbar.
Match form control properties with their functions.
Align a selection of form controls.
Space a selection of form controls vertically.
Add a section to a form by using the View menu.
Unit 2: Reports and Data Access Pages 1 - 1.5 hours
Identify options in the Report Wizard.
Identify options in the Page Wizard.
Set the sort order for a report.
Identify options in the Page Setup dialog box for setting up a report.
Identify options on the Print Preview toolbar for previewing a report.
Identify options in the Print dialog box for printing a report.
Match report control properties with their functions.
Identify options for summarizing fields in a report control.
Identify methods of manipulating report controls.
Unit 3: Database Integration and Tools 1 hour
Publish a table to Excel.
Identify options in the Import Spreadsheet Wizard.
Back up a database.
Compact and repair a database.
Identify features of object dependencies.
Identify options in the Documenter dialog box.
|
MOS Access 2003 CBT CD
|
$99.00
|
n75050d
|
|
|
MOS Word 2003- CBT CD
|
$99.00
|
n75022d
|
|
|
MOS Outlook 2003 CBT CD
|
$99.00
|
n75070d
|
|
|
MOS Excel 2003 CBT CD
|
$99.00
|
n75032d
|
|
|
MOS PowerPoint 2003 CBT CD
|
$99.00
|
n75041d
|
|
|
Microsoft FrontPage 2003 CBT CD
|
$99.00
|
n75091D
|
|
|
Complete Microsoft MOS 2003 Curriculum Training CD
Contains all the courses above
|
$299.00
|
n75000D
|
|
|
