Microsoft Access 97 - Part 2

Course Code NGE71052

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 the second of a two part series which will cover the skills necessary for the Expert User certification exam. The unique Skill Builder instruction uses simulation, questioning, practice, quizzes and multiple study paths to create a learning environment that enhances your enjoyment and comprehension. Preassessment testing in the beginning of each unit will allow you to have a personalized study path based on the knowledge and skills demonstrated. Mastery tests at the end of each unit allow you to verify your understanding of key skills and guide you back to any content that warrants further study.

Audience

This course is intended for anyone who is interested in learning the capabilities of Microsoft Access 97. Participants should have taken Microsoft Windows 95 Fundamentals (Course 70011) and the first course in this series.

Prerequisites

(Currently no course prerequisite information)

Objective

• Create and customize a form to interact with the database.
• Present data in the form of reports, and utilize the web capability.

Topics Include

Unit 1: Working with Forms

• Create and modify controls on a form.
• Add records to a form.
• Switch between views of a form.
• Show related records.
• Add expressions to calculated controls.
• Add records using a subform.
• Create a subform in a form that takes data from a given table.
• Use the Form Wizard to title a form.
• Modify a form design.
• Improve accuracy in forms.
• Print a form.

Unit 2: Presenting Data

• Create a report from the table using the AutoReport option.
• Create a report using the Report Wizard.
• Print a report.
• Customize and manage reports.
• Add a label to a report.
• Customize objects in a report: Headers Footers
• Add a calculated value to a report.
• Group data by the field name in a report.
• Sort data in a report: Ascending order Descending order
• Create hyperlinks in a table to store Internet addresses.
• Build order forms for Internet use.
• Create a chart.
• Insert a chart in a form with Chart Wizard.

Duration

6

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