Courses
Databases              
Graphics                 
Internet                  
Mail                         
PC/Windows           
Project Mgmt           
Spreadsheets         
Word Processing    
Information
 Courseware              
 Classfiles                   
 Pricing                       
 Discoverware            
 
home page contact email us. copyright index
Access 2000 User Specialist

Intended Audience

This two day course is intended for students who wish to prepare for the Microsoft Office User Specialist exam for Access 2000.

Purpose

The purpose of this course is to teach introductory to intermediate features of Access 2000 to allow participants to create and customize a database. By the end of this course, the student should be able to create database tables, enter data into the tables, extract information from the tables, and produce forms and reports based on tables or queries.
This course is intended to be completed in sequential order.

Prerequisites

Students should be familiar with the use of personal computers, understand basic file concepts (such as the use of files and folders for storing information) and be comfortable working in the Windows 95/98/2000 or Windows NT 4.0 environment. It is recommended that users unfamiliar with Windows take an Introduction to Windows course before taking this course.
Knowledge of database concepts is not assumed.

Course Content

Working with Access

What is a Database?
The Database Window

Designing a Database

Creating a Database File
Planning a Database
Creating a Table
Defining a Table's Structure
Entering Data in Datasheet View
Importing and Linking Tables

Modifying Tables

Copying, Deleting, and Renaming a Table
Modifying Fields and Data Types
Setting Field Properties

Maintaining Data

Navigating in Datasheet or Form View
Sorting Records
Modifying Data Manually
Changing Column Widths
Freezing Columns

Finding Data

Find and Replace
Filters
Queries

Defining Relationships

Relational Databases
Table Relationships

Multi-Table & Calculated Queries

Creating Two-Table Queries
Creating Multi-Table Queries
Calculating Fields

Building and Modifying Forms

Using the Form Wizard
Modifying a Form in Design View
Selecting, Moving, and Sizing Controls
Changing the Color, Font, and Alignment of Controls
Adding and Deleting Controls
Control Properties

Producing Reports

Printing from the Database Window
Using the Report Wizard
Modifying a Report in Design View