Access 2019
- Description
- Course Resources
Access 2019
- DURATION: 8.7 hours
- VIDEOS: 60
- LEVEL: Beginner
Microsoft Access remains a fantastic 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.
In this Microsoft Access 2019 beginners course, we start at the very beginning and assume you know nothing about MS Access. We take a project approach to this course, which means you build your project out as we go. By the end of this Access 2019 course, you will have built out your database with proper functionality.
If you’ve used Excel in the past, that will help, but it’s not essential. This course is for someone just starting in Access.
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
Course Format
This is a video-led training course. You can preview some videos in the pane above. This course includes practice exercises so you can practice as you learn. This course is suitable for Windows users.
This course is also suitable for Office 365 users.
Access 2019
The course exercise demo files include 2 .ZIP files. You will need to download the Access 2019 Exercise Files.zip and the Access 2019 Course Files.zip to your PC or Mac (the files are not compatible with a mobile device) and unzip the file.
Click on the below to open DropBox in a new browser tab, then click on “Download” in the top right-hand corner. Once downloaded you can unzip the folder and all of the exercise files will reside in individual folders.
What people are saying
Trusted by
Start Your Membership
Simon Sez: “Let’s make you a software superstar!”
From Excel to photo editing, experience quality courses that ensure easy learning.
START YOUR MEMBERSHIPLearn More