What is the course about?
The course builds on the Access Essentials course. You will be introduced to some of the more advanced features and explore macros for automating tasks. You will be given prepared files for use and will not be required to enter large amounts of data.
What will we cover?
Multi-table, parameter and action queries
Advanced form design
What will I achieve?
By the end of this course you should be able to...
Recognise the need for data analysis as a prelude to setting up a database.
Identify the role of forms and develop additional form functionality.
Recognise the need for data validation to ensure accurate data capture, and make use of it.
Formulate complex queries to extract and manipulate data.
Produce reports which group and sort data, transforming data into information.
Use macros to automate functions and processes.
What level is the course and do I need any particular skills?
You should have completed the Access for Beginners course or have equivalent knowledge. If you have not done the Access beginners course, please check the course outline to see that you are familiar with what was covered.
You should also be able to follow spoken and written instructions and be comfortable carrying out mathematical calculations.
How will I be taught, and will there be any work outside the class?
Each student has their own computer.
Presentations will be made using computers, interactive whiteboard, overhead screen and printed notes.
Step by step instruction, with demonstrations where appropriate, will help you grasp the concepts.
Are there any other costs? Is there anything I need to bring?
When I've finished, what course can I do next?
'ECDL advanced', Introduction to programming.