alphabyte - IT and Training Consultants

Course Outline

Course:

Access 2000 Introduction

Duration:

2 days

Objectives:

This course is an introduction to the Microsoft relational database, Access 2000.  It includes an introduction to database design and terminology, alongside instruction on the database objects e.g. tables, forms, queries and reports.  The course lasts two days and comprises a mixture of demonstrations, tutor-led examples and student exercises.

Pre-Requisites:

Students should be familiar with the use of an IBM compatible PC and with the Windows operating system.  No prior knowledge of database terminology or Microsoft Access is assumed.  No programming experience is necessary.

Topics:

bullet

Introducing Access 2000
bullet

Database Overview

bullet

Access Overview

bullet

Starting Access

bullet

The Screen, Toolbars,

bullet

The Right Mouse Button Bar

bullet

About Microsoft Access

bullet

Opening a Database

bullet

Wizards & Cue Cards

bullet

Table Design
bullet

Normalisation

bullet

Field Names, Data Type, Descriptions, 

bullet

Field Properties, Field Size, Format

bullet

Custom Formats, Decimal Places

bullet

Input Masks

bullet

Caption, Values, Validation

bullet

Saving a design

bullet

Working with Tables
bullet

The Datasheet View

bullet

Editing, Adding, Deleting, Finding Records

bullet

Changing the look of the Datasheet

bullet

Printing the datasheet

bullet

Sorting Records in the Database

bullet

Filters

bullet

Creating, Saving, Loading a Query

bullet

Criteria & Filter Examples

bullet

Data Entry
bullet

Importing and Attaching Data

bullet

Import from Spreadsheet or Database

bullet

Queries
bullet

Creating a select Query

bullet

Adding, Linking  a Query in a table

bullet

Join properties

bullet

Parameter Queries

bullet

Calculation in Queries

bullet

Summary Queries

bullet

Action Queries

bullet

Forms & Reports
bullet

Using AutoForm & Form Wizard

bullet

Views, Modifying the Form Design

bullet

Form Properties

bullet

Using Report & Report Wizard

bullet

Including Calculated and Statistical Fields

bullet

Summary Expression

bullet

Generating Labels

bullet

Conditional Formatting

bullet

Security & Maintenance
bullet

Passwords

bullet

Compacting and Repair

Download Printer-Friendly copy (Word Format)

 
 
Proprietor: Kathy Jarvis
alphabyte, 19 Leigh Drive, Wickham Bishops, Essex CM8 3JS
Tel/Fax: 01621 892336  Mobile: 07710 534128  email: kathy@alphabyte.co.uk