Microsoft Access Complete Beginner to Advanced (Udemy.com)

Ultimate Microsoft Access Training - Create & Maintain Access Tables, Access Queries, Access Forms, Access Reports

Created by: Kyle Pew

Produced in 2019

icon
What you will learn

  • Manage Large Sets of Data in Microsoft Access Relational Design
  • Build an Efficient Database Table Design
  • Control User Data Entry Effectively
  • Build Dynamic Access Database Queries
  • Present Dynamic Reports
  • Build Automation, Saving Time and Money

icon
Quality Score

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

Overall Score : 94 / 100

icon
Course Description

Microsoft Access all in One PackageThis Microsoft Access course combines 4 different courses.
Microsoft Access 101 - An Introduction to Access and Table DesignMicrosoft Access 102 - Access QueriesMicrosoft Access 103 - Form and ReportsAutomate Microsoft Access Tasks with Macros and VBAEach Section, (Intro/Tables, Queries, Forms, Reports and Macros/VBA), will start at the basic level and progress to an advanced level with the section.
Material recorded with Access 2016 but works in 2007, 2010, 2013, and 2016Enroll now to go through a deep dive of the popular end-user relational database tool, Microsoft Access. As your instructor I will use my 15+ years of Access training to guide you step by step through the beginner to advanced level and beyond.
As you participate in each of the 4 courses you will master Access tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.
At completion of this course you will have mastered the most popular Access tools and come out with confidence to complete any Access tasks with efficiency and grace. Below are just a few of the topics that you will master:
Creating Effective Database TablesUnderstanding Table RelationshipsBuilding Dynamic User Data FormsEffectively Retrieve Data Using Access QueriesBuild Effective ReportsAutomate Access Database Tasks with Macros and VBASo, what are you waiting for, enroll now and take the next step in mastering Access and go from Access Newb to Access Guru!
Who this course is for:
Users Looking to Gain a Working Knowledge of Microsoft Access from Beginner to Advanced

icon
Instructor Details

Kyle Pew

Qualifications:
Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including;
Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013Excel, Word, PowerPoint, Outlook, Access and Visio
SharePoint End-User 2007, 2010, 2013
VBA (Excel and Access)
Adobe SuitePhotoshop, Illustrator, InDesign
Maya (Modeling and Animation)
Unity3d (Game Design)
HTML, CSS and JavaScript
Crystal Reports
Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.
Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.
Some of the clients Kyle has provided training for include:
Brocade
Chevron
Genentech
Facebook
Levi Strauss
PMI Mortgage Insurance
State Fund
Bank of the West
VISA
Walmart
and many more...


What Students have said about Kyle:
"Kyle was off the chart "GOOD""
<

icon
More courses by Kyle Pew

Excel from Beginner to Advanced

$11.99

Excel with Microsoft Excel VBA User Forms

$11.99

Master Microsoft Excel Macros and Excel VBA

$11.99

Microsoft PowerPoint From Beginner to Advanced

$11.99

SharePoint 2013 Complete Training

$11.99

Master Microsoft Word Beginner to Advanced

$11.99

icon
More office productivity courses

MS-700 Managing Microsoft Teams Training & Lab Simulations

$11.99

How to Create Animated Videos with Powerpoint

$11.99

Microsoft PowerPoint From Beginner to Advanced

$11.99

Productivity Hacks for Writers (Writing Mastery)

$11.99

Powerpoint 2016 2019 - Master powerpoint presentation

$11.99

Master Microsoft Word Beginner to Advanced

$11.99

icon
Reviews

4.7

310 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Chris Mansfield on 11/15/2020

Thought i was just going to refresh lost knowledge from 15 years ago, but picking up new tips and information. I really relate and engage with the delivery method and style of tutor.

By Vivek Mathur on 11/15/2020

I believe that the course started with a lot of promise and clearly, the instructor is knowledgeable and experienced. However, from the point of view of take-aways, this course has very little to offer. The project could have been more comprehensive dealing with using the VBA code to run queries and updating the database. The course can also utilize the immense potential for teaching coding and linking inherent in the Northwind database that could have been utilized to demonstrate the true power of MS Access. All said and done, I can say that I enjoyed the journey but my expectations on take-away were only met half-way.

By Alfredo Silva on 11/8/2020

So far is very comprehensive

By Justin Choon on 11/8/2020

Great to beginner

By Jayden Kyler Campbell on 11/8/2020

As a person with 9-12 hours of experience in access, I feel that this course is a good mix of teaching me stuff that I didn't know, and reinforcing what I already knew.

By Brandon Bannigan on 11/8/2020

Its a little too slow and overexplained but covers a lot

By Jake Wurz on 11/8/2020

I have taken online courses before, but this is the first one where i felt like being in a real classroom.
Great instructor!

By Richard Bohn on 10/27/2020

not very far into it yet

By Jeffrey Wolbach on 10/27/2020

Waiting to get to content I don't already know. Presenter is pleasant; I expect to learn easily from him.

By Henry Kijanka on 10/27/2020

Very Hands on and well presented. Loved the way Kyle explained and showed how to do queries and form design especially.

By Harlan Russell on 10/26/2020

Kyle is an Teaching Rock Star. I own about all of his courses. I love the way he teaches and improves his students to preform in the Real World. Thanks Kyle!

By Almoatazbellah Ismail on 10/24/2020

Big Experience