Microsoft Access 2000 Proficient User

Course Code NGE72051

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 that are looking to use the intermediate skills of Microsoft Access 2000. At the completion of this course, students will learn how to use Access 2000 to maintain tables and table data; manage Access 2000 data; create and modify forms; and create and modify report formats.

Audience

This course is intended for end users that are looking to use the intermediate features of Microsoft Access 2000. Participants should have completed Microsoft Windows 98 Fundamentals (Course 71011) or have equivalent knowledge and Microsoft Access 2000 Fundamentals (Course 72050).

Prerequisites

(Currently no course prerequisite information)

Objective

• Use Access 2000 to maintain tables and table data.
• Manage Access 2000 data.
• Create and modify forms.
• Create and modify report formats.

Topics Include

Unit 1: Access 2000 Tables

• Create a relationship between two tables.
• Enforce referential integrity on the basis of specified requirements.
• Display related records in a subdatasheet for a record in the Datasheet view.
• Print the relationships in an Access database from the Relationships window.
• Match the criteria for data integrity with their functions.
• Set a validation rule for a field of a table by using Expression Builder.
• Set validation text for a field of a table by using the Design view.
• Set the required property criterion for a given field of a table by using the Design view.
• Set up a lookup field in a given table by using the Design view.
• Identify the factors to be considered while selecting an appropriate data type for a field.
• Modify an input mask by using the Design view.
• Modify a lookup field in a table by using the Design view.

Unit 2: Applications and Database Administration

• Import data into a new Access 2000 table.
• Link the data from an Excel spreadsheet to an Access 2000 table.
• Add a hyperlink to a file by using the Datasheet view.
• Copy database objects to Excel by using the drag and drop method.
• Export a database object to a Web page.
• Back up a database by using the Backup utility.
• Restore a database from a backup copy by using the Backup utility.
• Compact an open database.

Unit 3: Access 2000 Forms

• Create a form by using the Form Wizard.
• Match the control types with their functions.
• Add controls to a form by using the Control Toolbox.
• Add a calculated control to a form by using the Control Toolbox.
• Modify the format properties of a form control.
• Add sections to a form.
• Enter a record in a form.

Unit 4: Access 2000 Reports

• Create a report by using the Report Wizard.
• Add sections to a report.
• Print a report.
• Add controls to a report.
• Add a calculated control to a report in the Design view.
• Resize a control in a report in Design View.
• Modify the format properties of a report.

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