Fundamentals of MS Access 2000

Course Code IP0540

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 familiarizes the students with the database fundamentals and teaches them how to perform database maintenance using MS Access.  This course focuses on creation and design of databases and tables.  The students will also learn the concept of querying tables.

Audience

Application Developers who implement a simple database solution using Microsoft Access 2000 database management system.

Prerequisites

The student should be familiar with MS Office 95/97.   The user should also be familiar with using Windows 95/98.

Objective

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

describe databases describe relational databases list features of Microsoft Access open a database in Access design a database create a new database create a new table customize a table define relationships between tables display sorted and filtered data create a query using wizards create a query from scratch customize a query add multiple tables to a query

Topics Include

Introduction to Microsoft Access

• Database Concepts
• Overview of Microsoft Access

Creating Databases and Tables

• Creating Databases
• Creating Tables
• Manipulating Tables

Using Access Queries

• Creating Queries
• Customizing Queries

Duration

3 hrs

Minimum Requirements

This was a test

Media

Web Based Training