Access Masterclass; Level 1 & 2 - Beginner to Intermediate
- 7 hours on-demand video
- 1 article
- 1 downloadable resource
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- How to work with the Graphical User Interface and the 4 Main Objects (Tables, Reports, Queries and Forms)
- Be able to understand and apply database principles to ensure data integrity
- Be able to import Excel spreadsheets into Access via GUI and VBA while applying proper database principles
- Understand the fundamentals of Access Macros
- Understand the fundamentals of VBA
- No prior experience is required
'Access Masterclass; Level 1 & 2 - Beginner to Intermediate' is ideal for the beginner to Access or databases and delves into more intermediate topics like VBA and Macros.
You will start by Mastering the Access Graphical User Interface and then you will get introduced to Database Design, Macros, and VBA. We will also show you how to import Excel files via multiple options, including GUI and three examples using VBA.
This course starts by using the Access Graphical User Interface to build tables, reports, queries, and forms. These sections get you comfortable working with the Access Graphical User Interface to create and work with the 4 main objects in Access (Tables, Reports, Queries, Forms).
Access was designed to make it possible to build solid desktop databases by largely using the GUI. This makes development faster and easier, and it is one of the reasons that Access has continued to be popular despite new competition.
Next, we build on this GUI knowledge by showing you the fundamental principles of database design. The concepts of normalization, relationships, and referential integrity are fundamental to understand if the goal is to eventually develop databases that can be used for serious purposes (ie a small business).
Next, you will learn how to import Excel files into Access using the GUI while not breaking the rules of database design. You will then do the same but using VBA code. We will show you three different versions, from most simple to most complex but also the most flexible option and one that leads to better user experience.
Finally, you will learn about Macros and how to use them.
There is no reason to wait anymore...Udemy offers a 30-day money back guarantee if you are not happy with the course for any reason.
- Excel users who want to use Excel and Access together but need to learn Access
- Beginners to databases and Access
Just a few tips so you can have the best experience with the course.
I introduce you to Tables, which are one of the 4 main objects in Access. Tables are the object that store the data.
I discuss editing records, including getting comfortable moving around the records and fields of a table, and adding/deleting records.