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
|
