Introduction: Welcome To The Complete Microsoft Access 2016 Master Class Course!
  • Introduction & Course Benefits: How To Get Started With Microsoft Access 2016!
  • Course Overview & Layout: How To Use This Course To Gain The Maximum Experience!
THREE Major Data Problems That Access Completely Resolves
  • A Quick Note BEFORE Starting Section 2
  • 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
Learning the Parts of the Access Screen
  • Important NOTE on DOWNLOADABLE RESOURCES
  • The Parts of the Access Screen
  • Working with the Navigation Pane, Menu, Ribbons and Objects
  • The Parts of the Access Screen
TABLE Objects - the Basics
  • 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
  • Review of the TABLE Object
REPORT Objects - the Basics
  • What do reports do?
  • Modifying the Report
  • Working with Controls, Report and Layout Views
  • Review of the REPORT Objects
QUERY Objects - the Basics
  • Basic Queries
  • Query Criteria
  • Date Criteria and Between
  • Using OR in Criteria
  • Parameter Queries
  • Review of Basic Queries
PROPERTIES: Making Thousands of Choices Manageable
  • Viewing Table Properties and Custom Formatting PDF
  • Field Validation and Other Field Properties
  • Query Properties
  • Report Properties
  • Review of Properties
FORM Objects - the Basics
  • 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
  • Review of Basic Forms
Advanced TABLES
  • Using the Lookup Wizard
  • Setup Lookups Without the Wizard
  • Advanced Sorting and Filtering
  • Working with Related TABLES
  • Review of Advanced Tables
Advanced QUERIES
  • 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
  • Review of Advanced Queries
Advanced REPORTS
  • 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
  • Review of Advanced Reports
Advanced FORMS
  • 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
  • Review of Advanced Forms
Automating Things In Your Forms
  • The Hooks - Form and Report EVENT Properties
  • Updating the Main Form Total
  • Recalculating the Order Total
  • Review of Automating Things in Your Forms
More Form Automation: BUTTONS and MACROS
  • 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
  • Review of Buttons and Macros
Creating a Multi Page Invoice
  • 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
  • Review of Creating a Multi Page Invoice
Final Thoughts
  • Access is Built for Networking