All Levels
16 hours
Java Tutorial for Complete Beginners
Learn to program using the Java programming language
John Purcell
What you'll learn:
- ✓Learn to program in Java
16 hours
73 lectures
Access on mobile and TV
Certificate
DevelopmentJava
All LevelsOffice ProductivityMicrosoft Access
Microsoft Access 2016 Master Class: Beginner to Advanced
Quickly learn how Microsoft Access 2016 can make your life easier and more productive!
Created by Joe Parys, Bruce Myron, Joe Parys Support
7 hours
Video Content
75
Lectures
56,962
Students
4.7
Rating
4.7
(56,962 students enrolled)What you'll learn
✓Understand how Access is constructed and how to use the major objects within it.
✓Discover THREE Major Data Problems That Access Completely Resolves
✓Learn the parts of the Access screen
✓Learn table, report and query objects
✓Master PROPERTIES to make thousands of choices manageable
✓Learn the basics of form objects
✓Fully understand tables, queries, reports and forms
✓Use automation in your forms with buttons and Macros
✓Create a multi page invoice
Course Content
17 sections • 75 lectures • 07:14:24 total length
Introduction: Welcome To The Complete Microsoft Access 2016 Master Class Course!
2 lectures • 01:54
Introduction: Welcome To The Complete Microsoft Access 2016 Master Class Course!
2 lectures • 01:54
Introduction & Course Benefits: How To Get Started With Microsoft Access 2016!00:34
Course Overview & Layout: How To Use This Course To Gain The Maximum Experience!01:20
THREE Major Data Problems That Access Completely Resolves
5 lectures • 16:00
THREE Major Data Problems That Access Completely Resolves
5 lectures • 16:00
A Quick Note BEFORE Starting Section 200:16
Bruce's Intro and Three Data Problems Overview04:56
Access Solves the SIZE and SPEED Problem03:37
Access Solves the DATA SHARING Problem03:40
Access Solves the ONE to MANY Problem03:31
Learning the Parts of the Access 2016 Screen
3 lectures • 12:33
Learning the Parts of the Access 2016 Screen
3 lectures • 12:33
Important NOTE on DOWNLOADABLE RESOURCES00:21
The Parts of the Access 2016 Screen01:52
Working with the Navigation Pane, Menu, Ribbons and Objects10:20
The Parts of the Access 2016 Screen3 questions
TABLE Objects - the Basics
5 lectures • 36:09
TABLE Objects - the Basics
5 lectures • 36:09
Creating Our First Table and Data Type PDF09:01
Adding, Editing and Deleting Records08:05
Primary Keys: What They Are and Why They Are Important03:48
Adding Autonumbers, Primary Keys and Restructuring Tables06:54
Basic Table Sorting and Filtering08:21
+1 more lectures
REPORT Objects - the Basics
3 lectures • 19:25
REPORT Objects - the Basics
3 lectures • 19:25
What do reports do?04:11
Modifying the Report05:41
Working with Controls, Report and Layout Views09:33
Review of the REPORT Objects4 questions
QUERY Objects - the Basics
5 lectures • 26:39
QUERY Objects - the Basics
5 lectures • 26:39
Basic Queries06:45
Query Criteria05:12
Date Criteria and Between05:32
Using OR in Criteria04:17
Parameter Queries04:53
+1 more lectures
PROPERTIES: Making Thousands of Choices Manageable
4 lectures • 26:27
PROPERTIES: Making Thousands of Choices Manageable
4 lectures • 26:27
Viewing Table Properties and Custom Formatting PDF09:51
Field Validation and Other Field Properties05:32
Query Properties04:53
Report Properties06:11
Review of Properties5 questions
FORM Objects - the Basics
4 lectures • 26:50
FORM Objects - the Basics
4 lectures • 26:50
Creating a Form with the Wizard04:14
Cleaning Up the Form - Working With Controls07:41
More Form Cleanup - Moving Labels, Adding Rectangles, Font Color10:20
Resize Header and Detail and Finish Form04:35
Review of Basic Forms7 questions
Advanced TABLES
4 lectures • 22:50
Advanced TABLES
4 lectures • 22:50
Using the Lookup Wizard05:16
Setup Lookups Without the Wizard05:45
Advanced Sorting and Filtering05:48
Working with Related TABLES06:01
Review of Advanced Tables4 questions
Advanced QUERIES
8 lectures • 46:04
Advanced QUERIES
8 lectures • 46:04
Using TOP queries04:02
Using TOTAL Queries09:10
ACTION queries - UPDATE06:25
ACTION queries - APPEND04:27
Multi Table and MAKE TABLE ACTION Queries08:32
+4 more lectures
Advanced REPORTS
7 lectures • 41:50
Advanced REPORTS
7 lectures • 41:50
Reports based on the Parameter Query Trick11:03
Calculations in Reports04:24
Sorting with Reports02:16
Adding an Order Month to Our Query05:36
Subtotals in Reports05:12
+3 more lectures
Advanced FORMS
7 lectures • 34:25
Advanced FORMS
7 lectures • 34:25
Add a Combo Box to Our Orders form08:09
Setting the Tab Order03:38
Using TAB Controls05:39
Continuous Forms 1 - Add a Calculated Field02:50
Continuous Forms 2 - a Shortcut for Creating04:25
+3 more lectures
Automating Things In Your Forms
3 lectures • 28:15
Automating Things In Your Forms
3 lectures • 28:15
The Hooks - Form and Report EVENT Properties12:26
Updating the Main Form Total09:00
Recalculating the Order Total06:49
Review of Automating Things in Your Forms4 questions
More Form Automation: BUTTONS and MACROS
6 lectures • 44:19
More Form Automation: BUTTONS and MACROS
6 lectures • 44:19
Create a Go To Customer Button08:25
Create a To Orders button in a Subform04:07
A New Order Button on the Customer Form09:09
Modify the Add Order Macro to Plug the Name and Address09:31
New Customer and Exit Buttons10:32
+2 more lectures
Creating a Multi Page Invoice
4 lectures • 26:41
Creating a Multi Page Invoice
4 lectures • 26:41
Create an Invoice Report from the Orders Subform08:14
Change Invoice Recordsource and More Formatting05:23
Create an Invoice Button on the Orders Form04:07
Test a Multi Page Invoice and Final Formatting08:57
Review of Creating a Multi Page Invoice5 questions
Final Thoughts
3 lectures • 20:57
Final Thoughts
3 lectures • 20:57
Access is Built for Networking06:42
THREE Best Practices in Table Design with PDF08:21
What's New in Access 201605:54
Conclusion
2 lectures • 03:05
Conclusion
2 lectures • 03:05
Conclusion: What Have We Learned?02:49
BONUS Lecture! Learn even MORE!00:16
Description
Have you always wanted to learn Microsoft Access but you just don't know where to start?
Or maybe you have started but you just don't know how to use some of the more advanced features.
Then our complete Microsoft Access 2016 Master Class: Beginner to Advanced is for You!
_________________________________________________________________________
Welcome To the “Microsoft Access 2016 Master Class: Beginner to Advanced.”
⇉ Join 800,000+ Students Who Have Enrolled in our Udemy Courses!
⇉ 10,000+ Five Star Reviews Show Students Who Enroll in our Courses get Results!
⇉ You Get Over 75 Lectures and 7+ hours of premium content
⇉ Watch the Promo Video to see how you can Get Started Today!
_________________________________________________________________________
What do you get with this course?
Hours of easy-to-watch video lessons
Downloadable Resources
Practical activities
Instructor support if you have any questions
Community of students ready to help
What will you learn in this “Microsoft Access 2016 Master Class: Beginner to Advanced.”
In short, you'll learn it all! Seriously, our goal is to make the most comprehensive Microsoft Access course out there - not filled with fluff, but filled with only the most actionable and latest tips and strategies. We'll be updating this course periodically to make sure we're covering any change with Microsoft Access.
You'll start by an overview of the course and learn how to get started with Microsoft Access.
You'll then learn three major data problems that Access completely resolves.
Once you understand how to resolves these three major data problems, you will learn about the parts of the Access screen, table and report objects, query objects and properties, form objects and advanced tables, advanced queries and reports, advanced forms and automating things in your forms, more form automations like buttons and macros, and how to create a multi page invoice.
By the end of our course you will:
Understand how Access is constructed and how to use the major objects within it.
Discover THREE Major Data Problems That Access Completely Resolves
Learn the parts of the Access screen
Learn table, report and query objects
Master PROPERTIES to make thousands of choices manageable
Learn the basics of form objects
Fully understand tables, queries, reports and forms
Use automation in your forms with buttons and Macros
Create a multi page invoice
And more...
Ready to get started?
Once you enroll, we recommend students install Microsoft Access on their computers to follow along.
_____
See What Current Students Are Saying About Our Course:
“It did take me a while to get thru this course due to other commitments, but I did find the course to be very informative as I'm a newbie to using Access and wanted to get up and running with as much knowledge as I could. Some sections were "over my head", but that is all part of learning something new. Thanks for taking the time to put this course together.”
-Todd Atkinson
"Great course to learn a new skill. And it go from zero to Hero. Now i need to apply this knowledge to create my own database. Thank you very much and wish you a lot of satisfied students like I am. :)"
-Tibor Molnar
"What makes this an amazing course. Easy to follow instructions. The audio, visuals and the transcripts were extremely helpful. Great response when asking a question. The course allows you to review the course or parts of thereof. This was a new experience (for a retired person), never took an online course. Just signed up for your VBA course. Thank you for making this a valuable and interesting course."
-Donna
_____
Who are your instructors?
We are Joe Parys and Bruce Myron, creatives who have taught over 800,000+ students around the world with our online courses, tutorials and other content. Bruce Myron is the lead instructor for this course, bringing his wealth of knowledge in working with Microsoft Access. Joe Parys is the Bestselling Online Instructor, Digital Marketing Expert and Leader in the eLearning industry. He is the CEO of the Joe Parys Academy serving more than 1,000,000+ students in more than 100+ co-authored courses from 190 countries all around the world.
Our goal is to show you the real world and practical ways to start using Microsoft Access with confidence today!
_________________________________________________________________________
With the right mindset, understanding, and application, you will instantly begin learning how to build databases with Microsoft Access.
When I learn something new I add it to the course - at no additional cost to you!
This is a course that will continue to add more and more to every aspect of your life.
What I can't do in this Course..
I can't guarantee your success – this course does take work on your part. But it can be done!
I am also not responsible for your actions. You are responsible for 100% of the decisions and actions you make while using this course.
_________________________________________________________________________
It's time to take action!
Our happiness guarantee
This course includes a money back guarantee, so there is no risk to try it out.
Sign up today, see if it's the right one for you.
Enroll now.
Sincerely,
Joe Parys and Bruce Myron.
Who this course is for:
- Anyone who is dissatisfied with how they are handling data now and know there must be a better way
- Anyone who has attempted to learn Access before without success
- Entrepreneurs, office workers, teachers and students wanting to work with databases
This course includes:
- 7 hours on-demand video
- 3 articles
- 5 downloadable resources
- Access on mobile and TV
- ∞Full lifetime access
- Certificate of completion
Instructors
Joe Parys
Bruce Myron
Joe Parys Support
Students also download
Explore related courses to expand your learning journey.
All Levels
22 hours
The Complete Python Bootcamp From Zero to Hero in Python
Learn Python like a Professional Start from the basics and go all the way to creating your own applications and games
Jose Portilla
What you'll learn:
- ✓You will learn how to leverage the power of Python to solve tasks.
- ✓You will build games and programs that use Python libraries.
- ✓You will be able to use Python for your own work problems or personal projects.
- +9 more skills
22 hours
156 lectures
Access on mobile and TV
Certificate
DevelopmentPython
All Levels
52 hours
100 Days of Code: The Complete Python Pro Bootcamp
Master Python by building 100 projects in 100 days. Learn data science, automation, build websites, games and apps!
Dr. Angela Yu, Developer and Lead Instructor
What you'll learn:
- ✓You will master the Python programming language by building 100 unique projects over 100 days.
- ✓You will learn automation, game, app and web development, data science and machine learning all using Python.
- ✓You will be able to program in Python professionally
- +6 more skills
56.5 hours
592 lectures
Access on mobile and TV
Certificate
DevelopmentPython