Microsoft Access Tables and Queries

0( 0 REVIEWS )
Microsoft Access Tables and Queries

See the Curriculum Section for materials and enjoy learning with Imperial Academy.

Course Curriculum

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

Quality Licence Scheme Endorsed Certificate of Achievement

Learners will get an endorsed certificate of achievement (included with the course) directly at their doorstep after successfully completing the package! It should be noted that international students must pay a £10 shipping cost.

For ordering additional QLS Certificates, other than this course, the fees will be following with £10 for international shipping only 

CPD Accredited Certification 

Upon successfully completing each of the courses in this package, you will
be qualified for CPD Accredited Certificates. Certification is available –

It should also be noted that international students must pay a £10 shipping cost.


The Quality Licence Scheme has endorsed this course for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. Imperial Academy will be able to advise you on any further recognition, for example, progression routes into further and/or higher education.

Imperial Academy is an approved reselling partner for Quality Licence Scheme courses under One Education

Course Info

2 Enrolled
  • Office Productivity
  • Personal Development
  • 1 year
  • Number of Units20
  • Number of Quizzes0
  • 3 hours, 32 minutes