Microsoft Access Complete Diploma - Beginners, Intermediate & Advanced - CPD Certified

COURSE CURRICULUM

Microsoft Access for Beginners

• 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 Beginners Level

Microsoft Access for intermediate level

• 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 Level

• 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

• Mock Exam- Microsoft Access Complete Diploma – Beginners, Intermediate & Advanced

• Final Exam – Microsoft Access Complete Diploma – Beginners, Intermediate & Advanced

Assessment and Certification

At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39.