Learn the basics of Access, increase productivity, and acquire beginner to advanced skills in this Microsoft Access course.
Read more.Instructor
Hello, my name is Bruce. I am a self-employed Access programmer and general computer consultant to small and medium-sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business. "Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce I live in Portland, Oregon and have many long-term relationships with local businesses. Many of the sy
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Programmers
- Microsoft users
- Data analysts
What you’ll learn:Â
- Understand the structure of the database file and its advantages
- Become comfortable with how the menus and ribbons work
- Learn how you can save all your data in one place
- Learn how to extract only the information you want
- See how to relate tables together and resolve the “1 to Many” problem
- Discover how having separate report formats reduces report prep time
- Learn how to easily create subtotals and do calculations
- See how you can link data back to Excel sheets for distribution
- View demonstrations of how Macros can be used to automate tasks
- See examples of how the VBA Programming Language can be used
- Learn how Access can work with Other Microsoft Office programs
Requirements:Â
- No prior knowledge is required to take this Microsoft Access course
Software version used in the course:
- Microsoft Access 2016
Every one of us, whether we know it or not, are surrounded by data. Some of it we keep track of on paper or in spreadsheets. Some of it is really important, like tasks that are part of our daily work. BUT, unfortunately, very few of us use the one tool that was built to handle all of our data needs – the Microsoft Access database.
Should you take the time to take this Microsoft Access Masterclass?
Many people do not use the Microsoft Access database program for 2 reasons:
- They think it is too complex
- They do not realize how incredibly powerful it is.
This course is dedicated to resolving the complexity question by demonstrating the basics of HOW Access is constructed and why the structure makes sense. Most courses just bury students in details, never starting with an overview and never showing students how the different parts can be used to increase productivity. By the time you have finished the first section of the course, you will understand WHY Access is built the way it is and feel comfortable moving around in the program.
Once you understand the basic structure, the course will show you many practical demonstrations of what Access can be used for. By the end of the course, you will have a very good idea EXACTLY how you could use Access to increase your productivity.
Learn about Access Objects and how they work together. Learn how the screen is organized and become very comfortable with moving around inside the various parts of the program. Understand how Access makes dealing with many settings and choices as easy as possible.
Build a Strong Foundation in Microsoft Access!
You will find that people who know how to use the incredible power of Access are in high demand in the marketplace. The familiarity with Access that you gain in this course will give you a solid foundation in creating databases that will make your life easier and be in demand by others!
There is a HUGE need in the marketplace for people who know how to use Access. This is your opportunity to break away from the pack of people who struggle to get their work done using only Excel. Stop being a slave to your spreadsheets and start learning how to create effective Access databases and easily automate tasks! This could be your shortest path to increasing your income!
Become a Microsoft Access expert, visit my profile to learn more!
Our Promise to You
By the end of this course, you will have a clear understanding of how to use Microsoft Access effectively.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn how to effectively use Microsoft Access!
Course Curriculum
| Section 1 - THREE Major Data Problems That Access Completely Resolves | |||
| Bruce’s Intro And Three Data Problems Overview | 00:00:00 | ||
| Access Solves The SIZE And SPEED Problem | 00:00:00 | ||
| Access Solves The DATA SHARING Problem | 00:00:00 | ||
| Access Solves The ONE To MANY Problem | 00:00:00 | ||
| Section 2 - Learning The Parts Of The Access Screen | |||
| The Parts Of The Access Screen | 00:00:00 | ||
| Direct Download Of Database File | 00:00:00 | ||
| Working With The Navigation Pane, Menu, Ribbons And Objects | 00:00:00 | ||
| Section 3 - TABLE Objects - The Basics | |||
| Creating Our First Table And Data Type PDF | 00:00:00 | ||
| Adding, Editing And Deleting Records | 00:00:00 | ||
| Primary Keys: What They Are And Why They Are Important | 00:00:00 | ||
| Adding Autonumbers, Primary Keys And Restructuring Tables | 00:00:00 | ||
| Basic Table Sorting And Filtering | 00:00:00 | ||
| Section 4 - REPORT Objects - The Basics | |||
| What Do Reports Do? | 00:00:00 | ||
| Modifying The Report | 00:00:00 | ||
| Working With Controls, Report And Layout Views | 00:00:00 | ||
| Section 5 - QUERY Objects: The Basics | |||
| Basic Queries | 00:00:00 | ||
| Query Criteria | 00:00:00 | ||
| Date Criteria And Between | 00:00:00 | ||
| Using OR In Criteria | 00:00:00 | ||
| Parameter Queries | 00:00:00 | ||
| Section 6 - PROPERTIES: Making Thousands Of Choices Manageable | |||
| Viewing Table Properties And Custom Formatting PDF | 00:00:00 | ||
| Field Validation And Other Field Properties | 00:00:00 | ||
| Query Properties | 00:00:00 | ||
| Report Properties | 00:00:00 | ||
| Section 7 - FORM Objects - The Basics | |||
| Creating A Form With The Wizard | 00:00:00 | ||
| Cleaning Up the Form – Working With Controls | 00:00:00 | ||
| More Form Cleanup – Moving Labels, Adding Rectangles, Font Color | 00:00:00 | ||
| Resize Header And Detail And Finish Form | 00:00:00 | ||
| Section 8 - Advanced TABLES | |||
| Using The Lookup Wizard | 00:00:00 | ||
| Setup Lookups Without The Wizard | 00:00:00 | ||
| Advanced Sorting And Filtering | 00:00:00 | ||
| Working With Related TABLES | 00:00:00 | ||
| Section 9 - Advanced QUERIES | |||
| Using TOP Queries | 00:00:00 | ||
| Using TOTAL Queries | 00:00:00 | ||
| ACTION Queries – UPDATE | 00:00:00 | ||
| ACTION Queries – APPEND | 00:00:00 | ||
| Multi Table And MAKE TABLE ACTION Queries | 00:00:00 | ||
| ACTION Queries – DELETE | 00:00:00 | ||
| Calculations In Queries And Formatting Results | 00:00:00 | ||
| A Parameter Query Trick | 00:00:00 | ||
| Section 10 - Advanced REPORTS | |||
| Reports Based On The Parameter Query Trick | 00:00:00 | ||
| Calculations In Reports | 00:00:00 | ||
| Sorting With Reports | 00:00:00 | ||
| Adding An Order Month To Our Query | 00:00:00 | ||
| Subtotals In Reports | 00:00:00 | ||
| Label The Subtotals And Report Total | 00:00:00 | ||
| Conditional Formatting | 00:00:00 | ||
| Section 11 - Advanced FORMS | |||
| Add A Combo Box To Our Orders Form | 00:00:00 | ||
| Setting The Tab Order | 00:00:00 | ||
| Using TAB Controls | 00:00:00 | ||
| Continuous Forms 1 – Add A Calculated Field | 00:00:00 | ||
| Continuous Forms 2 – A Shortcut For Creating | 00:00:00 | ||
| Add A Subform | 00:00:00 | ||
| Change A Textbox Into A ComboBox | 00:00:00 | ||
| Section 12 - Automating Things In Your Forms | |||
| The Hooks – Form And Report EVENT Properties | 00:00:00 | ||
| Updating The Main Form Total | 00:00:00 | ||
| Recalculating The Order Total | 00:00:00 | ||
| Section 13 - More Form Automation: BUTTONS And MACROS | |||
| Create A Go To Customer Button | 00:00:00 | ||
| Create A To Orders button In A Subform | 00:00:00 | ||
| A New Order Button On The Customer Form | 00:00:00 | ||
| Modify The Add Order Macro To Plug The Name And Address | 00:00:00 | ||
| New Customer And Exit Buttons | 00:00:00 | ||
| A Special Startup Macro | 00:00:00 | ||
| Section 14 - Creating A Multi Page Invoice | |||
| Create An Invoice Report From The Orders Subform | 00:00:00 | ||
| Change Invoice Recordsource And More Formatting | 00:00:00 | ||
| Create An Invoice Button On The Orders Form | 00:00:00 | ||
| Test A Multi Page Invoice And Final Formatting | 00:00:00 | ||
| Section 15 - Final Thoughts | |||
| Access Is Built For Networking | 00:00:00 | ||
| THREE Best Practices In Table Design With PDF | 00:00:00 | ||
| What’s New In Access 2016 | 00:00:00 | ||
Course Review
4.8
13 RatingsRelated Courses
Are you interested in higher education?
Great Refresher after years of not using Access.
Nice bite sized modules that start from the basic level explaining the use of every item used through to more complex behind the scenes Macro and VBA usage. Note: The VBA is very basic but a nice to see)
Very good course. I learnt a lot of it.
Brilliant
A really easy to understand course for Access novices.
Very informative
Learned lots of great things.
Smooth and informative.
Bruce has a nice, comfortable style that makes the course easy to follow, the subject and lessons comprehensible, and the program approachable. I truly appreciated his technique of shorter lessons within larger subject categories, as it allowed me to feel more able to fit in lessons around my day without having to commit massive chunks of time. I feel it was well worth it, and I look forward to following up with some of his other lessons.