Access XP Expert User

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.

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

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

Skills-Based

Internet / Intranet, Download, LAN, Workstation

NASBA credits: 4 CPE Credits

American English

6 to 8 hours

1 - 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

1 - 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 Pa

This is primarily online training This is an online eLearning or CBT training program This program may be available on CD

Training Presented in: English