Microsoft Access 2019 Beginner
Course

Microsoft Access 2019 Beginner

Simon Sez IT
Updated Nov 26, 2019

Course Overview

Microsoft Access remains an amazing tool for when your data outgrows spreadsheets. Unlike many other database tools, it’s far more user-friendly and ideal if you’re not a developer.

Target Audience

Data Analysts, Data Scientists, Statisticians, people in Financial Services, Accountancy, Audit, Tax 

Learning Objectives

In this course you will learn:

  • Where to start in Microsoft Access and whether to use a template or not
  • How to modify Access to suit your needs
  • All about importing data and the datasheet view
  • How tables work in Access and how to create relationships between them
  • Creating forms and sub-forms that feed data into your tables
  • How to run queries in Access
  • Setting up validations and calculations using expressions in Access
  • Printing from Access
  • To start to use macros and Modal Dialog
  • The basics of the Access web app
  • Exporting and reporting in Access