ACCESS 2002 (XP) - Level 1


COURSE OUTLINE  

Lesson 1: Managing a Database and Data
Topic 1A: Import Data
Topic 1B: Maintain Record Integrity
Topic 1C: Exporting Data
Topic 1D: Documenting Table Relationships

Lesson 2: Controlling Data Entry
Topic 2A: Make Data Entry More Accurate
Topic 2B: Make Data Entry More Efficient
Topic 2C: Facilitate Data Entry

Lesson 3: Finding and Joining Data
Topic 3A: Find Data with Filters
Topic 3B: Get the Correct Data with Query Joins
Topic 3C: Building Bridges Between the Data
Topic 3D: Relating Data within a Table

Lesson 4: Creating Flexible Queries
Topic 4A: Summarizing Data with Queries
Topic 4B: Enter Criteria on the Fly
Topic 4C: Maintain Data with Queries

Lesson 5: Improving Your Forms
Topic 5A: Enhance the Appearance of a Form
Topic 5B: Enhance the Usability of a Form
Topic 5C: Make Your Forms More Professional
Topic 5D: Display Form Data from Multiple Tables

Lesson 6: Customizing Your Reports
Topic 6A: Organize Report Information
Topic 6B: Enhancing Data Layout
Topic 6C: Working with Report Pagination
Topic 6D: Summarizing Information
Topic 6E: Add a Subreport to an Existing Report
Topic 6F: Creating Mailing Labels

Lesson 7: Making Your Data Available on the Web
Topic 7A: Create a Data Access Page
Topic 7B: Improving the Look of a Data Access Page
Topic 7C: Editing Data Using a Data Access Page
Topic 7D: Group Records in a Data Access Page