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:
- All about Primary Keys and Indexes in Access
- About customizing and filtering on the Datasheet View
- How to link to other databases
- All about using ODBC and SQL Server
- How to split an Access database into front and back-end
- All about Macros in Access including AutoExec
- How to do basic VBA in Access including code and error handling
- More advanced techniques around creating forms in Access
- Advanced queries including “multiple where” criteria
