Microsoft Access 2019/365: Beginner To Advanced
Get Your Database Up & Running Quickly!
What you’ll learn
-
Access Fundamentals: Creating Tables, Understanding the Primary Key and Data Types
-
How to Query your Database: Select queries, filtering, sorting and queries that change data
-
Relational Databases: Why and how we create links between tables
-
All about Forms: Interfacing with our Databases, create forms with and without the wizard, creating sub forms to create sophisticated data capture and using split forms
-
Reporting with ease: Using the Wizard to build a report or building a more bespoke report and adding special fields
-
Data life-cycle: Exporting Data to Excel, Word or PDF. Importing Data from a variety of sources including a mail merge set up between Access and Word
-
VBA & Macros in Access: Using buttons to carry out advanced functions, conditional outputs, use VBA to connect to SQL Server and much more!
Requirements
-
A copy of Microsoft Access. This course has been built in Access 2019/365 but works on most other versions (2007,2010,2013, 2016)
Who this course is for:
- Anyone in who needs to create and maintain a Database for a small team /project. You could be an Analyst, Accountant, Management Consultant, Project Manager, Office Manager, EA,VA, PA etc
