• Corporate Courses
  • CompTIA
Office 365

Microsoft Access for Office 365 – Part 3

Master advanced Access techniques in just 1 instructor-led day. This course shows you how to manage databases, automate tasks with macros and VBA, and lock down multi-user security – putting the finishing touch on your journey to the Microsoft Office Specialist Access Expert certification (Exam MO-500).

Enquire Now

Why choose this course?

  • Professional-grade database management – tackle importing/exporting, split databases for teams, and keep performance humming with compact/repair and analysis tools.
  • Automation & custom UX – build macros and intro-level VBA to streamline workflows and craft polished navigation forms.
  • Bullet-proof security – learn ACCDE packaging, digital signatures and role-based access for confident sharing.
  • Completes the three-course pathway to the Access Expert MO-500 exam.
  • Hybrid delivery – attend on-campus or virtually from anywhere in South Africa.
See Course Content

This course is ideal for:

  • Database administrators or power users ready for advanced Access skills.
  • Teams that need to automate data tasks and secure shared front-end/back-end databases.
  • Learners completing the Microsoft Office Specialist Access certification track.

Prerequisites

  • Microsoft® Windows® 10 Professional or Enterprise
  • Microsoft® Office 365™ license (which provides the Microsoft Office apps) Note: The Office 365 plan you use depends on the licensing available in your environment. If you wish to use a trial version, Office 365 Business Premium is acceptable. This course was not tested with Office 365 Home or Office 365 Personal; some features might not be available in these editions.
  • Completion of Microsoft Access for Office 365 – Part 1 & Part 2 or equivalent hands-on experience with database design, forms, reports and queries.

Course Content

  • Import & Export Table Data – link external data, export to other apps, mail-merge with Word
  • Use Queries to Manage Data – action queries (append, update, delete), unmatched & duplicate queries
  • Create Complex Reports & Forms – sub-reports, navigation forms, drill-down subforms & pop-ups
  • Create Access Macros – automate tasks, program UI components, conditional filtering, data macros
  • Use VBA to Extend Capabilities – VBA basics, event-driven code with form controls
  • Manage a Database – backups, compact & repair, performance analyser, object dependencies, documentation

Hardware Requirements

For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware configurations:

  • 6 GHz or faster 32-bit (x86) or 64-bit (x64) multi-core processor
  • 4 gigabyte (GB) RAM (64-bit) or 2 GB RAM (32-bit)
  • 20 GB available hard disk space (64-bit) or 16 GB (32-bit)
  • Keyboard and mouse (or other pointing device)
  • 1280 × 1024 or higher resolution monitor recommended
  • Network cards and cabling for local network access
  • Internet access (contact your local network administrator)
  • Printer (optional) or an installed printer driver
  • Projection system to display the instructor’s computer screen

Interested?

Enquire today and one of our consultants will be in touch.