Microsoft Access Intermediate Course – Virtual

Build on from the basics and learn to improve and customise tables, queries, forms and reports, and share Access data with other applications.

Section background Microsoft Access Intermediate Course – Virtual
100% Money Back Guarantee
Free Assessment
Post Course Support
Share This

Course Overview

You will improve and customise tables, queries, forms and reports, and share Access data with other applications.

This course is suitable for anybody wanting to learn any version between 2007 and latest 2021. Our courses cover all differences between the versions.

Price

£218 + VAT

Duration

1 Day

Training Options

Virtual

Microsoft Access Intermediate Course Content:

  • Lesson 1: Promoting Quality Data Input
  • Lesson 2: Improving Efficiency and Data Integrity
  • Lesson 3: Improving Table Usability
  • Lesson 4: Creating Advanced Queries
  • Lesson 5: Improving Form Presentation
  • Lesson 6: Creating Advanced Reports

Upon successful completion of this course, students will be able to:

  • Provide input validation features to promote the entry of quality data into a database
  • Organise a database for efficiency and performance, and to maintain data integrity
  • Improve the usability of Access tables
  • Create advanced queries to join and summarise data
  • Use advanced formatting and controls to improve form presentation
  • Use advanced formatting and calculated fields to improve reports

Instructor led, group-paced, virtual classroom-delivery learning model with structured hands-on activities.

  • Professional Microsoft Certified Trainer
  • CPD Accredited Classroom training in Small Groups for Max Focus
  • Only Microsoft Approved Courseware and Exercise Files are used
  • Free Assessment of Skills prior to booking
  • Certificate of Completion & Complementary 12 Months Post Course Support
  • 100% Money Back Guarantee & Price Match Guarantee
  • Bespoke Courses & Group Discounts from £89 per person

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Office Access.

It is suggested that you have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

To meet this prerequisite, you can take the following course:

  • Microsoft Access Introduction

This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.

The Microsoft Certified Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.

Choose Your Date & Location

Start Date
Location
Session Times
Duration
Price (Excl Tax)
Please contact us for information
Virtual
There is no public schedule for this course
1 Day
£218

Testimonials

quote image
quote image
I chose Infero training due to a recommendation from a colleague. The course booking process was easy and straight forward. I chose to do an MS Access course which was on a 1-2-1 basis with the trainer. The 1-2-1 method of training suited me as this meant the course ran at a speed that I was comfortable with. Upon returning to work, I had used my newly gained skills to create databases for the logging of our equipment, this wouldn't have be possible without the training at Infero. The whole experience of using and attending Infero Training has meant that I have placed two of my staff on MS Office courses and I plan to send more staff MS Office training.

Mark Meade Divisional Service Manager from Vaillant Group

Top Microsoft Access FAQs

What is the schedule for the training course?
  • Start: 9:00am
  • Break: 11:00am
  • Lunch: 1:00pm
  • Break: 3:00pm
  • Finish: 5:00pm
The schedule for 1, 2 and 3 days training will be the same but course content will vary. Times can be changed for group and onsite to start earlier, you can ask before booking.
Can we have a course in our own workplace?
If you are interested in having a training course at your own workplace, whether it be through one-to-one sessions or group training, we offer Onsite Bespoke courses.
How is the course structured?
The course is structured to blend instructor-led tuition with hands-on exercises, reinforcing learning through practical activities. This interactive approach ensures you learn both theory and application effectively. Each module begins with a theoretical foundation followed by immediate practice to solidify your understanding. Our instructor guides you through the material, addresses any questions you have, and supervises your practical work throughout the course.
Do I need any equipment for training?
For Classroom training courses you usually don’t need any equipment, unless we specifically advise otherwise. For Live Virtual training courses you will need a computer, or laptop with full version of the software you are training in. We also strongly recommend having access to a second screen for the training course such as a tablet or phone. This will allow you to do the exercises on your primary device and see the virtual whiteboard on a secondary device.
How do I know which level is right for me?
If you are unsure about which training course level suits you best, we recommend you give us a call and one of our telephone experts or trainers will be able to advise you.
How experienced are your tutors?
Our company prides itself on the quality of our training courses, which is not possible without our exceptional trainers! Our tutors have both practical and teaching experience, and specialist knowledge. We are happy to provide references and their profiles upon request.
Is there ongoing support after completing the course?
Absolutely! Following the training course, we provide a variety of post-course support documents so you can revisit the content at your own pace, along with offering 12 months of support via email.
Will I receive a certificate upon completion?
Yes, all of our training courses come with a certificate of completion. Once you finish the course, we will email your certificate to you within 2-3 working days.

Looking to book some training for your team?

Request a Quote