Introduction - Course Layout and Objectives
  • Course Introduction
  • Course Overview by Section
  • Important NOTE on DOWNLOADABLE RESOURCES
Why You Need Access
  • Comparing the Access and Excel Screens
  • Why You Need Access
  • Where Do We Go From Here?
The TABLE Object
  • Intro to Tables and Tabbed vs Overlap View
  • Editing, Adding and Deleting Records
  • Sorting a Table
  • Basic Filters
  • Advanced Filters
  • Using Find and Replace with Tables
  • Create a Table and add a Primary Key and Fields
  • Create Table 2 - Add the Rest of the Fields to the Table
  • Create Table 3 - Why Are There So Many Numeric Field Sizes?
  • List of Reserved Words
  • Table Properties 1 - Formats and Input Masks
  • Table Properties 2 - Defaults and Validation Rules
  • Table Properties 3 - Add Lookups to a Table
  • Modify Table Design - Add, Delete and Move Fields
The REPORT Object
  • Introduction and Create a Report
  • Using the Report Wizard
  • What Are Controls?
  • Report View and Layout View
  • Modify the Report Design and Selecting Controls
  • Entering Formulas into Text Boxes
  • Sorting and Subtotals in Reports
  • Conditional Formatting
  • The Properties Box
  • Using the Properties Box
  • Conclusion and Why We Need Queries
The QUERY Object - SELECT Queries
  • Overview of Select Queries Database
  • Intro to Select Queries
  • Sorting in Select Queries
  • Using Criteria in Queries - And vs OR
  • Using Criteria in Queries - Wildcards
  • List of Query Wildcard Characters
  • Using Criteria in Queries - Formulas in Criteria
  • Calculations in Select Queries
  • Multiple Tables in Queries
  • Parameters in queries
  • A Parameter Query Trick
Reports Revisited
  • Review the Report Source Table Structure
  • Using a Select Query as a Report Source
  • Setting up Date Parameters
  • Final Touch - a Title with Dates
Unique Value, TOP and Total Queries
  • Unique Value Queries - Part 1
  • Unique Value Queries - Part 2
  • TOP queries
  • Total Queries - Part 1
  • Total Queries - Part 2
ACTION Queries
  • Intro to Action Queries with a Make Table Query
  • Append Query
  • Delete Query
  • Update Qry Part 1 - Increase Prices
  • Update Query 2 - Add an Order Total Field
  • A Quick MACRO to Automate Updating the Order Totals
Migrating from Excel to Access 1: Get the Data Into Access
  • Import Problems 1 - Heading not removed
  • Import Problems 2 - Common Import Errors
  • A Clean Import - but is it?
Migrating from Excel to Access 2: Design the Correct Structure
  • Combine data in Excel before bringing into Access
  • Planning Your Database - 3 Best Practices - NUMBER 1
  • Planning Your Database - 3 Best Practices - NUMBER 2
  • Planning Your Database - 3 Best Practices - NUMBER 3
  • Three Best Practices in Designing Table Structures
  • How to Print Your Table Structures
  • How to Use the Relationships screen
  • Why I Don't Use the Relationships screen
  • Why You DON'T want to Use Analyze Table!
Migrating from Excel to Access 3: Building the New Tables
  • Using Queries to Create the Product Table
  • Create the Customer Cross Reference Table
  • Find the Potential Problem Customer Records
  • Manually Decide on How to Handle Each Duplicate
  • Create the Customer Table Structure and Starting Number
  • Populate the Customer Table and Create the Customer ID's
  • Plug the New Customer IDs Into the XLData Import Table
  • Create the Order Products Table
  • Create the Orders Table Structure
  • Create a Query to Append Orders from XLData
The FORMS Object 1 - Create a Customer Form and an Orders Subform
  • Overview of the Five Forms Sections
  • Overview of the Forms1 Database Tables
  • How are forms different from reports?
  • Create the Customer Form
  • More on the Customer Form: Aligning Controls
  • More on the Customer Form: Stacking Controls
  • Finish the Customer Form: Tab Order and Input Masks
  • Create the OrderList Form With the Form Wizard
  • Modify the OrderList Form Layout