Course Detail

Microsoft Access 2003 - Introduction

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