Microsoft® Office Access 2003: Level 1

Course length: 1.0 day(s)

What is an Access 2003 Level 1 class?
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management, computer based applications, is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database and the Microsoft® Office Access 2003 relational database application and its information management tools.

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.

Prerequisites: To ensure the successful completion of Microsoft Access 2003: Level 1, we recommend completion of one of the following Element K courses, or equivalent knowledge from another source:

• Windows 2000: Introduction

• Windows XP: Introduction

• Windows XP: Level 1

• Windows XP: Level 2

Certification
This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

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