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
