Microsoft Access 2003: Level 1

Revision: TE5601_20060318

(5.01 KB) View, Download, or Print Catalog as a PDF.

Course Length:

1 Day

Course Description:

In this course, students will be introduced to the concept of the relational database and the Microsoft® Office Access 2003 relational database application and its information management tools. This is one of a series of courses 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.

Who Should Attend:

This course is designed for the individual whose responsibilities include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications.

Benefits of Attendance:

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

Prerequisites:

Students should have taken Windows 2000: Introduction, Windows XP: Introduction, Windows XP: Level 1 or Windows XP: Level 2 or equivalent knowledge.

Course Outline:

• Chapter 1: An Overview Of Access 2003
  1. Relational Databases
  2. The Access Environment
  3. The Database Environment
  4. Examining an Access Table
• Chapter 2: Managing Data
  1. Examining an Access Form
  2. Adding and Deleting Records
  3. Sorting Records
  4. Displaying Record Sets
  5. Updating Records
  6. Running a Report
• Chapter 3: Establishing Table Relationships
  1. Identifying Table Relationships
  2. Identifying Primary and Foreign Keys in the Relationships Window
  3. Working with Subdatasheets
• Chapter 4: Querying The Database
  1. The Select Query
  2. Adding Criteria to a Query
  3. Adding a Calculated Field to a Query
  4. Performing a Calculation on a Record Grouping
• Chapter 5: Designing Forms
  1. Forming Design Guidelines
  2. Creating AutoForms
  3. Creating a Form Using the Form Wizard
  4. Modifying the Design of a Form
• Chapter 6: Producing Reports
  1. Creating an AutoReport
  2. Creating a Report by Using the Wizard
  3. Examining a Report in Design View
  4. Adding a Calculated Field to a Report
  5. Modifying the Format Properties of a Control
  6. AutoFormatting a Report
  7. Adjusting the Width of a Report
• Appendix A: Microsoft Office Specialist Program