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
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
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!
Instructor Details
- 4.6 Rating
60 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 1 - Beginner Access (2021)
4.5 (95 Reviews)
Provider: Udemy
Time: 7.5h
$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 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 !
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100












