Microsoft Access 2002: Level 2

Revision: TE1302_20060318

Course Length:

1 Day

Course Description:

This course is a hands-on instruction book that will introduce students the skills needed for creating, revising, and customizing the design of tables, queries, forms, reports, and data access pages. This course is also for those pursuing core-level Microsoft Office User Specialist (MOUS) certification in Access 2002.

Who Should Attend:

This course is for anyone who uses Access 2002 as a tool for getting their work done. Your responsibilities might include creating and/or revising the design of tables, queries, forms, reports, and data access pages.

Benefits of Attendance:

Upon completion of this course, students will be able to:

• Share data with other applications and enforce referential integrity.
• Modify the design of a table to streamline data entry and maintain data integrity.
• Use a filter to show records that match criteria and generate different query results by creating different types of joins between tables.
• Create select queries that display special records and design other types of queries, including parameter and action queries.
• Create forms and change their designs to enhance the appearance and usability of a form, and to make your form more professional.
• Create reports and change their designs to better organize and summarize information, and to improve the appearance by enhancing data layout and working with report pagination.
• Create, modify, and work with data access pages.

Prerequisites:

Students enrolling in this course should have a basic level of understanding of the Access 2000 interface, and should have experience designing tables, simple queries, forms, and reports. To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Windows 2000: Introduction, and Microsoft Access 2002: Level 1.

Course Outline:

• Chapter 1: Managing A Database And Data
  1. Import Data
  2. Maintain Record Integrity
  3. Exporting Data
  4. Documenting Table Relationships
• Chapter 2: Controlling Data Entry
  1. Make Data Entry More Accurate
  2. Make Data Entry More Efficient
  3. Facilitate Data Entry
• Chapter 3: Finding And Joining Data
  1. Find Data with Filters
  2. Get the Correct Data with Query Joins
  3. Building Bridges Between the Data
  4. Relating Data Within a Table
• Chapter 4: Creating Flexible Queries
  1. Summarizing Data with Queries
  2. Enter Criteria on the Fly
  3. Maintain Data with Queries
• Chapter 5: Improving Your Forms
  1. Enhance the Appearance of a Form
  2. Enhance the Usability of a Form
  3. Make Your Forms More Professional
  4. Display Form Data from Multiple Tables
• Chapter 6: Customizing Your Reports
  1. Organize Report Information
  2. Enhance Data Layout
  3. Working with Report Pagination
  4. Summarizing Information
  5. Add a Subreport to an Existing Report
  6. Creating Mailing Labels
• Chapter 7: Making Your Data Available On The Web
  1. Create a Data Access Page
  2. Improving the Look of a Data Access Page
  3. Editing Data Using a Data Access Page
  4. Group Records in a Data AccessPage