Microsoft Access 2013: Advanced
Buying 11 or more Microsoft Office courses?
10% off orders of 11+ courses
20% off orders of 50+ courses
Improve your Microsoft Access 2013 skills with our advanced online course which explains the tools and features available in the program.
Course Level: Advanced
Certificate: Self printed
Description
Perfect for those who have previous experience of using Microsoft Access 2013 this online course will take your skills to the next level.
In the course Microsoft Access 2013: Advanced, you will familiarise yourself with action queries.
You will examine different types of queries in the SQL view and will get acquainted with the essential clauses of this language.
You will learn to create and use macros to automate your work with databases, explore importing and exporting of objects and their data, examine the printing options of different objects in details and familiarise yourself with normalisation of data.
You will also examine the options of navigation in a database.
What you'll learn
- Append and update queries
- Make table and delete action queries
- SQL language
- Definition of queries in SQL
- Creating a form collecting query parameters
- Macro basics
- Assigning a macro to a button
- Data validation via macros
- Data evaluation via macros
- Exporting data from a database
- Splitting a database
- Automated data import and export
- Import and export in XML format
- Object dependencies and properties inheritance
- Navigation Pane
- Navigation in a database
- Access privacy and security
- Printing database objects and their documentation
- Data normalisation
Suitable for
- Office Workers
- Job Seekers
- Those working with computers
- Those using Microsoft Access at work, home or in education
Certification
Self-Printed Certificate Option
Upon completion of the course, a digital certificate will be available to download instantly.
Recent Reviews
12th July 2025
Excellent and affordable 👍
L2 Food Safety and Hygiene for Catering🎉🎊💪👍
11th July 2025
Easy to follow
Easy to follow, very informative, quick assessment
11th July 2025
Excellent course
Excellent course
11th July 2025
Recommend
Easy access and easy process to follow with relevant content to increase my knowledge of food hygiene.
11th July 2025
Great experience with easy to work…
Great experience with easy to work through modules
10th July 2025
Easy to register and use
Easy to register and use , will use this again
9th July 2025
I liked that I could go at my own pace…
I liked that I could go at my own pace and they had a section to write notes. The course covered a lot more than I thought and was quite in-depth.
8th July 2025
Easy to understand and user friendly
Easy to understand and user friendly
8th July 2025
Learning through Virtual College was a…good experience
Learning through Virtual College was a very good experience. It was very easy to acess. The information was easy to understand. The challenges within the course were well explained. There was a good amount of content in the course i studied
8th July 2025
It's very good 👍
It's very good 👍
Excellent
4.7 out of 5
15838 Reviews on
