Microsoft Access – Advanced
Overview:
The skills and knowledge acquired in this course are sufficient to design and create a multi-table database and automate operations using macros and have a general understanding of the programming environment in Microsoft Access. The course covers the following:
- Relational database design
- Creating a relational database
- Setting table relationships
- Importing and exporting records
- Multi table queries
- Aggregation queries
- Action queries
- Database security
- Database wellness
- An introduction to VBA
Course Details:
Target Audience
This course is primarily designed for people who need to know how to develop relational databases and automate operations.
Level:
This course covers Microsoft Access at the Advanced level.
Related Course:
Learning Outcomes:
At the completion of this course participants will be able to:
- Design a relational database project
- Create a relational database file with multiple tables
- Set table relationships and join tables together
- Export records to and import records from a wide variety of sources and applications
- Create queries based on one or more tables
- Create and work with aggregation queries
- Create and use a series of action queries
- Make your Microsoft Access data and computer more secure
- Understand and use a variety of tools that ensure the wellness of your database files
- Create some simple programming code using VBA
Your Investment:
| Trainees | Price | |
|---|---|---|
| 1-3 trainees | $1,495 | per day |
| 4-8 trainees | $1,795 | per day |
| Each additional trainee | $150 | per day |
