Microsoft® Access 2003 Fundamentals CBT Training CD

Rating:
Summary: Microsoft® Access 2003 Fundamentals CBT Training CD
Review: Course Overview
This course, along with course 75051, maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. It presents the learner with the fundamentals of Microsoft Access 2003. The student learns how to create tables and relationships, how to manipulate tables, and how to create simple and advanced queries.

Learn To

To identify options in the New File task pane.
To identify functions of database object views
To identify options in the Table Wizard
To identify table field properties
To create an input mask for a table field
To identify options in the Lookup Wizard
To identify options in the Simple Query Wizard
To create a multiple-table query
To identify elements in Select Query Design view

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
Dutch, French, Spanish, German, US English

Total Learning Time
3 to 4 hours

Objectives
Unit 1: Table Basics 1 hour

Identify options in the New File task pane
Identify functions of database object views.
Identify options in the Table Wizard
Create a table in Design view
Identify options in the Table Properties dialog box
Identify methods of managing data in Datasheet view
Create a one-to-many relationship

Unit 2: Manipulating Tables 1 - 1.5 hours

Create an input mask for a table field
Identify options in the Lookup Wizard
Identify options in the Find and Replace dialog box
Filter records by form
Identify options on the Formatting (Datasheet) toolbar
Sort records in a table
Filter records by selection
Identify the options for navigating records
Identify table field properties

Unit 3: Querying Data 1 - 1.5 hours

Identify options in the Simple Query Wizard
Identify elements in Select Query Design view
Apply an aggregate function to a query
Identify components of a calculated field
Identify options in the Crosstab Query Wizard
Identify options in the Find Unmatched Query Wizard
Create a multiple-table query
Identify options in the Find Duplicates Query Wizard