Access: advanced

City Lit

Course

In London

£ 189 VAT inc.

The best Office Systems courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Start date

    Different dates available

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.

Facilities

Location

Start date

London
See map
Keeley Street, Covent Garden, WC2B 4BA

Start date

Different dates availableEnrolment now open

About this course

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.

No.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Access

Course programme

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

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.

Additional information

'ECDL advanced', Introduction to programming. General information and advice on courses at City Lit 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

See related categories

Access: advanced

£ 189 VAT inc.

The best Office Systems courses

See all

See all