Microsoft Access 2003 Training Manual

Table of Contents: Module 1

GETTING STARTED

Understanding How Access 2003 Work

What's New In Access 2003

How To Start Access 2003

How To Open A Database Using Task Pane

How To Close A Database

How To Exit Access 2003

Getting Familiar With The Access 2003 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 And Maintenance

How To Search Help  
How To Use Content Help
How To Use Microsoft Office Online  
How To Use Type A Question For Help Box
How To Use Office Assistant Help
How To Use Get Help In A Dialog Box

How To Get Office Updates From Microsoft Office Online  

How To Detect And Repair Errors In Access  
How To Recover Access When It Is Not Responding  

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 2003 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

Backing Up and Converting Access Database

How To Back Up Database  

How To Convert Database To Access 2003 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.computertrainingmaterial.com
Email: info@computertrainingmaterial.com