Advanced Features of MS Access 2000

Course Code IP0600

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 course in a series of two in the Access 2000 curriculum. This course is meant for students who want to understand the fundamentals of databases through MS Access. This course focuses on creation and design of forms, reports, and pages. The students will also learn the concept of database security and administration.

Audience

All System Administrators, Help Desk/Support personnel, and Application Developers who implement a database solution using Microsoft Access 2000 database management system.

Prerequisites

Before taking this course, the student should be familiar with MS Office 95/97. The student should also be proficient in using Windows 95/98 operating systems. Additionally, the student should be able to create and design databases and tables, and query tables.

Objective

Upon completion of this course the student will be able to:

create and customize a form create a chart create a pivot table create and customize a report print mailing labels and envelopes design, create and publish a data access page secure a database create security accounts for accessing a database compact and repair a database create replicas of a database

Topics Include

Forms, Charts and Pivot Tables

• Managing Forms
• Creating Charts and Pivot Tables

Working with Reports

• Creating Reports
• Customizing Reports

MS Access on the Web

• Creating Data Access Pages
• Working with Data Access Pages

Securing & Administering Databases

• Securing Databases
• Administering Databases

Duration

4 hrs

Minimum Requirements

Netscape or Internet Explorer (versions 4.0 or higher). Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display; Macromedia Shockwave Version 6.02 or higher.

Media

Web Based Training