What's included?

- On-site training for up to six delegates at one fixed price
- Fully comprehensive training manual
- Four week email support
- v47 Training QuickTip cards for all delegates
- Certificate of Achievement
- Feedback and Evaluation report
- £50 v47 Training Voucher redeemable against future courses

Course Outline

1. Introduction to database concepts

What is a database?
Tables and relationships
The Access application window

2. Database design and table creation

Design and document your database
Define your needs
Basic design rules
Determine relationships
Creating a database
Using the table wizard
Adding fields using the table wizard
Creating a table without a wizard
Adding fields to a new table
Field properties
The input mask property
Setting a primary key
Adding records to a table datasheet

3. Formatting a table

Editing records
Selecting records, fields and columns
Deleting records and fields
Viewing or setting datasheet default values
Re-ordering columns and fields
Changing column width and row height
Hiding and un-hiding columns
Freezing columns
Formatting datasheet cells
Changing datasheet fonts
Copying and moving fields and records
Printing

4. Relationships

Defining relationships
Opening the relationships window
Adding tables to the relationships window
Making relationships
Referential integrity
Editing relationships

5. Locating and replacing information

A simple search
Wildcards
Finding specific values
Find and replace
Sorting records
What is a filter?
Filtering records

6. Creating simple queries

Opening an existing query
Creating queries
The query grid
Logical operators in criteria
Text in criteria - wildcards
Multiple criteria and alternative criteria
Calculated fields
Summary queries
Update queries
Append queries
Make-table queries

7. Creating calculated fields

Creating calculated fields
Using the expression builder

8. Introducing forms

Basic form layout types
Creating a form using autoform
Creating a form using the form wizard
Different ways of viewing forms

9. More about creating forms

Creating forms without using the form wizard
The form design view window
Manipulating form design
Types of control
The toolbox
Creating a combo box control
Changing form properties
Using forms with subforms
Creating a form with a subform
Controlling data input
Changing tab order
Adding command buttons
Adding page breaks
Switchboards

10. Reports

Opening and viewing existing reports
Printing reports
Creating a report using autoreports
Creating reports using the report wizard
Using the label wizard
Using the chart wizard
Grouping levels in reports
Creating a report without a wizard
Creating controls
Setting properties