About this course
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
Recent reviews
I think the intermediate class can be done without any background in Access for people who are quantitatively trained in any other software.
Kevin has the patience of a saint.. He is informative and wants to involve everyone. It is always difficult to know how to pitch to a group of people as we all have different experience of the application but Kevin made each feel involved.
Very pleased with training experience generally. Couldn't find fault.