Access Training Tutorials in Flash format

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 an 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
- Create a Dynamic List of All Your Reports
  Create a Top Nth By Group Report
  Add Dynamic Icons to Reports
  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
- Parameter Input that Accepts Multiple Parameters
- Create a Running Sum in your Query
- Get Records Above or Below the Dataset Average
- Get Top Values per Group
- Get Details and Totals in one Query
  Create a Percent of Total Column in your Query
  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
- Subforms Part 1 – Using a Basic Subform
- Subforms Part 2 – Referencing a Subform
  Using Access Slider Controls    Download Sample File
  Using the Web Browser Control   Download Sample File
  Using the Option Group Control
  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
- Make a Form Auto Expand for Hidden Controls
- Creating a Basic Search Form
- Add Data from Unbound Text Boxes to a Table
- Alternatives to Typing your Parameter Dates
- Prevent a User from Closing your Application
- Using a Recordset Clone for Quick Searches
- Create Web Page Effects with the ‘On Mouse Move’ Event
- Adding and Removing Items Between Two Listboxes
- Using Conditional Formatting to Highlight records
- Add E-Mail functionality to applications with SendObject Method
- Quick and Easy Dynamic Sorting Functionality
  Create the Illusion of Colored Tabs
  Add Animation and Sound to Splash Screens d Download Sample File
  How to Compact Database Every 5th closing d  Download Sample File
  Dynamically Expand a Combo Box Horizontally
  Creating a Custom Help File System for your Application
  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