Microsoft Access Master Class: Beginner To Advanced

5/5 (3 ratings)
beginner
See all reviews

This course is designed for those interested in learning about how to use Microsoft Access effectively.

Microsoft Access Master Class: Beginner To Advanced

$199

buy now add to cart
Cancel
30 DAY
Money Back
Guarantee
  • Lifetime Access
  • Course Certificate
  • 24/7 Support

About This Coursebeginner

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

Course Sections

Bruce’s Intro And Three Data Problems Overview

Access Solves The SIZE And SPEED Problem

Access Solves The DATA SHARING Problem

Access Solves The ONE To MANY Problem

The Parts Of The Access Screen

Direct Download Of Database File

Working With The Navigation Pane, Menu, Ribbons And Objects

Creating Our First Table And Data Type PDF

Adding, Editing And Deleting Records

Primary Keys: What They Are And Why They Are Important

Adding Autonumbers, Primary Keys And Restructuring Tables

Basic Table Sorting And Filtering

What Do Reports Do?

Modifying The Report

Working With Controls, Report And Layout Views

Basic Queries

Query Criteria

Date Criteria And Between

Using OR In Criteria

Parameter Queries

Viewing Table Properties And Custom Formatting PDF

Field Validation And Other Field Properties

Query Properties

Report Properties

Creating A Form With The Wizard

Cleaning Up the Form – Working With Controls

More Form Cleanup – Moving Labels, Adding Rectangles, Font Color

Resize Header And Detail And Finish Form

Using The Lookup Wizard

Setup Lookups Without The Wizard

Advanced Sorting And Filtering

Working With Related TABLES

Using TOP Queries

Using TOTAL Queries

ACTION Queries – UPDATE

ACTION Queries – APPEND

Multi Table And MAKE TABLE ACTION Queries

ACTION Queries – DELETE

Calculations In Queries And Formatting Results

A Parameter Query Trick

Reports Based On The Parameter Query Trick

Calculations In Reports

Sorting With Reports

Adding An Order Month To Our Query

Subtotals In Reports

Label The Subtotals And Report Total

Conditional Formatting

Add A Combo Box To Our Orders Form

Setting The Tab Order

Using TAB Controls

Continuous Forms 1 – Add A Calculated Field

Continuous Forms 2 – A Shortcut For Creating

Add A Subform

Change A Textbox Into A ComboBox

The Hooks – Form And Report EVENT Properties

Updating The Main Form Total

Recalculating The Order Total

Create A Go To Customer Button

Create A To Orders button In A Subform

A New Order Button On The Customer Form

Modify The Add Order Macro To Plug The Name And Address

New Customer And Exit Buttons

A Special Startup Macro

Create An Invoice Report From The Orders Subform

Change Invoice Recordsource And More Formatting

Create An Invoice Button On The Orders Form

Test A Multi Page Invoice And Final Formatting

Access Is Built For Networking

THREE Best Practices In Table Design With PDF

What’s New In Access 2016

Reviews

5
3 student reviews
  1. Jerrye says:

    It is great
    It was so easy to learn

  2. Natalie Tremblay says:

    Excellent teacher and great course!
    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!

  3. John Fulk says:


    This was a great introduction for me to Access.

About The Instructor

Bruce

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 systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do. I have also spent time as a full-time trainer providing group classes on the Microsoft Office programs. In my opinion, the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible. Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed. My goal is to show my students how to create systems that business will value and that will create long-term income.