Level 3 Diploma in Microsoft Access

Course details

Microsoft Access is a database management system (DBMS) from Microsoft. This software combines the relational Jet Database Engine with a graphical user interface and software-development tools. It stores data in its format based on the Access Jet Database Engine. Through this course, you will learn from beginner, intermediate, and advanced level skills, knowledge, and information about Microsoft Access 2013. You will then know the different components of the database so that you understand the structure underlying your data to know data manipulation and user control.

COURSE CURRICULUM

Microsoft Access Essentials

• Module One – Getting Started
• Module Two – Opening and Closing Access
• Module Three – An Introduction to Databases
• Module Four – Sharing Data Using Apps
• Module Five – Working in Your App
• Module Six – An Introduction to Desktop Databases
• Module Seven – Performing Basic Table Tasks
• Module Eight – Working with Fields
• Module Nine – Working with Table Relationships
• Module Ten – An Introduction to Queries, Forms, and Reports
• Module Eleven – Protecting Your Data
• Module Twelve – Wrapping Up
• Activities – Microsoft Access for Beginners

Microsoft Access Expert

• Module One – Getting Started
• Module Two – Creating a Custom App
• Module Three – Customizing App Actions
• Module Four – Customizing Your App Views with Macros
• Module Five – Working with Validation Rules and Messages
• Module Six – Working with Macros
• Module Seven – Advanced Query Tasks
• Module Eight – Designing Forms
• Module Nine – Advanced Reporting Tasks
• Module Ten – Advanced Database Tools
• Module Eleven – Working with the Access Environment
• Module Twelve – Wrapping Up
• Activities – Microsoft Access Intermediate Level

Microsoft Access Advanced

• Module One – Getting Started
• Module Two – Using App Views
• Module Three – Customizing Apps, Part One
• Module Four – Customizing Apps, Part Two
• Module Five – Working with More Record Tasks
• Module Six – Using Advanced Field Tasks
• Module Seven – Working in Table Design View
• Module Eight – Working with the Expression Builder
• Module Nine – Working with External Data
• Module Ten – Creating Queries
• Module Eleven – Creating Forms and Reports
• Module Twelve – Wrapping Up
• Activities – Microsoft Access Advanced Level

Updated on 03 June, 2018