Description
Course 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.
This course is designed for PC users of Access 2013 and 2016. It is also available for users of Access 2007/2010 – please ensure you attend the course that is appropriate for your version of Access.
What you will learn
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
020 7375 7300
Email