Access 2003 : Level 1
Prerequisites
To ensure your
success, we recommend you first take the following courses or have
equivalent knowledge:
Performance-Based Objectives
Upon successful completion of
this course, students will be able to:
-
examine the Microsoft® Office
Access 2003 database application.
-
manage the data in a
database.
-
examine existing table
relationships.
-
query the database.
-
design simple forms.
-
create and modify Access
reports.
Course content
Lesson 1: An Overview of Access 2003
Topic 1A: Relational Databases
Topic 1B: The Access Environment
Topic 1C: The Database Environment
Topic 1D: Examine an Access Table
Lesson 2: Managing Data
Topic 2A: Examine an Access Form
Topic 2B: Add and Delete Records
Topic 2C: Sort Records
Topic 2D: Display Record Sets
Topic 2E: Update Records
Topic 2F: Run a Report
Lesson 3: Establishing Table Relationships
Topic 3A: Identify Table
Relationships
Topic 3B: Identify Primary and Foreign Keys in the Relationships Window
Topic 3C: Working with Subdatasheets
Lesson 4: Querying the Database
Topic 4A: The Select Query
Topic 4B: Add Criteria to a Query
Topic 4C: Add a Calculated Field to a Query
Topic 4D: Perform a Calculation on a Record Grouping
Lesson 5: Designing Forms
Topic 5A: Form Design Guidelines
Topic 5B: Create AutoForms
Topic 5C: Create a Form Using the Form Wizard
Topic 5D: Modify the Design of a Form
Lesson 6: Producing Reports
Topic 6A: Create an AutoReport
Topic 6B: Create a Report by Using the Wizard
Topic 6C: Examine a Report in Design View
Topic 6D: Add a Calculated Field to a Report
Topic 6E: Modify the Format Properties of a Control
Topic 6F: AutoFormat a Report
Topic 6G: Adjust the Width of a Report
|
