Master Microsoft Access - Access from Beginner to Advanced (Udemy.com)
Develop dynamic Access databases fast in this easy to learn Microsoft Access Course (2010, 2013, 2016, 2019 & 365)
Created by: Kirt Kershaw
Last updated April 2021
What you will learn
- Build a solid understanding on the Basics of Microsoft Access
- How to create an Access Database from scratch
- Master Microsoft Access from Beginner to Advanced
- Create Tables to store and organize all raw data
- Use a Query to search and retrieve data fast
- Enter and view records in a more organized layout using Forms
- Generate very detailed, professional looking Reports
- Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 18 years of Access training
How it compares
Against the other 47 rated Udemy courses in Microsoft Access on CourseDuck:
- Rating4.4 out of 5higher than 17% of them
- Reviews1,167#7 of 48 by number of reviews
- Length17 hourslonger than 93% of them
- Last updatedApril 2021earlier than 68% of them
Course Description
Microsoft Access All-In-One Training
This Microsoft Access course includes all three Levels from Beginner to Advanced
Microsoft Access Level 1 – Beginner
Microsoft Access Level 2 – Intermediate
Microsoft Access Level 3 – Advanced
Material recorded with Access 2016 but works in 2010, 2013, 2016, 2019 and 365. MAC users, since the videos are recorded with the Windows version of Microsoft Access, the interface will be bit different.
As your instructor I will use my 18+ years of Access training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Access.
At completion of this course you will master Access skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks, as well have all the training you need to help pass the Access 2016 (77-730) Exam and become certified, like me. Below are just a few of the topics that you will master:
Create powerful, effective Access Databases
Enter, edit, update, search, sort and filter Table records
Set defaults and validate data for more accurate data entry
How to quickly edit, filter and search records in a Form
Add option controls, command buttons and drop-down lists for faster data entry and accuracy in Forms
Add custom fields to perform calculations: Sum, Count, Average and more
Add, sort and filter groups as well as keeping them from splitting across pages in your Reports
Use criteria in a Query to dramatically refine your search
View unique records and use Actions Queries to Update, Add and Delete records fast
Automate data entry and accuracy dramatically by creating Macros and much more…
Instructor Details
- 4.4 Rating
1,167 Reviews
Kirt Kershaw
Kirt Kershaw is President of Dream Force LLC and provides certified and professional training videos on Microsoft Office applications including: Access, Excel, Outlook, PowerPoint, Word, Project and Windows since 2000. His certifications include: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016. Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP), Certified Microsoft Project XP (2002), 2010 and 2013 and CompTIA's A+.
Whew! With all my certifications and experience you're probably looking at the biography of the only Microsoft trainer on the web who has the most Microsoft teaching experience and holds the most Microsoft certifications. So, I do have a lot to share in my arsenal of Microsoft Office training.
What Makes My Training Unique?
If you've read my reviews, seen my certifications (above) and my training videos, you probably already know the answer to this; I focus on step-by-step basics to more advanced training including: unique tips, tricks, shortcuts and other Microsoft Office time saving features you won't find taught in ANY other course, by the ONLY multi-certified Microsoft Office trainer since Microsoft Office 2000; including all the training you need to help pass Microsoft Access, Excel, Outlook, Project, PowerPoint and Word Exams and become certified!
More courses by Kirt Kershaw
Master Microsoft Outlook - Outlook from Beginner to Advanced (2021)
4.7 (3,650 Reviews)
Provider: Udemy
Time: 14.7h
$10.99
Master Microsoft Word - Word from Beginner to Advanced (2021)
4.4 (1,207 Reviews)
Provider: Udemy
Time: 17.5h
$11.99
Master Microsoft Excel - Excel from Beginner to Advanced (2021)
4.4 (928 Reviews)
Provider: Udemy
Time: 15.7h
$16.99
More Microsoft Access courses
Microsoft Access Networking 2: Maximum Security (2022)
4.9 (312 Reviews)
Provider: Udemy
Time: 2.2h
$64.99
Workshop 5: Access VBA, Design and Advanced Methods (2024)
4.9 (182 Reviews)
Provider: Udemy
Time: 2.2h
$64.99
Microsoft Access 2016 Master Class: Beginner to Advanced
4.8 (14,398 Reviews)
Provider: Udemy
Time: 7.2h
$11.99
Microsoft Access VBA: Automating Import of Excel Files (2021)
4.8 (543 Reviews)
Provider: Udemy
Time: 2.5h
$64.99
Workshop 3: Access VBA, Design and Advanced Methods (2024)
4.8 (212 Reviews)
Provider: Udemy
Time: 2.3h
$74.99
Workshop 4: Access VBA, Design and Advanced Methods (2024)
4.8 (208 Reviews)
Provider: Udemy
Time: 2.4h
$74.99
Reviews
By Mark Hotchkiss on 3/15/2022
Great information! Very well presented. I have just one pet peeve... these lessons repeat things WAY TOO MUCH. Repeating information covered in previous lessons is ok once or twice. But not in every lesson... At some point you need to expect that the student has an understanding of previous lessons. Also, We don't need to be reminded of your extension training videos every time an extension is discussed.
By Aaron Eagle on 10/26/2021
Kirt did a terrific job clearly explaining all pertinent aspects of MS Access. The course is broken down into levels. The building blocks are great for beginners while providing advanced topics for experienced users. I have written full-featured apps in Access and I found this very informative for the new version of Access and a great refresher of the entire program. Nice organization and demos! I'm not sure what elese he could have explained that is not readily useable.
By Alessandro Coraglia on 4/18/2021
While the course covers A LOT and I also kind of liked the passive aggressive sarcasm of the author. Whenever you have a question, this tend to disappear from the Q&As and be answered (or I should say 'not answered' in private by the instructor). I was asked to complete the course (meaning I should have watched things that were 100% irrelevant to my question) when I asked if I could be pointed out where in the course a particular question was answered (I doubt it was, but I would never know as I asked for a refund).
By Nelson S Haas on 1/15/2021
I am probably an intermediate-to-advanced Access user who has performed macro configuration and VBA programming with Access; however, I use Access sporadically for application development and not regularly. I find Mr. Kershaw's course what I expect for a good basic Access course at this point in my 18 of 153 progress. Feb 8, 2021 - At 57 of 153, I have little to add to the previous assessment. I continue to feel that this course is good and I am slowly learning more about Access.
By Isaiah Dicristoforo on 11/22/2020
I am a little over halfway done with this course, and so far it has been an awesome introduction to Access.
By Ron LaPrate on 11/15/2020
I'm on lecture 51 and it has been very detailed and thorough. I would recommend more hands on db building.
By James Sapay on 11/8/2020
I like it so far, explanations are good along with the presentation of graphics.
By Philip McDaniel on 11/8/2020
These are great courses. I plan to keep using them.
By Vijay Simha on 11/1/2020
Videos are made with necessary content and apt to the title. Looking forward to complete the course.
By Tristram Jones on 10/25/2020
This course has been very detailed and has taught me quite a bit, even though I already know most of the basic functions of Access. I'm looking forward to the advanced functions and making my databases for work better.
By Richard Burch on 10/15/2020
Yes, a good introduction but maybe a little basic for me as I have some experience with both Excel and dBASE IV but the experience with dBASE was many years ago.
By Carmen Romero on 10/13/2020
It was very clear.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 88 / 100









