Microsoft Access Intermediate Training Course - 1 day (Instructor-led lessons) for employers and staff

Minimum Quantity: 6

Once you have discussed your learning requirements with your Microsoft Office trainer please select your availability when making your booking here from the Select Option tab below. More information can be found under the Course Locations tab below. If you have a question or a query, call us today. We're here to help.

Title: Microsoft Access Intermediate Training Course

Version: Designed for Microsoft Access 365, 2019, 2016, 2013 & 2010

Who is this training for?
Our Microsoft Access course is suitable for those users who have a basic working knowledge of Access Database and want to acquire further knowledge to consolidate their skills and have a greater understanding of utilising the relevant features and functions within Microsoft Access.

Prerequisites: A good basic working knowledge of Microsoft Access is required.

At the end of this course, you will acquire further knowledge, you will be able to use the relevant features and functions within Microsoft Access.
You will have the ability to use Access Database as an information management tool or relational database that will help you to store information for reference, reporting and analysing.
Microsoft Access produces flexible and adaptable database systems.

Microsoft Access consists of four main database objects:

  • Tables
  • Queries
  • Forms
  • Reports.

What will you learn on this Access Intermediate Training Course?

1. Access Design Tips and Techniques
2. What's new in Access
3. Creating relational databases
4. Working with tables
5. Defining data entry rules
6. Using advanced query features
7. Creating advanced queries

Subject areas covered are listed in detailed in the Curriculum tab above.

Course Level: Level 2

Teaching Method: Online tutoring using Cisco Webex or Zoom as our online tutoring platform.

Course Duration: 1 day (Instructor-led lessons)

Classroom Size: 6 candidates

Teaching Hours
Monday to Friday - 9:30am to 5pm
Saturday and Sunday - 10:30am to 6pm

  • We will tailor our courses to suit your availability.
  • Further options on course schedule and availability are listed in the Select Option tab above.
  • We will provide you with a structured lesson plan, course exercises, tutor notes and helpful tips.

Price: £150.00 per person (To provide a quality service, we've limited the classroom size to 6 candidates).

Ordering services from our website and how it works?

Once you have discussed your learning requirements and your availability with you teacher and you are ready to start learning, you will need to book your training session(s) here.

In the Select Option... tab above, you will find our course schedule list, choose your course schedule by clicking on it, enter the numbers of candidates enrolled for example 6 in the Hrs text box, you will then need to click on ADD TO BASKET button on the right-hand side.

You will now need to complete your billing detail(s), all the boxes with asterisk * will need to be completed or your booking form will not be processed and once you have completed your billing detail(s) you will need to tick the box to accept our terms and conditions else your checkout will not be processed. The other box is optional (mailing list, latest news and offers).

Once you have click CHECKOUT NOW! :

Our payment gateway "WORLDPAY" will then process your transaction and if successful you will receive an email of the confirmation of the transaction and invoice of service(s) purchased.

If you face any issues, call us on 020 8907 5522 and we will walk you through it.

We are available from 9am to 9pm (Monday to Friday).

Payment Methods:

  • Credit or Debit Card
  • Email PayByLink (Invoiced Payment)

If you have a question or a query, call us today. We're here to help.

Additional Information:

We only recruit educators who have a teaching qualification and a degree in their subject specialism and who have the necessary skills and experience in delivering lessons to learners on regular basis.

We have stringent recruitment policy in place for our teachers' vacancies. We check and verify each teacher's credentials and interview them personally in stages before they can join our teaching team. Our teachers are fully qualified, highly experienced and specialised in helping people of all ages to reach their full potential.

Customers may request details of our educators prior to engaging our services.

Services: Remote Learning, Online Classes, On-site Group Training.

Course Syllabus

Subject areas covered:
1. Access Design Tips and Techniques
2. What's new in Access
3. Creating relational databases
4. Working with tables
5. Defining data entry rules
6. Using advanced query features
7. Creating advanced queries
8. Creating advanced form design
9. Using advanced report features

Module: Creating relational databases

  • Database normalising
  • Introducing relating tables
  • Adding referential integrity

Module: Working with tables

  • The lookup wizard
  • Changing lookup fields
  • Inputting data to related tables

Module: Defining data entry rules

  • Using input masks
  • Setting a property
  • Setting a validation rule

Module: Using advanced query features

  • How to join a table in queries
  • Creating a calculated field
  • Using an action query

Module: Creating advanced queries

  • Summarise and group values
  • Create a crosstab query
  • Using a parameter query

Module: Creating advanced form design

  • Working with graphics
  • Working with calculations
  • Working with combo boxes
  • Working with unbound controls

Module: Using advanced report features

  • Create customized headers and footers
  • Add a calculated value
  • Work with sub-reports

Helpful Tips
To benefit from our Access intermediate training, learners must have good working knowledge in these basic areas;

  • Understand database components.
  • Understand what types of information are stored for example tables, forms, queries or reports.
  • Able to enter structured data for instance tables, fields and records.
  • Able to use of data entry form and create new record and add record to table.
  • Able to locate and amend for example find, search, replace, sort and wildcards.
  • Able to recognise data entry errors due to field size, data type, validation checks.
  • Able to use help.
  • Able to check data and use spell check, and format data, check data for accuracy and consistency.
  • Understand database queries and able to use alphanumeric sort, filter and single criteria.
  • Understand database reports and able to use menus, wizards or shortcuts.

Services: Online classes, On-site group training, Home tuition.

Course Delivery Location: Our online tutorial services are delivered using Cisco or Zoom as our virtual training platform and you can start learning in the comfort of your home without the need to travel.

If you have a question or a query, call us today. We're here to help.

Great professional tutors for science and maths! Everything is smooth and swift from booking and communication. Highly recommended for anyone wanting to tutor their children.

Priteshb, London

Very good teaching agency with good teachers and resources provided. Reasonable rates, highly recommended.

JC Chou, Stanmore

Our organisation used Customised Curriculum to improve our staff's IT skills in using Excel spreadsheet. We were provided with a professional trainer, resources and support.

Ameet Radia, Simpson Reid Property Consultants

We had to persevere as no maths tutors were available to provide home tuition because of the pandemic and they organise online maths tuition for my daughter and she is happy. Thank you.

Ashok Varma, Kingsbury, Harrow

Booked Maths GCSE & A level lessons for my daughters. Excellent tuition and support. I am very happy with my children's progress.

Murali Krishna IT Consultant, Wembley