• Corporate Courses
  • CompTIA
Office 365

Microsoft Access for Office 365–Part 1

Build rock-solid database skills in just 1 instructor-led day. This hands-on course teaches you how to design, create, query and report on relational data—putting you on the fast track to the Microsoft Office Specialist Access Expert certification (Exam MO-500).

Enquire Now

Why choose this course?

  • Foundations done properly – master navigation, table design, relationships, queries, forms and reports in a single day.
  • Part 1 of a three-course series that ultimately prepares you for Access Expert Exam MO-500.
  • Ideal for anyone who touches data but isn’t a full-time developer – learn practical skills you can use immediately.
  • Hybrid delivery: attend on-campus or virtually from anywhere in South Africa.
See Course Content

This course is ideal for:

  • Professionals who need to create or maintain small-to-medium databases.
  • Excel power-users ready to step up to relational data management.
  • Anyone beginning the Microsoft Office Specialist Access certification journey.

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.
  • Comfort with Microsoft Windows and basic Office apps (e.g., saving files, switching programs). Prior Excel experience is helpful.

Course Content

  • Working with an Access Database – launch Access, navigate tables, queries, forms & reports
  • Creating Tables – plan a database, build tables, define relationships
  • Creating Queries – join, sort, filter data; calculated columns
  • Creating Forms – design user-friendly data-entry forms
  • Creating Reports – build & format professional reports

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.