Microsoft Access 2000 Training Manual

Table of Contents: Module 1

GETTING STARTED

Understanding How Access Work

How To Start Access 2000

How To Open A Database

How To Close A Database

How To Exit Microsoft Access

Getting Familiar With The Access 2000 Screen

How To Use Menu

How To Show Or Hide Toolbars

How To Move Toolbar And Menu Bar

How To Use Toolbar Button

How To Use Shortcut Menu Using Right Mouse Click

How To Use Shortcut Key

Getting Help

How To Use Office Assistant Help
How To Use Contents Help
How To Use Answer Wizard Help
How To Use Index Help
How To Use What's This Help 

Working With Database Objects

How To Open A Table
How To Open A Query
How To Open A Form
How To Open A Report
How To Rename An Object

 

WORKING WITH DATA
Managing Data

How To Navigate Through Records
How To Move To A Specific Record
How To Add Records
How To Edit Records
How To Delete A Record
How To Delete A Few Records

Controlling And Searching Records

How To Sort Records
How To Find Record
How To Filter Records By Selection
How To Filter Records By Criteria

WORKING WITH TABLES AND RELATIONSHIPS
Creating and Customizing Tables

How To Create A New Blank Database
How To Create A New Table
How To Set Primary Key
How To Rearrange Fields
How To Add Field
How To Delete Field
How To Change Data Type

Get External Information

How To Import Table
How To Link Tables

Managing Relationships

How To Delete Table Relationship
How To Create Table Relationships

EXERCISES

Exercise - Getting Started
Exercise - Working With Data
Exercise - Working With Tables And Relationships

 

Microsoft Access 2000 Training Manual

Table of Contents: Module 2

 

CREATING AND CUSTOMIZING QUERIES
Creating Select Queries

How To Create Queries Quickly

Controlling Queries Output

How To Open / Switch Query To Design View
How To Rearrange Fields
How To Delete A Field
How To Add A Field
How To Sort The Query Output
How To Filter The Query Output With Criteria
How To Set Multiple Criteria
How To Hide A Field

 

CREATING AND CUSTOMIZING FORMS
Creating Forms Effectively

How To Create A Form Quickly With AutoForm
How To Save And Rename Form
How To Create A Form Using Form Wizard

Customizing Forms

How To Open Form Design View

How to Show / Hide Field List
How to Show / Hide Toolbox
How To Resize Control
How To Move Both Control And Label
How To Move Control And Label Separately
How To Delete A Field Control
How To Add A Field Control

 

CREATING USEFUL REPORTS
Creating Reports

How To Create A Report Using AutoReport
How To Create Mailing Labels
How To Set Page Margin
How To Change Page Orientation
How To Number Pages

 

MANAGING AND MAINTAINING DATABASE
Compacting and Repairing Database

How To Compact and Repair Database
How Compact Database Automatically

Converting Access Database

How To Convert Database To Access 2000 File Format

 

EXERCISES

Exercise - Creating And Customizing Query
Exercise
- Creating And Customizing Forms
Exercise
- Creating Useful Reports

 

 


©2003 EBook Publishing. All rights reserved.


Web Site:
http://www.computertrainingmanual.com
Email: info@computertrainingmanual.com