Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
13 Hour(s) 16 Minute(s)
Language
English
Taught by
Kyle Pew • 2,000,000+ Students, Office Newb
Rating
Course Overview
Ultimate Microsoft Access Training - Create & Maintain Access Tables, Access Queries, Access Forms, Access Reports
Microsoft Access all in One Package
This Microsoft Access course combines 4 different courses.
Microsoft Access 101 - An Introduction to Access and Table Design
Microsoft Access 102 - Access Queries
Microsoft Access 103 - Form and Reports
Automate Microsoft Access Tasks with Macros and VBA
Each Section, (Intro/Tables, Queries, Forms, Reports and Macros/VBA), will start at the basic level and progress to an advanced level with the section.
Material recorded with Access 2016 but works in 2007, 2010, 2013, 2016, 2019, Microsoft 365/2025
Enroll now to go through a deep dive of the popular end-user relational database tool, Microsoft Access. As your instructor I will use my 15+ years of Access training to guide you step by step through the beginner to advanced level and beyond.
As you participate in each of the 4 courses you will master Access tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.
At completion of this course you will have mastered the most popular Access tools and come out with confidence to complete any Access tasks with efficiency and grace. Below are just a few of the topics that you will master:
Creating Effective Database Tables
Understanding Table Relationships
Building Dynamic User Data Forms
Effectively Retrieve Data Using Access Queries
Build Effective Reports
Automate Access Database Tasks with Macros and VBA
So, what are you waiting for, enroll now and take the next step in mastering Access and go from Access Newb to Access Guru!
Course Content
- 10 section(s)
- 173 lecture(s)
- Section 1 Course Introduction and Exercise Files
- Section 2 Access Overview - Quick Overview of Access Interface
- Section 3 Access Overview - Fundamentals of Access Objects
- Section 4 Access Tables - Working with Table Data
- Section 5 Access Tables - Creating Tables in Your Access Database
- Section 6 Access Tables - Microsoft Access Table Exercise
- Section 7 Access Tables - Working with Access Table Relationships
- Section 8 Access Queries - Working with Access Select Queries
- Section 9 Access Queries - Query Calculated Fields
- Section 10 Access Queries - Summarizing Data in an Access Query
What You’ll Learn
- Manage Large Sets of Data in Microsoft Access Relational Design
- Build an Efficient Database Table Design
- Control User Data Entry Effectively
- Build Dynamic Access Database Queries
- Present Dynamic Reports
- Build Automation, Saving Time and Money
Skills covered in this course
Reviews
-
VVictor Mwavu
Excellent presentation and delivery. Nice and simple.
-
MMartin Kandrík
great learning experience with nice way of explaining. I`m beginner in general, and not native speaker as well. But I did try access for 1 month prior buying this course. I can say, that I did get my head around the basics, but I was never bored during that explanations and still found something new to learn. And I`m going to dive into the funny stuff (section 14 and beyond). @Kyle, thank you for this. Great work
-
CCynthia Urbina
I am familiar with MS Office, but as with all things, you can't know everything, so very informative.
-
SSteve McGuinness
Very easy to follow, everything was very clearly explained and I was able to pick this up very quickly. Looking forward to doing some more courses with Kyle to further develop my skills !
