Microsoft Access Intermediate - course outline

Microsoft Access is an easy-to-use tool for creating user-friendly databases.

The primary objective of this one-day Intermediate course is to broaden your knowledge of Access. This practical course allows you to appreciate the full potential of Access. You will be encouraged to discuss your individual requirements relevant to your work. By the end of the course you will be competent with the following skills:

Modifying the design of a table

• specifying a required field/ defining a default field value
• setting a primary key for a table
• adding a memo field to a table
• additional table design topics

Working with multiple tables

• displaying multiple tables on the Access desktop
• resizing and repositioning the table window

Relating tables

• creating a relationship between two tables in a database
• displaying and using a subdatasheet

Working with a custom form

• designing a custom form
• adding a header and footer to a form
• using a custom form to enter data

Intermediate query techniques

• creating a query to extract information from multiple tables
• creating a query to generate summary information
• creating a crosstab query
• creating a query to find unmatched records in a table
• creating a query to find duplicate records in a table

Intermediate report techniques

• creating a report of information in multiple tables
• adding a calculated control to a report

Additional intermediate Access features

• adding a lookup field to a table
• defining an input mask for a field
• viewing object dependencies
• exporting an Access datasheet to Microsoft Office Excel

This course outline is a guide. All our courses can be tailored to customer requirements.

Target audience
This course is aimed at anyone who has some experience of Access and wishes to examine some of the more advanced features

Assumed knowledge
Delegates should be familiar with the basics of Access, either from attending our Introduction Course or knowledge gained from their own experience.