Access: advanced

Learn the more advanced features of databases - relationships, data validation, advanced form design, subforms, multiple queries, advanced reports, macros and switchboard. Knowledge required: essentials course or equivalent knowledge and experience. See also 'ECDL advanced'.

» Be the first to write a review.

» View full course outline

Key course information

Dates
28/05/12 - 02/07/12

Day(s)
Mon

Duration
5 weeks

Time
18:00 - 21:00

Fees
Full fee: £129
Senior fee: £129
Concession: £62

Venue
KS - Keeley Street

» View location

Course code
CDB06

Availability
Available
(status updated every 15 mins)

Enrol now

Call enrolments: 020 7831 7831

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

Course outline

What is the course about?

The course builds on the Access Beginners 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 topics will we cover?

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

By the end of this course you should be able to:

Understand the need for data analysis as a prelude to setting up a database.
Understand more fully the role of forms and develop additional form functionality.
Understand 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.

Do I need to have an interview before I can enrol?

No.

What feedback will I get?

You will receive regular feedback from your tutor throughout the course, as and when appropriate. At the end of the course you and your tutor are asked to assess the progress you have made.

How will I be able to give my views on the course?

Please complete the evaluation form at the end of your course. These are monitored and help us to continually improve our courses.

How do I find out if I can get some support for my learning?

You may be interested in: education and careers advice; financial and childcare support; disability support; support for Deaf and hearing-impaired students; dyslexia support; English and maths support; counselling, and library services (supported learning centre). To find out what may be available to you, and how to apply, see page 213 of the 11/12 course guide, or visit www.citylit.ac.uk/students

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

General information and advice on courses at City Lit is available from the Information and Advice Shop, open Monday to Friday 12:00 – 19:00 during term time, and Monday to Friday 12:00 – 17:00 out of term time. See the course guide for term dates and further details.

Who can I contact for further information?

Tel: 020 7492 2515

computing@citylit.ac.uk

Advice times:

Tuesday 17.30 - 18.30; Wednesday 12.30 - 13.30

You do not need to book an appointment, just come along on the days and at the times listed.

To enrol on a course, call 020 7831 7831.

Select another date / day / time

Dates	Day(s)	Time	Duration	Fees	Snr	Conc	Code	Availability
28/05/12 to 02/07/12	Mon	18:00 - 21:00	5 weeks	£129	£129	£62	CDB06	Available	» Select
17/10/11 to 14/11/11	Mon	18:00 - 21:00	5 weeks	£129	£129	£62	CDB04	Finished	» Select
13/02/12 to 12/03/12	Mon	18:00 - 21:00	5 weeks	£129	£129	£62	CDB05	Finished	» Select

Contact us

Computing