Microsoft Access 2000 Level 1
Overview of Access
Introduction to Database Concepts and Terminology
Introduction to Access
Database Planning and Design
Creating Tables
Examining a Table
Creating a Table with the Table Wizard
Creating a Table in Design View
Types of Primary Keys
Working with Tables
Modifying a Table Using Design View
Finding and Editing Records
Filtering and Sorting Records
Creating and Using Select Queries
Creating a Select Query to View Specific Fields
Specifying Criteria in a Query to View Specific Records
Using Queries to Perform Calculations
Joining Tables in a Query
Creating and Using Forms
Creating a Form with the Form Wizard
Modifying the Form Design
Using a Form to Locate and Organize Information
Multiple-table Forms
Creating and Using Reports
Creating a Report with the Report Wizard
Creating a Report that Contains Totals
Creating and Maintaining a Database
Creating a Database
Managing a Database and Its Objects
Database Maintenance
Class Information
Duration: 1 day
Prerequisite: Basic knowledge of the windows environment, basic keyboard skills.
Course Materials: Course manual (074400S3)
Description: Students will learn the basic skills necessary to begin using Access 2000. They will design and create tables, queries, forms, and reports.