Microsoft® Access 2002 Proficient User CBT Training CD

Rating:
Summary: Microsoft® Access 2002 Proficient User CBT Training CD
Review: Microsoft Access 2002 Proficient User
Course Overview
This courses covers more advanced features of Access 2002. Individuals will learn how to make different types of data queries, work with forms and link data to other databases.

Learn To
Create a single-table query in Design view.
Create a multiple-table query in Design view.
Create a simple query by using the Simple Query Wizard.
Identify features of the Form Wizard.
Identify features of the AutoForm Wizard.
Add a record to a form.
Identify features of the Report Wizard.
Print a report from Print Preview.
Add a control label to a report.
Identify options of the Import Spreadsheet Wizard that are used to import an Excel worksheet to a data access page.
Link an existing Microsoft Access table to a database.
Publish a table to Microsoft Excel.

Audience
The intended audience for this course are Project or Office Managers, Secretarial, Web Designer-Developers, System Administrators, and Database Administrators. Typically learners will work in an office environment (possibly networked) producing documents/spreadsheets and/or databases/Web pages. Learners will need a basic knowledge of either Microsoft Office 97 or 2000 programs and be familiar with Windows 9X or later operating system(s).

Deployment Options
e-Learning

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

Language Options
French, Dutch, Spanish, Russian, Chinese, Italian, German, Arabic, Polish, US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Querying Data - 2 hours
Create a single-table query in Design view.
Create a multiple-table query in Design view.
Create a simple query by using the Simple Query Wizard.
Match query wizards with their functions.
Identify the effects of opening queries.
Sort a query by output.
Apply a criterion to a query.
Apply an aggregate tool to a query.
Add a table to a query.
Add a calculated field to a query.
Match the field properties with their features.

Unit 2: Forms Introduction - 2 hours
Identify features of the Form Wizard.
Identify features of the AutoForm Wizard.
Add a record to a form.
Insert a picture into a field.
Add an unbound control image to a form.
Identify features of controls in a form.
Add a calculated text box to a form.
Format controls by using the Formatting toolbar.
Match form control properties with their functions.
Add a section to a form by using the menu bar.
Identify functions of the Form Properties sheet.

Unit 3: Reports and Data Access Pages - 2 hours
Identify features of the Report Wizard.
Print a report from Print Preview.
Add a control label to a report.
Modify a control layout in a report.
Add a calculated text box to a report.
Format the data display for a control in a report.
Modify the control properties in a report.
Add a section to a report.
Modify the report properties in a report.
Identify features of the Page Wizard that are used to create data access pages.
Sort a record on a data access page in Page view.
Group records on a data access page in Page view.

Unit 4: Database Integration - 2 hours
Identify options of the Import Spreadsheet Wizard that are used to import an Excel worksheet to a data access page.
Link an existing Microsoft Access table to a database.
Publish a table to Microsoft Excel.
Publish a report to Microsoft Word.
Export a database object to Hypertext Markup Language (HTML).
Import an Extensible Markup Language (XML) document.
Export a database object as an XML document.