Self-Study QuickSkill Course Access 2002 (Office XP): Level 1
Series: Office XP - Access 2002
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8
Course Type: Self-Study QuickSkill Course


Access 2002: Level 1 familiarizes students with the basics of Access 2002. Students will learn how to create and use database objects, including tables, queries, forms, and reports.

Table of Contents

Lesson 1: Overview of Access 2002
  Introduction to Database Concepts and Terminology
  An Introduction to Access 2002
  Database Planning and Design
Lesson 2: Creating Tables
  Examining a table
  Creating a Table by Using the Table Wizard
  Creating a Table in Design View
Lesson 3: Working with Tables
  Modifying the Table Design
  Finding and Editing Records
  Filtering and Sorting Records
Lesson 4: Using Select Queries
  Selecting Fields and Sorting Records in a Query
  Refining the Results of a Query
  Using Queries to Perform Calculations
  Joining Tables in a Query
Lesson 5: Creating and Using Forms
  Creating a Form
  Modifying the Form Design
  Using a Form to Locate and Organize Information
Lesson 6: Creating and Using Reports
  Creating a Report
  Creating a Report that Contains Totals
Lesson 7: Creating and Maintaining a Database
  Creating a Database
  Database Maintenance