Access DataBase access07

Topic

Content

Microsoft Access

Define the Database Window

Tables

Field Names, Data Types & Properties
Table operations, inputting, sorting, finding data

Forms

Design a form based on a table
The Form Wizard
Format the form
Form Properties
Form view/Form Design
Use of Combo Boxes

Queries

Design the main query
Set sort sequence
Request criteria

Record Source

Redefine Record Source
Create new queries based on main query
Write advanced criteria

Reports

Write a Report
The Report Wizard
Edit a Report
Add/Remove Fields and Labels

Switchboard

Create a Main Menu
Add Command Buttons
Link Main Menu to Forms, Reports etc.

Relationships

Join Tables
Definitions of join types

Sub-Forms

Create Sub Forms
Insert and input using Sub Forms

Query Types

Append Query
Make Table Query
Update Query
Delete Query