Course Description

Delegates are introduced to relational database design theory and will design a functional database.

Suitable for

Those with a basic understanding of the parts of an Access database

What experience you will need

Basic keyboard and mouse skills needed to help navigate and explore the windows environment

What the course will include

Database Design
What is a Relational Database
Primary and foreign keys
Relationships

Designing Table Structures
Planning stage
Creating the tables
What field type?
Field Properties
Validating data input

Table Relationships
What is a relationship?
Understanding the relationship
Defining relationships
Creating relationships
Referential integrity
Editing relationships
Deleting table from the grid
Testing the relationships
Importing, exporting data
Linking
Exporting
Importing

Forms
Creating forms in design view
Manipulating form design
Form sections
Form and control properties
An introduction to the Toolbox

Queries
Creating queries in design view
An introduction to Criteria

Reports
Using report wizard
Report sections
Manipulating report design
Using report controls

Access Tools
Importing from other data sources
Backing up and restoring a database
Compacting and repairing a database

CD Rom/Manual
Instructions on How to Open the User Manual

Course Duration  -   1 day

Course cost  -  £120

Follow on courses – Access Advanced

Tags: access, microsoft, office