|
Home
> Training
> Microsoft
Office 2003
Access 2003 Intermediate
2 days
Most databases will require a number of linked tables, and on this
course delegates will learn the principles of database design
and table relationships, and how to apply these in Access. Queries
and reports relating to multiple tables will be built. In addition,
delegates will create Action queries to update data and learn
how to produce highly customised forms and reports.
This is a
hands-on course containing varied and relevant exercises for
delegates to practise and reinforce the techniques learnt.
Multi-Table Databases
Concepts of relational databases
Different types of relationships:
- One-to-many
- One-to-one
- Many-to-many
Creating the relationships
Specifying the relationship options
Using related tables
Referential integrity
Cascade Update and Cascade Delete
Creating Lookup tables
Multi-table queries
Parameter queries using several tables
Creating reports from related tables
Creating main and subforms
Groups and Total Queries
Creating calculated fields
Aggregate functions in Access
Creating and using total queries
Crosstab Queries
Limitations of select queries
Creating crosstab queries
Advanced Querying
When to use Action queries
Update queries
Append queries
Delete queries
Make Table queries
Using the Query wizards
Field and query properties
Understanding and changing the Join Type
AutoLookup queries
Customising Forms
Types of controls
Creating calculated fields
Creating combo boxes
Setting the tab order
Grouping controls
Starting forms automatically
Creating a form with multiple tabs
Creating a form with multiple pages
Customising Reports
Report sections
Using controls
Grouping data
Creating calculated controls
Adding subreports
This course is suitable
for those who have
been using Access
regularly on a day-to-day
basis, or who have
attended our Access
2003 Introductory
course and need to
work with or develop databases involving several related tables.
10:00am to 5:00pm
Comprehensive course manual included.
Refreshments and lunch are provided on all courses at the Information
Horizons Training Centre.
 Back
to the top
|
