Microsoft Access Tables and Queries

0( 0 REVIEWS )

2 STUDENTS

Course Overview

You’ll have an arsenal of skills to lock down your desired career after completing this Microsoft Access Tables and Queries course. Moreover, you will have access to all of the materials in this course for free for a whole year and learn a multitude of highly coveted skills to move up the corporate ladder.

With this comprehensive Microsoft Access Tables and Queries course, you’ll have all of your questions answered and all of the necessary expertise under your belt. Apart from setting you up for success, this course offers numerous advantages to make your learning experience more pleasurable and less stressful. So, add this Microsoft Access Tables and Queries course to the basket and take your expertise up a notch!

Please Note: Thames College is a One Education approved resale partner for Quality Licence Scheme Endorsed courses.

Why Choose Thames College?

Thames College offers you the benefit of —

Who Is This Course For?

Those who want to strengthen their professional skills while training for the desired job should take advantage of the Microsoft Access Tables and Queries training! This course will keep you up-to-date with all the latest developments and coach you accordingly. So invest in this Microsoft Access Tables and Queries course if you want the best training available.

Certificate of Achievement

Quality Licence Scheme Endorsed Certificate of Achievement

Upon successful completion of the Microsoft Access Tables and Queries course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of —

- 125 GBP within UK

- 135GBP for International Delivery (Postal Fees Included)

CPD Certification

After successfully completing the assessment of this Microsoft Access Tables and Queries course, you will be eligible for a Free CPD Certificate. You can also get a Printed Hardcopy for only 2.99 GBP.

Disclaimer

This course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.

Requirements

No formal entry requirements! No prerequisites or relevant experience is required!

This course is accessible to anyone with an eagerness to learn. All you require is—

Career Path

Utilise this all-inclusive course to acquire the skills and expertise you’ll need to thrive in the workplace.

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
	Assignment – Microsoft Access Tables and Queries	6 days, 2 hours