Access 2019 Advanced
- Description
- Course Resources
Access 2019 Advanced
- DURATION: 7.34 hours
- VIDEOS: 46
- LEVEL: Advanced
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 advanced course, we start where the beginner’s course finishes and dives straight into more advanced Access features. This course assumes you know the basics of Access, including how to set up your database, how tables work, how to create forms, and how to run simple queries.
In this advanced Access course, we look at using ODBC and SQL Server. We also take a deeper dive on using Macros and VBA in Access, splitting databases and advanced form creation. It’s perfect if you have a working knowledge of Access but need to utilize it’s more advanced features.
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
Course Certificate Included
This course includes an optional online quiz that will generate a course certificate upon completion.
Course Format
This is a video-led Microsoft Word 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.
30-Day Guarantee
We offer an unconditional, 30-day, full money-back guarantee, no questions asked. It’s our way of ensuring you have complete confidence in your membership to Simon Sez IT. With 30 days of risk-free membership, you can test-drive all of our courses and feel entirely sure you’re getting just what you need. If you don’t learn, you don’t pay.
Why Trust Us?
Simon Sez IT has been in business 10+ years and taught over 500,000 students in that time. We’ve created over 100 software training courses, 5,900+ video tutorials, and we’ve helped thousands of people across around the world learn how to use Microsoft Office and developed multiple Microsoft Word training courses.
How Do I Start?
Simon Sez IT makes complicated software simple at a fantastic price. To access this course and over 90 others, select a membership option on the right-hand side >>>
All Simon Sez IT memberships are entirely flexible (cancel anytime) and all include our no questions asked 30-day money-back guarantee.
Access 2019 Advanced
The course exercise demo files include 2 .ZIP files. You will need to download the Advanced Access 2019 Exercise Files to your PC or Mac (the files are not compatible with a mobile device).
Click on the below to open DropBox in a new browser tab, then click on “Download” in the top right-hand corner. Once downloaded all of the exercise files will be available to you.
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