Microsoft Access 2000 Day 3

This course is for users who can design forms, reports and simple queries using a single table database. It introduces the concepts of setting up a multi-table relational database and working with objects of increased complexity. The course continues on from Day 2.

Level of the course: Third
Duration: 1 day
Hours:9.30am-4.30pm

A Certificate will be issued to each delegate and will contribute to units of the appropriate NVQ.

Topics Covered: 

Working With A Relational Database:
Using a Combo or List Box for Data Lookup
Producing a Form Containing a Subform
Connecting Tables with a Select Query

Further Query Types:
Using Action Queries to Archive Records
Update Queries
Parameter Queries
Totals Query

Complex Reports
Sorting & Grouping
Calculated Controls
Subreports

Issue 26/10/00
Course Code Acc97D3/CS