Structuring Databases

Simple Database Creation:

Tables

Forms

Queries

Reports

Customising Tables

Field Properties controlling Data Entry

Primary Keys

Importing External Data

Customising Forms

AutoForms

Calculated Fields

Creating Sub Forms

Tab Controls

Combo/List Boxes

Form Design & Layout

Editing Form Objects

Action Queries

Update Query

Parameter Query

Make-Table Query

Top Values Query

Delete Query

Group & Totals Query

Cross-Tab Query

Multiple Tables & Join Properties

Customising Reports

AutoReports

Calculated Fields

Creating Sub Reports

Mailing Labels

Grouping & Sorting Data

Parameter Title Pages

Concatenation

Command Buttons

Record Navigation

Record Operation

Run Application Command

Run Query Command

Importing/Exporting Data

Importing External Data

Mail Merge with Word

Exporting Data to Excel

Managing Databases

Customising Menus & Toolbars

Switchboards

Splash Screens

Startup Options

Object Dependencies

Backing Up a Database

Compact & Repair