Skip to content
UdemyMicrosoft AccessPaid courseBeginner levelCertificate

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.

Best forOffice users who know Excel but have never built a relational database and want a calm, step-by-step start.
Skip it ifYou want hands-on projects over explanation, or need Access VBA, macros and advanced queries right away.

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.
Clayton Reed, a student

A true beginner course. You need Access 2010 or later installed to follow along, though most features also work in 2007.

icon
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

  1. 1Access Introduction 1 free preview1 lecture · 13 min
  2. 2Access Level 1 - Beginner1 lecture · 6 min
  3. 3Basics 9 free previews9 lectures · 1 quiz · 1.1 hours
  4. 4Tables14 lectures · 1 quiz · 2.6 hours
  5. 5Queries6 lectures · 1 quiz · 1.2 hours
  6. 6Forms4 lectures · 1 quiz · 52 min
  7. 7Reports10 lectures · 1 quiz · 1.5 hours
  8. 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

icon
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

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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!

icon
More courses by Kirt Kershaw

$10.99

Original price $84.9987% off

$11.99

Original price $69.9983% off

$11.99

Original price $74.9984% off

$16.99

Original price $99.9983% off

$79.99

$59.99

icon
More Microsoft Access courses

$11.99

Original price $64.9982% off

$11.99

Original price $64.9982% off

$11.99

Original price $84.9986% off

$11.99

Original price $64.9982% off

$11.99

Original price $74.9984% off

$11.99

Original price $74.9984% off

icon
Reviews

4.5

95 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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

Showing all 10 reviews on CourseDuck

Read all 95 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100