Access 2019

Microsoft Access 2019 Training

Is This Course for You?

The course is designed for those who are interested in creating and working with databases using Microsoft Access 2019 software.

About the Course

The course offers an exciting and innovative approach to Access training. It consists of 19 modules and includes media demonstrations, hands-on activities, and knowledge check questions.

At the end of the course, you will complete a consolidation exercise to review what you have learned and assess your understanding.

The course also contains quizzes at the end of each module and a Validation Test at the end of the course. With successful completion, you will receive a Pitman Training certificate to verify your achievement.

Aims and Objectives

The aim of the course is for you to learn the core features and functions of the Microsoft Access 2019 database management application so that you will be effective in creating and managing databases.

Pre-requisites

Familiarity with the Windows environment and experience using a computer keyboard.

Course Content

• Module 1: Introduction to Microsoft Access 2019
• Module 2: The Ribbon and Toolbars
• Module 3: Keyboard Shortcuts and Key Tips
• Module 4: Access Options
• Module 5: Tables
• Module 6: Importing Data
• Module 7: Backup, Compact, and Repair
• Module 8: Datasheet View
• Module 9: Relationships between Tables
• Module 10: Forms
• Module 11: Subforms
• Module 12: Queries
• Module 13: Expressions
• Module 14: Reports
• Module 15: Printing and Print Properties
• Module 16: More Data Types
• Module 17: More About Forms
• Module 18: Exporting Databases
• Module 19: Additional Backstage Features

Career Path

Microsoft Access is a very popular database application widely used across many employment sectors to keep accurate, up-to-date records of customers, projects, products, etc. Knowing how to effectively set up and manage databases will be a valuable skill set in many work environments.

Course Duration

25 hours. This will vary from individual to individual based on prior knowledge and ability.

CPD Points

CPD Points: 25 (awarded upon successful completion).