Skip to content
UdemyMicrosoft AccessPaid courseIntermediate levelCertificate

Microsoft Access Level 2 - Intermediate Access (Udemy.com)

Powerup your Microsoft Access skills with more Advanced Access Tables, Queries, Forms and Reports

Created by: Kirt Kershaw

Last updated April 2021

icon
What you will learn

  • Get more accurate data entry by controlling a user’s input with controls
  • Find unique values and records, and using wildcards
  • Create prompts and do mass record updates with Action Queries
  • How to Filter and Sort records in Forms and Reports
  • Bring more functionality to Form with Tabs, Combo Boxes and Command Buttons
  • Quickly summarize the details of your records in Forms with Subforms
  • Quickly summarize the details of your records in Forms with Subforms
  • Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training

How it compares

Against the other 65 rated Udemy courses in Microsoft Access on CourseDuck:

  • Rating4.6 out of 5higher than 58% of them
  • Reviews60#61 of 66 by number of reviews
  • Length5.2 hoursshorter than 58% of them
  • Last updatedApril 2021earlier than 70% of them

icon
Course Description

Go Beyond Access Basics

Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together.

Using my 18+ years of Microsoft Access training and Certification I will guide you through these more advanced features used by many offices to more easily manage their databases and daily tasks.  Below are just a few of the topics that you will master:

  • How to set data entry defaults and using Validation Rules

  • Show a field’s history and create Lookup Fields

  • Hide duplicate values and records in a Query

  • How to use Action Queries: Update, Append, Delete and Make Table

  • Create Form drop-down lists to lookup values, or Combo Boxes

  • Add Form Option Groups that controls the list of choices available for a user

  • Add more space to your Forms without scrolling with Tabs

  • Jump around quickly to other Access Objects by creating Form Command Buttons

  • Add, Sort and Filter records in a Report, as well as keeping groups together

  • Add summary fields to your Reports and include SubReports

  • And much, much more!

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.6

60 ratings on Udemy

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

By Valentin Stefan Chiriac on 7/30/2024

Very Good the second one too. I learned something.

By MsJackson on 2/9/2022

I'm gonna help you watch and try to learn twice. I'm loving this class. Thank you

By Nakacwa Sandra on 1/12/2022

very informative content and awesome explanation.

By Jose Acevedo on 11/6/2020

the best please keep the good work

By Bert Kriebel on 8/29/2020

Excellent course! I like the no nonsense approach to the lectures - to the point without extra unnecessary explanations.

By Dianne Bailey on 7/29/2020

Excellent class and great instructor!

By Marisa Harte on 5/4/2020

Excellent presentation and explanation. Very thorough.

By Felix Edosomwan on 1/28/2020

Very good. I'm ready for the Advanced class.

By Greg Oxnard on 8/25/2019

Only viewed a few modules so far, but I like the presentation and delivery style. No waffle! I'll post another review when I've worked through the whole course.

By Andre on 8/2/2019

Love the sense of Humor ! Excellent tutoring !

Showing all 10 reviews on CourseDuck

Read all 60 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 : 92 / 100