Microsoft® Access 2002 Expert User CBT Training CD

Rating:
Summary: Microsoft® Access 2002 Expert User CBT Training CD
Review: Microsoft Access 2002 Expert User
Course Overview
This course covers the more complex aspects of working with data using Access 2002. Assuming the learner is already proficient in Access, the course covers advanced features of database queries, and enhancing forms and reports.

Learn To
Create an update query.
Create a delete query.
Create an append query.
Create a form in Design view.
Modify section properties in a form.
Create a subform with the Form Wizard.
Create a report in Design view.
Modify section properties of a report.
Add a chart to a report.
Modify a database by using the Compact and Repair tool.
Convert a database from a previous version to Access 2002 format.
Distribute a database as an MDE file.

Audience
The intended audience for this course would include 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
Dutch, Polish, French, Chinese, Russian, Italian, Spanish, US English, German

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Advanced Queries - 2 hours
Create an update query.
Create a delete query.
Create an append query.
Create a make-table query.
Create a parameter query.
Create a crosstab query.
Create a union query.
Filter records with a query by using the OR criteria condition.
Filter records with a query by using the AND criteria condition.
Create a criterion query by using a form control.
Change a join type in a query.

Unit 2: Forms Enhancements - 2 hours
Create a form in Design view.
Modify section properties in a form.
Create a subform with the Form Wizard.
Add a subform to an existing form.
Create a switchboard form by using the Add-In tool.
Identify database startup options for Microsoft Access 2002.

Unit 3: Report / Data Access Pages Enhancements - 2 hours
Create a report in Design view.
Modify section properties of a report.
Add a chart to a report.
Add a subreport to an existing report.
Set sorting properties for a report.
Set group properties for a report.
Create a print preview command button.
Create an option group for a report.
Identify the syntax used when designing a report preview module.
Create a data access page in Design view.
Create a PivotTable on a data access page.
Create a PivotChart on a data access page.
Create a hyperlink on a data access page.

Unit 4: Access Tools - 2 hours
Modify a database by using the Compact and Repair tool.
Convert a database from a previous version to Access 2002 format.
Distribute a database as an MDE file.
Replicate a database by using the menu bar.
Encrypt a database.
Set a password for a database.
Grant access permissions to a database.
Identify the functions of the Database Splitter Wizard.
Apply a Linked Table Manager to a database.