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
£150.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, 1 June, 2021 (09:30-17:00) |
HSC Leadership Centre |
Keith Bailey
|
Lauren Camlin |
|
||||
| Access-Advanced |
Tuesday, 29 June, 2021 (09:30-17:00) |
HSC Leadership Centre |
Keith Bailey
|
Lauren Camlin |
|
|
||||
| Access-Advanced |
Tuesday, 27 July, 2021 (09:30-17:00) |
HSC Leadership Centre |
Keith Bailey
|
Lauren Camlin |
|
|
||||
| Access-Advanced |
Tuesday, 24 August, 2021 (09:30-17:00) |
HSC Leadership Centre |
Keith Bailey
|
Lauren Camlin |
|
|
||||
| Access-Advanced |
Tuesday, 21 September, 2021 (09:30-17:00) |
HSC Leadership Centre |
Keith Bailey
|
Lauren Camlin |
|
|
||||
| Access-Advanced |
Tuesday, 12 October, 2021 (09:30-17:00) |
HSC Leadership Centre |
Keith Bailey
|
Lauren Camlin |
|
|
||||
| Access-Advanced |
Tuesday, 16 November, 2021 (09:30-17:00) |
HSC Leadership Centre |
Keith Bailey
|
Lauren Camlin |
|
|
||||
| Access-Advanced |
Tuesday, 14 December, 2021 (09:30-17:00) |
HSC Leadership Centre |
Keith Bailey
|
Lauren Camlin |
|
|