Access - Advanced

 

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.

 

Method

1 Day

Cost

£106.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
Access Advanced Tuesday, 21st May, 2019
(9:30am-15:30pm )
HSC Leadership Centre Barbara Patton
Caroline Baird
Creena Miskimmin
Access Advanced Thursday, 22nd August, 2019
(9:30am-15:30pm)
HSC Leadership Centre Barbara Patton
Caroline Baird
Creena Miskimmin
Access Advanced Monday, 21st October, 2019
(9:30am-15:30pm )
HSC Leadership Centre Barbara Patton
Caroline Baird
Creena Miskimmin
Access Advanced Wednesday, 18th December, 2019
(9:30am-15:30pm )
HSC Leadership Centre Barbara Patton
Caroline Baird
Creena Miskimmin
Access Advanced Thursday, 13th February, 2020
(9:30am -15:30pm)
HSC Leadership Centre Barbara Patton
Caroline Baird
Creena Miskimmin