Development
QLS
Business
Healthcare
Health & Fitness
Technology
Teaching
Lifestyle
Design
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 | |||
| Assignment – Microsoft Access Tables and Queries | 00:00:00 | ||
Certificate of Achievement
Learners will get an certificate of achievement directly at their doorstep after successfully completing the course!
It should also be noted that international students must pay £10 for shipping cost.
CPD Accredited Certification
Upon successfully completing the course, you will be qualified for CPD Accredited Certificate. Certification is available –
- PDF Certificate £7.99
- Hard Copy Certificate £14.99
Recent Courses
Code with Python: Learn Classes, Methods and OOP
- IT & Software
- Office Productivity
- Personal Development
