INTRODUCTION COURSE OUTLINE

One day

Keyboard familiarity.  Must have a basic working knowledge of Microsoft Windows environment.

Upon successful completion of the course the delegate will be able to create, open, edit, save and print databases.

Keyboard Shortcuts

Introduction

• What is Microsoft Access?
• Geography of the Screen
• What is a Database?
• Menus, Commands and Dialogue Boxes
• Keyboard , Mouse and Window Control

Design a Database

• Database Design Process
• The Purpose of Tables, Fields and Records
• Relationships within a Database

Create a New Database

• Create a New Database
• The Database Window
• Working with Fields and Records
• Save a Database
• Print a Database

Open, Copying & Other Tasks

• Open an Existing Database
• Copy a Table

View a Database

• Open a Table in Datasheet View
• Open a Table in Design View

Move around a Database

• Scroll within a Database and use the Keyboard and Mouse

Tables

• What is a Table?
• Create a Table
• Add Fields & Set a Primary Key
• Relationships Between Tables
• Save a Table

Edit and Customise Tables

• Set Field & Table Properties
• Create an Index
• Edit Data Tables

Query Basics

• What is a Query & Why use Queries?
• Create a Query
• Save a Query
• Views in the Query Window
• Choose Fields & Specify a Sort Order
• Specify a Criteria
• View and Set Properties

Form Basics

• What are Forms & Why Use Forms?
• Create a Form
• Views in the Form Window
• Select, Move and Adjust Controls
• Preview a Form
• Save a Form

Report Basics

• What are Reports & Why use Reports?
• Create a Report
• Views in the Report Window
• Preview a Report
• Print a Report
• Save a Report