Microsoft Access – Intermediate
Overview:
The skills and knowledge covered in this course include ensuring that data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros. The course covers the following:
- Data validation
- Formatting tables
- Querying techniques
- Parameter queries
- Calculations in queries
- Modifying forms
- Using a navigation form
- DIY forms
- Creating and using macros
- Macro techniques
- Macros on forms
- Navigation pane protection
Course Details:
Target Audience:
This course is primarily designed for people who have an understanding of how tables are created, records are entered, modified and deleted, and how simple queries, reports and forms are created.
Level:
This course covers Microsoft Access at the Intermediate level.
Related Course:
Learning Outcomes:
At the completion of this course participants will be able to:
- Use various data validation features in Access to protect data
- Format the data in a table
- Perform more advanced queries using a variety of querying techniques
- Create and use parameter queries
- Create calculated queries
- Modify and adapt an existing form according to specific needs
- Create a navigation form for a database in Access
- Create forms using a combination of wizards and manual techniques
- Create and use macros in Access
- Work with a number of macro techniques
- Create and work with macros in forms
- Create and manage custom categories and groups in the Navigation Pane
| Name | Date | Time | Location | Cost (inc GST) | |
|---|---|---|---|---|---|
| MS Access - Intermediate | 02/09/2020 | 9:30am - 4:30pm | Online Training | $485.00 | Enrol |
| MS Access - Intermediate | 07/10/2020 | 9:30am - 4:30pm | Online Training | $485.00 | Enrol |
Prices:
| Trainees | Price | |
|---|---|---|
| 1-3 trainees | $1,495 | per day |
| 4-8 trainees | $1,795 | per day |
| Each additional trainee | $150 | per day |
