'Access Masterclass; Level 1 & 2 - Beginner to Intermediate' is ideal for the beginner to Access or databases and also 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.
I've been a course instructor in the data science sphere for about 3 years. I have a particular passion for statistics/statistical programming and predictive modeling. I learned programming partly through school and partly self-teaching. At one point I was a Graduate student in Educational Psychology but decided at some point during that program that teaching and creating online content in the data science sphere was even a bigger passion.
Frequently Asked Questions
It is an online tutorial that covers a specific part of a topic in several sections. An Expert teaches the students with theoretical knowledge as well as with practical examples which makes it easy for students to understand.
A Course helps the user understand a specific part of a concept. While a path and E-Degrees are broader aspects and help the user understand more than just a small area of the concept.
A Course will help you understand any particular topic. For instance, if you are a beginner and want to learn about the basics of any topic in a fluent manner within a short period of time, a Course would be best for you to choose.
We have an inbuilt question-answer system to help you with your queries. Our support staff will be answering all your questions regarding the content of the Course.
Frequently bought together
Combo Price: 0 (Extra Discount: NAN%)