Microsoft® Access 2003 Proficient User CBT Training CD

Rating:
Summary: Microsoft® Access 2003 Proficient User CBT Training CD
Review: Course Overview
This course, along with course 75050, maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. Assuming knowledge of the fundamentals, it teaches how to create forms and reports and how to format controls on both forms and reports. The student is also introduced to importing and exporting data to and from Access. Finally, this course teaches about backing up and compacting and repairing databases.

Learn To
To identify options in the Form Wizard
To identify AutoForms in the New Form dialog box
To identify elements of a PivotChart
To identify options in the Report Wizard
To identify options in the Page Wizard
To set the sort order for a report
To publish a table to Excel
To identify options in the Import Spreadsheet Wizard
To back up a database

Audience
The target audience will range from new users to power users, although the vast majority will have had some exposure to previous versions of Access. Fundamental PC and Windows skills are assumed.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
Spanish, German, Dutch, French, US English

Total Learning Time
3 to 4 hours

Objectives
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.