ECDL

Module 5

Any Square One course can be tailored to meet the particular requirements of your organisation.
We will be happy to use any of your examples for delegates to ensure that the course is as interesting and relevant as possible.

This course is suitable for all new users of Access who wish to set up and design databases for input. This course will help you understand the many uses of Databases.

Duration: 2 Days or 4 evenings

The subjects listed on the left are an outline. If there are any additional subjects you wish to cover, please feel free to call us prior to the course.

Booking

Access Overview/Database Design Theory
What is a Relational Database
Screen Elements and Help Tools

Using the Table Wizards
Manual Creation of Tables
Fields, Data Types and Properties
Input Masks
Data Validation
Importing Data
Primary Keys and Relationships

Using the Find feature to find Records
Using the Replace feature to replace text

Designing Queries
Query Wizard Overview
Sorting and Searching Queries
Multi-Table Relationship Queries
Update, Append & Delete Action Queries

Introduction to Form Design
Form Wizards
Toolbox Controls
Combo Boxes & Command Buttons
Main/Sub Form Creation
Creating a Menu Form

Report Wizard
Creating Reports
Printing Reports