Basic Access Concepts

- Macros and a First Look and the DOCMD Object
- Scheduling Macros to Run at a Certain Time
- Link to External Data Sources
- Scheduling a Compact and Repair
 

Improving your Access Reports

- Add Line Numbers and Shading to Reports
- Sorting and Grouping Access Reports
- Create An Alpha Roster with Two Columns
- Create Form Letters With & Without Mail Merge
- Use Existing PDF Forms in Access Reports
  Get this video  Create a Dynamic List of All Your Reports
  Get this video  Create a Top Nth By Group Report 
  Get this video  Add Dynamic Icons to Reports 
  Get this video Apply a Filter to a Report using a Form Entry 
 

Advanced Query Tips

- AND vs OR in an Access Query Grid
- Delete Records From a Table if They Exist in Another Table
- Using the IIF Function
- Using the Left and Right Functions
- Using "Top Values" Criteria
- A Clever "Find Duplicates" Trick
- About the NZ() Function
- Clever ways to use the Date() Function
- Create a Cross Tab Query without the Wizard
- Manipulating Data with the Query Builder
- Smart Parameters
- Using the Instr() function to parse strings in a query
  Get this video Parameter Input that Accepts Multiple Parameters
  Get this video Create a Running Sum in your Query
  Get this video Get Records Above or Below the Dataset Average
  Get this video Get Top Values per Group
  Get this video Get Details and Totals in one Query
  Get this video Create a Percent of Total Column in your Query
  Get this video Easy way to Query only Workdays
 

User Form Basics

- Setting Startup Options
- Aligning and Positioning Controls
- Message Boxes and Input Boxes
- Combo Boxes 1 (create basic combo box)
- Combo Boxes 2 (linking two combo boxes)
- Combo Boxes 3 (multiple column combo boxes)
- Tab Control Basics
- Using the Calendar Control
  Get this video Subforms Part 1 - Using a Basic Subform
  Get this video Subforms Part 2 - Referencing a Subform
  Get this video Using Access Slider Controls 
  Get this video Using the Web Browser Control  
  Get this video Using the Option Group Control
  Get this video Enabling and Disabling Controls on a Form
 

User Form Tricks

- Creating a Splash Screen
- Making an Image Look and Act Like a Button
- Poor Man's Progress Bar
- Build a Custom Filter in Your Form
- Build a Basic Log In Form
  Creating a Basic Search Form-
  NEW!!   Allow Users to Zoom into Comment Fields
  Get this video Make your Form Auto Expand for Hidden Controls
  Get this video Add Data from Unbound Text Boxes to a Table
  Get this video Alternatives to Typing your Parameter Dates
  Get this video Prevent a User from Closing your Application
  Get this video Using a Recordset Clone for Quick Searches
  Get this video Create Web Page Effects with the 'On Mouse Move' Event
  Get this video Adding and Removing Items Between Two Listboxes
  Get this video Using Conditional Formatting to Highlight records
  Get this video Add E-Mail functionality to applications with SendObject Method
  Get this video Quick and Easy Dynamic Sorting Functionality
  Get this video Create the Illusion of Colored Tabs
  Get this video Add Animation and Sound to Splash Screens d
  Get this video How to Compact Database Every 5th closing d 
  Get this video Dynamically Expand a Combo Box Horizontally
  Get this video Creating a Custom Help File System for your Application
  Get this video Show a Report on a Form (Using the Snapshot Viewer ActiveX Control)
 

Getting Started with VBA

- Quick overview of VBA
- Understanding Reference Libraries
  Declaring Variables
- Using If Statements
- Using Select Case Statements
- The Basics of the Do Loops
- Using For Next Loops
- Looping with For Each Statements
 

Snap in Utilities

DataPig Access Explosion  - See Tutorial
DataPig Instant TreeView  - See Tutorial