Microsoft Access 2000 Level 1
| Duration: | 1 day |
| Prerequisite: | Basic knowledge of the windows environment, basic keyboard skills |
| Course Materials: | Course manual (074400S3) |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | Students will learn the basic skills necessary to begin using Access 2000. They will design and create tables, queries, forms, and reports. |
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