|
Description
This course will provide the learner with the skills necessary to efficiently use MS Access 2000. It is also excellent preparation for the Microsoft Office User Specialist (MOUS) exam.
Audience
Designed for learners who currently use or are beginning to use MS Access 2000.
Prerequisites
Familiarity with the MS Windows environment, and ability to use a keyboard and mouse.
Objective
Upon completion of this course, the student will be able to:
- Plan and design databases
- Build and modify tables, forms, reports, and queries
- View and organize information
- Define relationships between databases
Topics Include
Access 2000 Basic I: Getting Started in Access
- Getting Started
- Planning and Designing Databases
- Working With Access Objects
- Creating a Database
Access 2000 Basic II: Working with tables and Form
- Building Tables
- Modifying Tables
- Building Forms
- Modifying Forms
Access 2000 Intermediate I: Working with records
- Switching Between Object Views
- Entering and Deleting Records
- Finding and Sorting Records
- Making Queries
Access 2000 Intermediate II: Creating Reports
- Organizing Information
- Defining Relationships
- Creating and Previewing Reports
- Modifying and Enhancing Reports
Access 2000 Advanced I: Advanced Access Tools
- Using Controls
- Intergrating With Other Applications
- Using Access Tools
Duration
10 hrs
Minimum Requirements
Shockwave 8.0, 200 MH Pentium CPU (266 recommended), 32 MB of available RAM, (64 recommended), Windows 95, 98, 2000 or NT; (Windows 2000 or NT require 64MB of RAM)
Media
|
