Microsoft Access Level 1 - Beginner Access (Udemy.com)
Learn Microsoft Access skills that will give you a solid foundation from a Microsoft Certified Access Specialist
Created by: Kirt Kershaw
Last updated April 2021
Our take
Based on the ratings of 95 students, a sample of their written reviews and the syllabus, as the course stood in April 2021. No course pays to be reviewed.
This is Kirt Kershaw's entry-level Access course, the first of three he sells as a path to the Access 2016 certification exam. It runs about 7.5 hours over 46 lectures and covers the core four: tables, queries, forms and reports. Tables get the most time, about two and a half hours, including primary, composite and foreign keys and one-to-many relationships. It suits people who live in Excel and need a real database, and self-taught users who want to fill gaps.
Reviewers keep calling Kershaw thorough, clear and methodical, and several say they are moving on to his Level 2 and 3. One student built an inventory and customer database for a non-profit with it. The complaints are specific. A 2024 reviewer says the audio fades and the screen loses focus at times, and suggests a re-record. Others find it heavy on theory, say he talks fast, or note the sorting lesson actually covers filtering. One unhappy student found it slow and badly structured.
The course was recorded in Access 2016 and last updated in April 2021. The requirements list versions from 2010 through 365, and one reviewer says most features are unchanged and the principles transfer. With 95 reviews and a 4.5 rating, almost all four and five stars, it's a dependable, unflashy foundation. Recommended if you plan to continue through the series; less so if you just want to build something quickly.
Pros
- Clear, methodical teaching that reviewers say makes Access click even with no database background
- Over two hours on tables, keys and relationships, the part beginners usually get wrong
- Exercise files and five quizzes let students follow along in their own copy of Access
- Leads straight into Levels 2 and 3 for anyone aiming at the Access 2016 exam
Cons
- Recorded in Access 2016 and last updated in 2021; one reviewer reports fading audio and blurry screens
- Some find it theory-heavy and fast-talking, with little in the way of practical projects
- Minor gaps like a sorting lesson that covers filtering, and unclear notes on which file to open
The instructor does an outstanding job at covering the material. He was very thorough and kept the training fun.
A true beginner course. You need Access 2010 or later installed to follow along, though most features also work in 2007.
What you will learn
- How to create an Access Database from scratch
- 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 17 years of Access training
Course content
8 sections · 46 lectures · 7.6 hours of video 5 quizzes, 1 article
- 1Access Introduction 1 free preview1 lecture · 13 min
- 2Access Level 1 - Beginner1 lecture · 6 min
- 3Basics 9 free previews9 lectures · 1 quiz · 1.1 hours
- 4Tables14 lectures · 1 quiz · 2.6 hours
- 5Queries6 lectures · 1 quiz · 1.2 hours
- 6Forms4 lectures · 1 quiz · 52 min
- 7Reports10 lectures · 1 quiz · 1.5 hours
- 8Course Wrap Up1 lecture
Who it is for
The instructor says it suits
- This Microsoft Access Beginner Level 1 course is for anyone who is just starting out in Access
- For those who’ve used Access, but want to find out some little-known tips, tricks and shortcuts and become more efficient
- Anyone who wants all the training needed from all three Levels of my Access courses to take the Microsoft Access 2016 (77-730) Exam and become certified
What you need before you start
- This course was created with Access 2016; however, all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007
- You will need Microsoft Access installed on your computer to follow along and complete the exercise files
How it compares
Against the other 65 rated Udemy courses in Microsoft Access on CourseDuck:
- Rating4.5 out of 5higher than 33% of them
- Reviews95#53 of 66 by number of reviews
- Length7.5 hourslonger than 63% of them
- Last updatedApril 2021earlier than 70% of them
Course Description
Quickly Get a Solid Foundation on Access Basics
During this Microsoft Access Level 1 – Beginner course you will gain a solid foundation on which you will build the rest of your Access experience on. Enroll now and I'll guide you step-by-step, through the basics of creating relational databases and working with Tables, Queries, Forms and Reports. In very little time you will master the basics of Access that'll provide a sure foundation for more advanced Access techniques.
At completion of this course you will have mastered the most popular Access basic tools and have the foundational skills with a sureness to complete many daily Access tasks with efficiency and ease. Below are just a few of the topics that you will master in Access:
Build a solid understanding on the basics of Microsoft Access
Step by step in creating Microsoft Access Databases
Create Tables and how to enter, filter and sort Records
Create Primary, Composite and Foreign keys to link Tables
How to create relationships One-to-One and One-to-Many
Create a Query and how to add calculating fields
Create Forms to view records in a more organized layout
Use Reports to display your records in printable and/or email formats
Instructor Details
- 4.5 Rating
95 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
Original priceMaster Microsoft Word - Word from Beginner to Advanced (2021)
4.4 (1,207 Reviews)
Provider: Udemy
Time: 17.5h
$11.99
Original priceMaster Microsoft Access - Access from Beginner to Advanced (2021)
4.4 (1,167 Reviews)
Provider: Udemy
Time: 17h
$11.99
Original priceMaster Microsoft Excel - Excel from Beginner to Advanced (2021)
4.4 (928 Reviews)
Provider: Udemy
Time: 15.7h
$16.99
Original priceMicrosoft PowerPoint - PowerPoint from Beginner to Advanced (2021)
4.3 (615 Reviews)
Provider: Udemy
Time: 12.5h
$79.99
Microsoft Access Level 2 - Intermediate Access (2021)
4.6 (60 Reviews)
Provider: Udemy
Time: 5.2h
$59.99
More Microsoft Access courses
Microsoft Access Networking 2: Maximum Security (2022)
4.9 (312 Reviews)
Provider: Udemy
Time: 2.2h
$11.99
Original priceWorkshop 5: Access VBA, Design and Advanced Methods (2024)
4.9 (182 Reviews)
Provider: Udemy
Time: 2.2h
$11.99
Original priceMicrosoft Access 2016 Master Class: Beginner to Advanced
4.8 (14,398 Reviews)
Provider: Udemy
Time: 7.2h
$11.99
Original priceMicrosoft Access VBA: Automating Import of Excel Files (2021)
4.8 (543 Reviews)
Provider: Udemy
Time: 2.5h
$11.99
Original priceWorkshop 3: Access VBA, Design and Advanced Methods (2024)
4.8 (212 Reviews)
Provider: Udemy
Time: 2.3h
$11.99
Original priceWorkshop 4: Access VBA, Design and Advanced Methods (2024)
4.8 (208 Reviews)
Provider: Udemy
Time: 2.4h
$11.99
Original price
Reviews
By Marie Elena Villanueva on 2/22/2024
It was a good course, however, many times throughout the course the audio would fade out and the screen would go out of focus. Maybe it is time to rerecord the course.
By Shalom Schwartz on 10/9/2023
A lot of theory, wanted a more practical learning experience.
By C on 3/26/2023
Excellent very clear and methodical. I have extensive knowledge of Word and Excel but none in Access so I did know some common features but the teaching is so concise I wasn't sat for whole lessons bored. It doesn't matter that this is a couple of years old - most features are the same but more importantly he teaches the principles of doing things, where commands are likely to be, so these skills are easily transferable. Highly highly highly recommended.
By Melody Nare on 6/20/2020
It is a very good tutorial with good examples. Improvement would be: 1. Mention that for each sub section the student should open the database in the folders. Seems obvious once you get it but it was confusing at first. 2. tutor speaks very fast, so sometimes it is a struggle to keep up, especially with the practical work. 3. the Sorting section actually talks about filtering, so it means this was skipped from the tutorial and will need to be added.
By Marisa Harte on 5/3/2020
I am already very familiar with Access, and wanted to learn this instructors style before moving into course #2 & #3. He is very thorough
By Rajesh Kumar Sahay on 3/26/2020
Nicely explained each and every aspects. Excellent Teacher and his efforts is wonderful.
By Angela M Haan-Cloud on 2/28/2020
Great first lesson. I was wondering if it would progress too quickly for me to keep up... pace was perfect.
By Doreen Ofiera on 2/18/2020
Love the easy step by step teaching. I took that course to help a non-profit organization to organize their inventory and customers... We can generate reports now I’m pretty ok in Excel but couldn’t teach my volunteers to do so. Creating an interface for the data entry and forcing them to stay on track helps A LOT. I can‘t wait to dig deeper to make it even more efficient with Access Level 2. BTW I‘m German and I had no issues following up. Thank you Kirt for providing such a great course! Dori
By Clayton Reed on 12/4/2019
Great Course and Outstanding Instructor! The instructor does an outstanding job at covering the material. He was very thorough and kept the training fun. This is the first of three Access courses that I purchased from him and I am looking forward to taking the other two courses. Thank you Kirt for the professional Access training.
By Andrew Ferguson on 12/1/2019
I'm self taught but I need to know I have the grasps of all the basics. Explanations seem clear and concise so far
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 90 / 100












