Home > Course Map > Advanced microsoft access

Advanced Microsoft Access

Overview / who should attend and why?

The main objective of the course is to widen the users’ knowledge of Access so that they can create sophisticated databases.

Aimed at users who wish  to develop their understanding of Microsoft Access and gain experience in designing tables, simple queries, forms and reports.

Course Objectives

To gain a greater understanding of Access, including designing tables and forms and performing queries and running reports.

Course Content

Query techniques

• Creating a query to extract information from multiple tables
• Finding unmatched records in a table

Report techniques

• Creating a report of information in multiple tables
• Adding a calculated control to a report
• Adding a cover sheet to a report

Working with a data access page

• What is a data access page?
• Creating a data access page
• Adding a pivot table and chart to a data access page
• Adding a grouping level and hyperlink to a data access page

Additional Access features

• Using a database wizard
• Adding a lookup field to a table
• Defining an input mask for a field
• Exporting an Access datasheet to Excel

Advanced table design techniques

• Validating field entries, creating a lookup field
• Creating a custom input mask

Advanced form techniques

• Creating a master-detail form; adding a picture to a form
• Displaying the current date on a form, modifying form properties

Advanced filter and query techniques

• Creating an advanced filter
• Including multiple conditions in a query
• Creating a parameter query
• Creating a query to generate summary information
• Creating an action query

Advanced report techniques

• Creating a master-detail report; completing the report
• Modifying report properties

Working with macros and modules

• What is a macro?
• Creating and running a macro
• Creating a command button
• Writing an event procedure

Using tools menu options

• Setting database start-up options and a password
• Encrypting, decrypting, compacting and repairing a database
• Using the database splitter wizard and the linked table manager
• Creating a replica of a database

Additional Advanced Access features

• Creating a many-to-many relationship between tables
• Creating a switchboard
• Exporting Access data to an XML document
• Importing an XML document into Access
• Saving an Access database in an MDE file
• Creating an Access workgroup

Costs / Duration and Location

• The cost of this training course is £425 + VAT 
• The duration is two days 9:00 till 16:00
• Various dates and locations, see course calendar or contact us for further information