Access 2010/13/16 Database Design

Prerequisite: Has attended the Access database user course or has equivalent knowledge.

Duration: Two days

Course Topics

Relational database concepts
* Design methodology
* Planning for relational databases
* Normalisation

Table design and creation
* Adding Fields
* Field Data types
* Properties
* Primary Keys
* Modifying fields

Designing connecting tables
* Primary and Foreign Keys
* Using the table analyser to normalise existing data

Creating relationships
* Creating relationships
* Managing
* Referential Integrity
* Relationship types
* Cascade delete and update

Review of multi-table queries
* Adding tables and relationships

Multi-table Forms and Reports
* SubForms / Sub reports
* Grouped Reports
* Designing/ modifying Forms/Reports
* Properties
* Calculations in Forms/Reports

Advanced Queries
* Parameter queries,
* Calculations in queries
* Total and cross tab query

Calculations in records, conditional formats importing and exporting
* Exporting to other MS Office Products
* Importing and exporting as text files
* Mail merge

Automated database
* Using an automated database
* Using switchboard manager