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
£111.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 |
|
|