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 virtual delivery

Due to current guidelines regarding social distancing, we have taken the decision to run our IT course portfolio virtually until further notice.

If you have any questions concerning this, please do not hesitate to contact our Digital Consultancy team via digitallearning@leadership.hscni.net

Cost

£120.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	Thursday, 24 September, 2020 (9.30 am - 3.30 pm)	HSC Leadership Centre	Barbara Patton Caroline Baird	Patricia Bell
Access Advanced	Tuesday, 15 December, 2020 (9.30 am - 3.30 pm)	HSC Leadership Centre	Barbara Patton Caroline Baird	Patricia Bell
Access - Advanced	Tuesday, 16 March, 2021 (9.30 am - 3.30 pm)	HSC Leadership Centre	Barbara Patton Caroline Baird	Patricia Bell