• Corporate Courses
  • CompTIA
Office 365

Microsoft Access for Office 365 – Part 2

Level-up your database skills in 1 instructor-led day. This intermediate course shows you how to optimise, validate and analyse relational data – putting you one step closer to the Microsoft Office Specialist Access Expert certification (Exam MO-500).

Enquire Now

Why choose this course?

  • Optimise performance & integrity – learn normalisation, referential integrity and other best-practice techniques that make databases faster and more reliable.
  • Promote quality data input – add field, record and form-level validation to stop bad data before it starts.
  • Unlock powerful analysis – create advanced joins, sub-queries and summary queries that answer real business questions.
  • Part 2 of a 3-course pathway that ultimately prepares you for Access Expert Exam MO-500.
  • Hybrid delivery – attend on-campus or virtually from anywhere in South Africa.
See Course Content

This course is ideal for:

  • Users who already build basic tables, queries, forms and reports in Access and want to go deeper.
  • Data professionals who must optimise existing Access databases for speed, accuracy and ease-of-use.
  • Anyone progressing along 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 or equivalent hands-on experience with basic database design and objects.

Course Content

  • Promoting Quality Data Input – field & form validation, record-level rules
  • Improving Efficiency & Integrity – data normalisation, table relationships, enforced referential integrity
  • Enhancing Table Usability – lookup fields, subdatasheets
  • Creating Advanced Queries – complex joins, sub-queries, aggregate summaries
  • Improving Form Presentation – conditional formatting, tab pages, sub-forms
  • Creating Advanced Reports – calculated fields, charts, pagination & print control

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)
  • Installed printer driver for PDF printing
  • Projection system to display the instructor’s computer screen

Interested?

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