21 Hours
Course Objectives (Exam 77-855)
The typical candidate for the exam works as a user support professional, trainer, teacher, professor, database user, or database creator who needs to create or maintain a basic Access database. Users can create, modify, and extend functionality of basic database objects, including tables, queries, forms, and reports. Users can also construct and modify basic relationships among database entities and can instruct others in basic Access functionality and usage.
Course Outline
Managing the Access Environment
Create and manage a database.
Configure the Navigation Pane.
Apply Application Parts.
Building Tables
Create tables.
Create and modify fields.
Sort and filter records.
Set relationships.
Import data from a single data file.
Building Forms
Create forms.
Apply Form Design Tab options.
Apply Form Arrange Tab options.
Apply Form Format Tab options.
Creating and Managing Queries
Construct queries.
Manage source tables and relationships.
Manipulate fields.
Calculate totals.
Generate calculated fields.
Designing Reports
Create reports.
Apply Report Design Tab options.
Apply Report Arrange Tab options.
Apply Report Format Tab options.
Apply Report Page Setup Tab options.
Sort and filter records for reporting. |
|