Microsoft Access Intermediate

Description

Who should attend?

Anyone who has used Access before to create and alter simple queries and reports.

Requirements:

Delegates must be confident in using Windows and a mouse and at least one other Windows package (for example Word or Excel). You must also have some working experience of Access. For example, creating simple queries and reports (see our Access Introduction, Easy Start, Essentials or Essentials Fast Track outlines).

Aim:

By the end of the course, you will be confident in using Access to create more advanced queries and reports. For example, creating calculations and statistical information and improving the layout of your reports.

What you will learn

In particular you will be able to:

• Create queries that prompt you for specific information. For example, set one up to ask ‘Which department do you want to see?’
• Create queries that group information together and then count the number in that group
• Add up numerical information and create statistical analysis of this
• Import information from an Excel spreadsheet into a table
• Create queries to delete, update and add information in a table
• Create a report with calculations
• Improve the layout of your reports. For example, changing and adding standard text, aligning and formatting information
• Create a report with a running total. For example, show how much you have spent on training after each course attended is added