Microsoft Access 2000 Fundamentals

Course Code NGE72050

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

This course is intended for end users who are looking to use the fundamental capabilities of Microsoft Access 2000. Participants will learn to identify the basic features of Access 2000; create and maintain tables; and work with Access 2000 data.

Audience

This course is intended for end users who are looking to use the fundamental capabilities of Microsoft Access 2000.

Prerequisites

(Currently no course prerequisite information)

Objective

• Identify the concepts related to databases and the features of Access 2000.
• Create and maintain tables and table data.
• Locate and manipulate data.

Topics Include

Unit 1: Access 2000 Basics

• Identify the advantages of the database approach over the traditional approach for storing and accessing data.
• Match the relational database components with their definitions.
• Sequence the steps involved in planning a relational database.
• Match the Access 2000 interface components with their functions.
• Open an existing database in Access 2000.
• Identify the functions of each Access 2000 database object.
• Identify the object views available in Access 2000.
• Print database objects.
• Create a new database in Access 2000.
• Access help on a specified subject by using the office Assistant.

Unit 2: Access 2000 Tables

• Create a table by using the Table Wizard.
• Create a table by using the Design view.
• Create a table by entering data directly in the Data sheet view.
• Set a primary key for a table.
• Insert a field into a table.
• Modify the data type of a field.
• Modify the layout of a field by moving the field in the Design view.
• Modify the properties of a field.
• Create an input mask for a field in a table.
• Delete a field from a table.
• Enter data in a table.
• Customize the Datasheet view of a table.
• Navigate between the records in a database object.
• Modify the data in a table.
• Delete a record from a table.
• Copy items by using the Office Assistant.

Unit 3: Working with Access 2000 Data

• Locate a specific record in a table.
• Match the filters available in Access 2000 with their functions.
• Apply a filter to a table by specifying a search criterion.
• Apply Filter By Form to a table.
• Apply Filter Excluding Selection.
• Apply the Advanced Filter/Sort filter to a table.
• Remove a filter applied on a database object.
• Sort records of a table on a single field.
• Sort records of a table on multiple fields.
• Create a query based on a single table in the database.
• Create a query based on multiple tables in the database.
• Create a query by using the Simple Query Wizard.
• Save a query.
• Retrieve a query.
• Sort the output of a query on a specified field.
• Print the output of a query.
• Create a query with a summary to compute the data in a field of a table.
• Modify a query.
• Add a table to an existing query.
• Modify a field in a query to enable the query to perform custom calculations.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently, only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

Web Based Training