About This Course

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 learn Microsoft Access?

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!

  • 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.

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!

Our Promise to You
By the end of this course, you will have a clear understanding of how to use Microsoft Access effectively.

30 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 Reviews

5

5
6 ratings
  1. Excellent teacher and great course!

    5

    It is clear that the instructor is very knowledgeable in not only the software, but in how to teach as well. I had struggled for years to manage my data sets in excel and knew that Access was the right program for my needs, but consistently failed to bring anything together. Bruce’s videos are excellent and walk you through the techniques and the reasons behind why he recommends them. I will retain this knowledge for years to come. I took a gamble on taking this course (I have been burned by other skillsuccess “teachers” before) and I am really glad I did! This gave me all the tools I need to build my own multi-level BOM database without screwing it up!

  2. 5

    This was a great introduction for me to Access.

Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel