About Us

about image

At Kingston, we offer the best in e-learning courses, featuring regulated and endorsed qualifications for your career growth.

Know More Know More

We Are Social

Follow Us:

Microsoft Access Tables and Queries

( 7 Reviews )

clock

3 hours, 28 minutes

book

19 Curriculum

man

26 Students

Course Overview

This premium QLS endorsed Microsoft Access Tables and Queries course comes with intensive study modules, dedicated tutor assistance, customer support, flexible learning opportunity and a globally recognised certification all-together. Thus, successful completion of our Microsoft Access Tables and Queries course will give you limitless opportunities anywhere and everywhere, since the value of QLS endorsed courses are quite high, to say the least!!

What’s more, the quality of our first-class course is uncompromising for both you and us. You will be taught the richest of materials from this exquisite Microsoft Access Tables and Queries course, enabling you to open up a vast world of opportunities for you to grasp and gain success from. For the price point, this course is actually an absolute steal! It’s an investment you absolutely do not want to miss out on!

So, why delay any longer? Benefit your career progression by joining us today and distinguish yourself as, unquestionably, the most skilled one in your workplace! 

Key features

Learning Outcome

Course Details

We, as one of the leading eLearning service providers across the globe, strive to provide all our learners with the best eLearning experience possible that can make a real difference in their career progression. 

  • 4+ hours of video lectures and digital resources are available on demand.
  • Learn at your own speed with affordable, high-quality E-learning content. 
  • When you finish the course, you will be given a certificate of completion.
  • Enhance your resume from a globally recognised Accredited Qualification.
  • You’ll discover how effective salespeople use a researched and proven technique to boost their careers.
  • You’ll be able to successfully implement several practical sales strategies and have a deeper understanding of your consumers.

Our course is open for everyone. This Microsoft Access Tables and Queries is ideal for those who aspire to gain in-depth knowledge & efficient skill to embark into the relevant sector as a promising potential. 

  • Tour of the screen
  • Using Design view to create and edit tables
  • Using the lookup wizard
  • Importing data from Other Data Sources into Access
  • Linking Tables from Other data Sources into Access
  • Exporting data from Access to other data types
  • Creating and Managing Table Relationships
  • Database Tools
  • Sort and Filter a Table
  • Basic Queries
  • Prompting the user for the criteria
  • Creating Calculated Fields in a Query
  • Creating Totals Queries
  • Multiple table Queries
  • Viewing the SQL code for an Access Query
  • Using the Query Wizards
  • Creating Subqueries
  • Creating Make Table, Append, Update and Delete Queries
  • Displaying a certain number of records

Learners must submit a comprehensive summerised assignment on all the units that will be assessed by our expert tutor if all the learning outcomes are met as per the standard set by QLS. After the quality check, learner will be provided with the Microsoft Access Tables and Queries certificate.

An endorsed certificate will be issued to learners at the end of the course as recognition of course completion. Provided that learner completes all the assessment of a course can claim for certificate. 

QLS endorsed this certified course as a highly qualified, non-regulated provision and training programme. There will be a trainer to answer all your questions including your progression routes into further higher education. It is a non-accredited course.

There are no formal requirements needed for this Microsoft Access Tables and Queries course. So learners do not require any prior qualifications to enrol in this course. 

  • video Tour of Screens
    00:07:00
  • video Using Design view to create and edit tables
    00:45:00
  • video Using the lookup wizard
    00:09:00
  • video Importing data from Other Data Sources into Access
    00:18:00
  • video Linking Tables from Other data Sources into Access
    00:10:00
  • video Exporting data from Access to other data types
    00:03:00
  • video Creating and Managing Table Relationships
    00:10:00
  • video Database Tools
    00:05:00
  • video Sort and Filter a Table
    00:06:00
  • video Basic Queries
    00:22:00
  • video Prompting the user for the criteria
    00:05:00
  • video Creating Calculated Fields in a Query
    00:10:00
  • video Creating Totals Queries
    00:08:00
  • video Multiple table Queries
    00:12:00
  • video Viewing the SQL code for an Access Query
    00:06:00
  • video Using the Query Wizards
    00:09:00
  • video Creating Subqueries
    00:03:00
  • video Creating Make Table, Append, Update and Delete Queries
    00:19:00
  • video Displaying a certain number of records
    00:01:00
imagecert

Course Reviews

4.8

4.8
7 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

Course Info

info-star
Categories :
book

Lessons : 19

assignment

Assignments : No assignments

clock

Duration : 3 hours, 28 minutes

packages

Access : 1 year

clear pay

Enrol now, pay later in easy instalments(Interest free) with Clearpay.

Want courses at lower price?
Join our email list for early access and rewards.

Subscribe

Ready To Get Started ?

We at Kingston provide high-quality Ofqual regulated qualification along with proper guidance. We collaborated with recognised awarding bodies which means you as a learner will get the best high quality professional qualification required for your current & future career growth.

Address

Certificate Validation

©2026 – Kingston Open College is the trading name of Thrive EdTech Ltd (Company Number:13565336). All rights reserved.

top
bticonsHome bticonsSearch bticonsCart

Ready to Get Started?

Your email address will not be published. Required fields are marked *

Name(Required)
This field is hidden when viewing the form
This field is hidden when viewing the form