Microsoft Access Level 1

Training Menu

Microsoft Access Level 1

This is a one day, introductory class.

Target Student:

Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC). For example, students should be familiar with terms such as computer memory, data files, and program files. Students should also be familiar with the components that make up the PC, including input, output, and storage devices. Students should also be fairly comfortable working in the Windows environment. No prior knowledge of databases or Access is assumed.

Course outline:

Lesson 1: Overview of Access 2000

Topic 1A: Introduction to Database Concepts and Terminology

Topic 1B: Introduction to Access 2000

Topic 1C: Database Planning and Design

Lesson 2: Creating Tables

Topic 2A: Examining a Table

Topic 2B: Creating a Table with the Table Wizard

Topic 2C: Creating a Table in Design View

Topic 2D: Types of Primary Keys

Lesson 3: Working with Tables

Topic 3A: Modifying a Table Using Design View

Topic 3B: Finding and Editing Records

Topic 3C: Filtering and Sorting Records

Lesson 4: Creating and Using Select Queries

Topic 4A: Creating a Select Query to View Specific Fields

Topic 4B: Specifying Criteria in a Query to View Specific Records

Topic 4C: Using Queries to Perform Calculations

Topic 4D: Joining Tables in a Query

Lesson 5: Creating and Using Forms

Topic 5A: Creating a Form with the Form Wizard

Topic 5B: Modifying the Form Design

Topic 5C: Using a Form to Locate and Organize Information

Topic 5D: Multiple-table Forms

Lesson 6: Creating and Using Reports

Topic 6A: Creating a Report with the Report Wizard

Topic 6B: Creating a Report that Contains Totals

Lesson 7: Creating and Maintaining a Database

Topic 7A: Creating a Database

Topic 7B: Managing a Database and Its Objects

Topic 7C: Database Maintenance