Microsoft Access Complete Beginner to Advanced
What you'll 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
- Windows Machine with Microsoft Access
- No Prior Microsoft Access Knowledge Needed
Microsoft Access all in One Package
This Microsoft Access course combines 4 different courses.
Microsoft Access 101 - An Introduction to Access and Table Design
Microsoft Access 102 - Access Queries
Microsoft Access 103 - Form and Reports
Automate Microsoft Access Tasks with Macros and VBA
Each 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 2016
Enroll 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 Tables
Understanding Table Relationships
Building Dynamic User Data Forms
Effectively Retrieve Data Using Access Queries
Build Effective Reports
Automate Access Database Tasks with Macros and VBA
So, 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
Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 20+ years on various computer applications, including;
Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013 Excel, Word, PowerPoint, Outlook, Access and Visio
SharePoint End-User 2007, 2010, 2013
VBA (Excel and Access)
Adobe Suite Photoshop, Illustrator, InDesign
Maya (Modeling and Animation)
Unity3d (Game Design)
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:
PMI Mortgage Insurance
Bank of the West
and many more...
What Students have said about Kyle:
"Kyle was off the chart "GOOD""
"ONE OF THE BEST COURSES THAT I'VE HAD... (IN 12+ YEARS)."
"Awesome trainer because I'm computer "stupid" and he helped me understand it."
"Kyle Pew is very knowledgeable and presented information with exceptional skill."
Kyle believes that student’s best learn through the application of real-life business situations through exercises. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to new technology and skills.
In His Spare Time:
Kyle enjoys spending time with his family (6 children). When he’s not busy entertaining his kids, you will find him cheering on his favorite hockey team, the San Jose Sharks, this is their year!