Access 2016: advanced

Course Dates: 29/10/19 - 26/11/19
Time: 10:00 - 13:00
Location: KS - Keeley Street
Tutors:
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.

Description

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?

Relationships
Advanced tables
Multi-table, parameter and action queries
Advanced form design
Sub-forms
Advanced reports
Macros
Switchboards.

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?

No.

When I've finished, what course can I do next?

'ECDL advanced', Introduction to programming.

Reviews
Tutor Biographies
We’re sorry. We don’t have a bio ready for the tutor of this class at the moment, but we’re working on it! Watch this space.

Book your place

Course Code: CDB04

Please choose a course date 

Tue, day, 29 Oct - 26 Nov '19

Duration: 5 sessions (over 5 weeks)

Full fee: £199.00
Senior fee: £159.00
Concession: £121.00

Or call to enrol: 020 7831 7831

Download form & post

Any questions? computing@citylit.ac.uk
or call 020 7492 2515

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