Access: advanced

Course Dates: 22/10/18 - 19/11/18
Time: 18:15 - 21:15
Location: KS - Keeley Street
Tutor: Aurica Jalba

Learn advanced features of databases: relationships, data validation, advanced form design, subforms, multiple queries, advanced reports, macros and switchboard. Knowledge required: Access essentials course or equivalent knowledge and experience.


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?

Advanced tables
Multi-table, parameter and action queries
Advanced form design
Advanced reports

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.

General information and advice on courses at Build is available from the Student Centre and Library on Monday to Friday from 12:00 – 19:00.
See the course guide for term dates and further details


Book your place

Course Code: CDB04

Mon, eve, 22 Oct - 19 Nov '18

Duration: 5 sessions (over 5 weeks)

Full fee: £189.00
Senior fee: £151.00
Concession: £95.00
Add to Basket

Or call to enrol: 222-66-889-99

Download form & post

Any questions? [email protected]
or call 020 7492 2515

Add to my wishlist

Please note: we offer a wide variety of financial support to make courses affordable. For more information visit our online . You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.