|
|
|
Microsoft Access 2010 Module 2
2 days
| Target group: | Academic and general staff who are interested in learning how to use Microsoft Access 2010 to create and manipulate databases |
| Group size: | Minimum 5 - Maximum 12 |
| Level Advanced program: | Completion of Access module 1 and/or some experience in building an Access database |
| Schedule: |
| Date: | Thursday 30 August & Friday 31 August 2012 |
| Time: | 9.30 am - 4.30 pm |
| Venue: | Blue Gum Room, Staff Development, 195 Wellington Road, |
| Apply by: | Thursday 23 August 2012 |
|
| Schedule: |
| Date: | Tuesday 16 October & Wednesday 17 October 2012 |
| Time: | 9.30 am - 4.30 pm |
| Venue: | Blue Gum Room, Staff Development, 195 Wellington Road, |
| Apply by: | Tuesday 9 October 2012 |
|
| Cost: |
$350
|
| Catering: | Morning and afternoon tea will be provided. |
| To apply: | Online Application Form |
Overview
Access module 2 is for the more experienced user of Access . The course re-visits all elements of Access module 1 with focus on advanced interface usage.
Intended Outcomes
To further develop Access database skills
Course Content
- Setting Table Relationships
- Calculations in Queries
- Action Queries
- Multi-Table Queries
- Aggregation Queries
- Modifying Forms
- Creating and using Macros
- Macro Techniques
- Macros On Forms
- Importing and Exporting Records
Learning Approach
- Hands-on workshop
- Practice exercises
Handouts
A booklet of notes will be provided.
|
