Access - Advanced

 

Courses By Theme

Tailored Programmes

IT Courses

Enter a keyword(s) below to search through our courses.


Purpose

This course is designed to provide participants with an understanding of some of the more advanced features in MS Access.

 

 

Learning Outcomes

Queries

  • Queries that perform actions
  • Queries that perform calculations
  • Queries displayed as crosstabs
  • Explanation of the different types of query joins

Forms

  • Using functions to automatically complete a form control
  • Apply conditional formatting to a form control
  • Add subforms to a main form
  • Create a switchboard (Main menu)
  • Create Macros for buttons

 

Audience

Suitable for those who have attended our Intermediate Access course, or those who already have a sound working knowledge of MS Access and want to increase their knowledge.

 

 

 

 

 

When applying for this course please select the Microsoft Office version that is applicable to you. This course is run in 2007/2010.

 

If applying for the 2007/10 course please state which Microsoft Office version you currently use on the "Additional Information" section of the application form.

 

Method

One day

Cost

£102.00
(Prices do not include VAT)

Please select an appropriate time and venue and click the apply button to register for this course.

Label Dates & Times Venue Facilitator Administrator
Office Version 2007/2010 Thursday 7th December 2017
(9.30am-3.30pm)
HSC Leadership Centre Barbara Patton
Caroline Baird
Cathy Holt
Office Version 2007/2010 Tuesday 27th March 2018
(9.30am-3.30pm)
HSC Leadership Centre Barbara Patton
Caroline Baird
Cathy Holt