Microsoft Access 2016: Intermediate
Buying 11 or more Microsoft Office courses?
10% off orders of 11+ courses
20% off orders of 50+ courses
Become more familiar with Microsoft Access and the various tools and features that are available to use with our online course.
Course Level: Intermediate
Certificate: Self printed
Description
In the course Microsoft Access 2016: Intermediate, you will learn to create calculated fields in queries that operate with functions.
You will create totals queries and parameter queries and will familiarise yourself with the properties of table joins and will examine how they can affect the result of queries.
You will create forms in the Design view and will learn to insert calculated fields into them and will also design and edit reports and will learn to perform various calculations in them.
You will also learn how to insert controls into forms and reports, including subforms and subreports.
What you'll learn
- Parameter query
- Join properties in queries
- Creating manual joins in queries
- Expressions in queries
- Use of functions in more complex expressions
- Advanced setting of table fields properties
- Totals
- Aggregate queries
- Crosstab query
- Sorting and filtering data in forms
- Design View of forms
- Form creation in the Design View
- Editing a form
- Editing form controls
- Calculated form fields and conditional formatting
- Combo box in forms
- Option buttons in forms
- Tab order of form controls
- Form with a subform
- Subform insertion in the Design view
- Restricting data editing in forms
- Grouping and summarising data in reports
- Editing created reports
- Advanced report options
- Setting reports before printing them
Suitable for
- Office computer user
- Those wanting to develop Microsoft Access skills and knowledge
- 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
19th July 2025
Great
Easy to navigate
18th July 2025
Level 2 health & Safety within the catering world. With using virtual college
With using virtual college, it was quick and easy to pay and access my chosen course. I had a choice of using different methods on what type of device that I could use which was great for me. The course was very informative and I learnt a lot and the assessment at the end was good & you have a certificate that you can download straight away. Very highly recommend.
18th July 2025
Easy to access the Training
The process of purchasing the training (in this case combined offer of Allergy Awareness and Level 2 Food Safety and Hygiene) was easy as was the ability to access and complete the training. The online training system works well. The Food Allergy course was comprehensive and well structured my only criticism is that the Level 2 Food Safety and Hygiene is not as well structured with the same material repeated may times in different places so the course could be made much shorter.
18th July 2025
Very good everything completed…
Very good everything completed professionally
18th July 2025
Found the training easy to access and…
Found the training easy to access and navigate through different sections
17th July 2025
Very easy to follow well constructed…
Very easy to follow well constructed course
17th July 2025
The system was easy to use and things…
The system was easy to use and things were clear throughout
17th July 2025
easy to complete
easy to complete very informative
17th July 2025
Very informative
Very informative. Well navigated and explained in ways I could understand with out jargon that can often get in the way.
16th July 2025
Full of the correct info and to the point
Was very easy to operate and the course was full of really good information Could use a better functionality for the partially sighted individuals like myself
Excellent
4.7 out of 5
15857 Reviews on
