Microsoft Access courseware and training manuals

Our basic Access courseware shows how to use tables, queries, forms and reports in Access, while our VBA courseware shows how to create modules and write VBA code within Access:

You can see details of how to license our Microsoft Access courseware (including volume requirements) here.


Access courseware

Here is a list of all of our Access manual chapters (you can download the ones marked):

Chapter Sections Subsections
Access Basics (12 pages) Introduction to Access Access Objects
Entering and Leaving Access Entering Access ; The Getting Started Page
Doing Things in Access Using the Access Ribbon ; Using Keyboard Short-Cuts ; Using Short-Cut Menus
Undoing and Redoing Commands Undoing Commands ; Redoing Commands
Opening and Closing Databases Opening an Existing Database ; Closing a Database ; A Note about Security
Creating a New Database Starting a Blank Database ; Using a Template
Database Files Access 2010 Files ; Working with Older Access Databases
Working with Databases The Navigation Pane ; Viewing Database Objects ; Tabs and Windows
Using Help Searching for Help ; Using Screentips
Office 2010 Interface (8 pages) Interacting With Office 2010 The File Menu ; The Ribbon ; The Mini Toolbar ; The Quick Access Toolbar
Using the Ribbon Tabs, Groups and Commands ; Using Quick Keys ; Seeing More Options
Customising the Ribbon
Getting Help on the Ribbon
Designing a Database (4 pages) The Stages of Database Design Stage 1 – Deciding What to Include ; Stage 2 – Dividing Data into Tables ; Stage 3 – Choosing a Primary Key ; Stage 4 – Drawing your Relationships ; The End Result
Many to Many Relationships
Table Design (18 pages) Creating New Tables Creating Tables in Datasheet View ; Creating Tables in Design View ; Creating Tables using a Template
Field Data Types Text Fields ; Memo Fields ; Number Fields ; Dates and Times ; Currency ; AutoNumber Fields ; Yes/No Fields ; OLE Object Fields ; Hyperlink Fields ; Attachment Fields ; Calculated Fields
Field Properties Properties for Formatting ; Properties for Validation ; Other Useful Properties
Setting a Primary Key Multiple Primary Keys
Lookup Fields Creating a Simple Lookup Field ; Lookup Fields Based on Tables ; Multiple Value Lookup Fields ; Lookup Fields Based on Queries
Datasheets (8 pages)

Download this chapter
Moving Around a Table
Working with Records Creating New Records ; Selecting Records ; Abandoning a Record ; Deleting Records ; Copying Records
Sorting Records Removing Sorting
Filtering Records Applying Simple Filters ; Applying Complex Filters ; Removing Filters
Formatting Datasheets Column Widths and Row Heights ; Moving Columns ; Hiding and Unhiding Columns ; Formatting Text ; Formatting Numbers ; Rich Text Formatting
Subdatasheets
Relationships (6 pages) Pre-Conditions for Creating Relationships
Creating Relationships
Editing and Deleting Relationships Selecting Relationships ; Editing a Relationship ; Deleting a Relationship
Referential Integrity Cascade Deletion ; Cascade Updating
Printing Relationships
Importing and Exporting Data (4 pages) Importing Data The Data Source ; Importing Data ; Linked Tables
Exporting Data Reusing Saved Import/Export Steps
Basic Queries (12 pages) Creating a Query
Running a Query Structured Query Language (SQL)
Customising the Query Window
Editing a Query Adding Tables to a Query ; Deleting Tables from a Query ; Adding Single Fields to a Query ; Adding Multiple Fields to a Query ; Deleting Fields from a Query ; The Asterisk (*) – Including All Fields ; Changing the Order of Fields ; Sorting by Fields ; Omitting Fields ; The Best Way to Write Queries ; Saving Queries
Setting Criteria
Criteria Examples Exact Matches ; Pattern Matches ; Comparisons ; Combining Comparisons ; A Couple of Extra Ideas for Searches
Parameter Queries (4 pages) Creating Basic Parameter Queries
Using More Complex Criteria Using Multiple Criteria ; Using Comparison Symbols ; Using Wildcard Characters
Limitations of Parameter Queries
Group and Total Queries (4 pages) Groups and Totals Creating a Group and Total Query ; Changing Grouping Levels
Using Criteria in Group and Total Queries Setting Criteria Using the Where Clause
Totals in Datasheets
Expression Queries (6 pages) Expression Queries Creating an Expression Query
Using Expression Builder Zooming In
Functions Typing in Functions ; Using Functions in the Expression Builder ; The IIF Function ; The NZ Function
Text Expressions Concatenating Text ; Text Functions
Date and Time Expressions Simple Date Expressions ; Date and Time Functions
Joins (6 pages) Introduction to Joins
Creating and Deleting Joins Creating a Join ; Deleting Joins
Types of Join Inner Joins ; Outer Joins ; Using Outer Joins to Find Unmatched Records
Action Queries (6 pages) Introduction
Make Table Queries
Append Queries
Update Queries
Delete Queries The FROM and WHERE Options
Crosstab Queries (4 pages) How Crosstab Queries Work
Creating a Crosstab Query Displaying Row “Totals”
Summarising By Month, Quarter or Year Displaying the Month Name ; Changing the Column Order
Basic Forms (6 pages) What is a Form?
Creating New Forms
Views of Forms
Using Forms Moving Between Records ; Selecting Records in a Form ; Sorting, Filtering and Finding
Split Forms
Finding and filtering (6 pages) How Filters Work Cumulative Filters
Applying Filters Common Filters ; Filtering by Selection ; Filtering by Form ; Advanced Filters
Removing Filters Clearing Filters ; Toggling Filters
Finding Records
Formatting Forms and Reports (16 pages) Introduction to Formatting Which View Should You Use?
Selecting Controls Selecting a Single Control ; Selecting Every Control on a Form ; Selecting Multiple Controls ; Using the Ruler to Select Controls ; Selecting a Section ; Selecting a Form
Control Layouts Types of Control Layout ; Resizing Controls in a Layout ; Moving Controls in a Layout ; Removing Controls from a Layout ; Adding Controls to a Layout
Manipulating Controls Moving Controls ; Resizing Controls ; Deleting Controls ; Sizing Controls Automatically ; Distributing Controls ; Aligning Controls
Properties
Formatting Controls Basic Font Formatting ; Formatting Lines and Borders ; Gridlines ; Formatting Numbers and Dates ; Themes ; Form Logos
Conditional Formatting Deleting Conditional Formats
Setting Form Defaults Saving Default Control Formats ; Saving Default Form Templates
Basic Reports (12 pages) What are Reports?
Views of Reports
Creating Reports Creating Quick Reports ; Using the Report Wizard
Previewing a Report Moving Between Pages ; Zooming ; Viewing Different Numbers of Pages ; Page Size and Orientation ; Margins
Printing Reports
Report Sections Changing Section Heights ; Changing the Report Width ; Why Can’t I Make My Report Narrower?
Sorting and Grouping Adding Totals to a Group ; Avoiding Splitting a Group across Pages ; Removing a Group
Adding Controls (8 pages) Introduction Locking a Control to the Mouse
Lines and Rectangles
Labels and Text Boxes Adding Labels ; Adding Bound Text Boxes ; Adding Unbound Text Boxes
Command Buttons
Check Boxes and Toggle Buttons
Option Groups Creating an Option Group
Combo/List Boxes
Multiple Forms (8 pages) What are Multiple Forms?
Combo Boxes Based on Other Tables Setting Combo Box Format Properties ; Setting Combo Box Data Properties ; Using Lookup Fields
Subforms Editing Subforms ; Editing a Subform in a Separate Window ; Creating a Subform using the Wizard ; Adding a Subform to a Main Form ; Adding Totals to a Subform
Showing Parent Fields on Child Forms
Two Ways to Program in Access (4 pages) Macros vs. VBA
Reasons to Learn Macros
Reasons to Learn VBA Converting Macros to Visual Basic
Basic Macros (14 pages) What are Macros?
Creating Simple Macros
Working with Macro Actions Adding Actions to a Macro ; Deleting Actions ; Moving Actions ; Collapsing and Expanding Actions ; Grouping Actions
Running Macros Running Macros from the Navigation Pane ; Attaching a Macro to a Form Button ; Running a Macro Step-by-Step ; Running One Macro from Another Macro
Adding Program Flow Elements to Macros Comments ; Creating Submacros ; Using Submacros ; Error Handling ; If Statements
Embedded Macros Creating an Embedded Macro
Data Macros Creating a Data Macro ; The Data Events ; Example of a Data Macro
Using the VB Editor (8 pages) Using the Access Window to Write Code
The VBA Code Editor Switching to/from the VB Editor ; Project Explorer ; The Properties Window ; Docking Windows
Modules Inserting a Module ; Renaming Modules ; Deleting Modules
Procedures Creating a Procedure ; Moving between Procedures ; Why Some Words Appear in Blue
Finding and Replacing Text Finding Text ; Replacing Text
Getting Help Using Help ; Getting Help using Search Engines ; AutoCompletion of Commands
Good Coding Practice (4 pages) Comments Commenting Out Multiple Lines
Layout of Code Splitting Lines of Code using Continuation Characters ; Indenting Lines
Modular Coding Advantages of Modular Coding
Using Different Modules
Checking and Running Macros (4 pages) Three Stages to Run a Macro Examples of the Different Stages of Error
Checking your Macros before Running Them On-Line Syntax Checking ; Turning Off Syntax Checking ; Compiling your Code
Running and Stopping Procedures Running the Currently Selected Procedure ; Stopping a Procedure which is Running
Talking to your users (6 pages) Basic Message Boxes Syntax of the MsgBox Command ; Named Arguments ; Building Up Messages ; Multiple Line Messages
Customising your Message Box Button Combinations Available ; Symbols Available
Asking Questions with Message Boxes The Possible Buttons ; The Different Button Values Possible
Asking for Information Syntax of the InputBox Function ; Example of an InputBox Function
Displaying Messages in the Status Bar
Using VBA - Front Menus (6 pages) Our Menu System
Creating a Splash Form Step One: Ensuring that Forms don’t Fill the Screen ; Step Two: Designing your Form ; Step Three: Ensuring your Form Opens Non-Maximized ; Step Four: Getting your Splash Form to Disappear ; Step Five: Getting your Splash Form to Autostart ; Other Startup Options
Creating a Menu Form
Using VBA - Validating Forms (4 pages) Overview of Form Validation Form Validation Methods Summarised
Setting Field Validation Rules
Checking Each Control before you Leave it
Checking a Record before you Save It
Using VBA - Criteria Forms (4 pages) What is a Criteria Form?
Creating the Criteria Form Creating the Form ; Writing the Code for the Show Button
Creating the Underlying Query
Creating the Report Redisplaying the Criteria Form when you Close the Report
Using VBA - Navigation Buttons (4 pages) Wizards versus Creating Your Own
Creating your Navigation Buttons Step One: Adding Form Buttons ; Step Two: Creating the Navigation Buttons Code ; Step Three: Attaching your Function to your Button

Access Visual Basic courseware

Here is a list of all of our Access Visual Basic manual chapters (you can download the ones marked):

Chapter Sections Subsections
Two Ways to Program in Access (2 pages) Old-Fashioned Macros Saving Macros as Visual Basic
Three Reasons to Avoid Macros
Using the VB Editor (8 pages) Using the Access Window to Write Code
The VBA Code Editor Switching to/from the VB Editor ; Project Explorer ; The Properties Window ; Docking Windows
Modules Inserting a Module ; Renaming Modules ; Deleting Modules
Procedures Creating a Procedure ; Moving between Procedures ; Why Some Words Appear in Blue
Finding and Replacing Text Finding Text ; Replacing Text
Getting Help Using Help ; Getting Help using Search Engines ; AutoCompletion of Commands
Good Coding Practice (4 pages) Comments Commenting Out Multiple Lines
Layout of Code Splitting Lines of Code using Continuation Characters ; Indenting Lines
Modular Coding Advantages of Modular Coding
Using Different Modules
Checking and Running Macros (4 pages)

Download this chapter
Three Stages to Run a Macro Examples of the Different Stages of Error
Checking your Macros before Running Them On-Line Syntax Checking ; Turning Off Syntax Checking ; Compiling your Code
Running and Stopping Procedures Running the Currently Selected Procedure ; Stopping a Procedure which is Running
Talking to your users (6 pages) Basic Message Boxes Syntax of the MsgBox Command ; Named Arguments ; Building Up Messages ; Multiple Line Messages
Customising your Message Box Button Combinations Available ; Symbols Available
Asking Questions with Message Boxes The Possible Buttons ; The Different Button Values Possible
Asking for Information Syntax of the InputBox Function ; Example of an InputBox Function
Displaying Messages in the Status Bar
Variables (6 pages) The Various Data Types Available What Happens if you Use the Wrong Type
Using Variables Using the DIM Statement to Declare Variables ; What Happens when you Misspell Variables
Forcing Variable Declarations Forcing Variable Declaration for a Single Module ; Forcing Variable Declaration for All Modules
Scope of Variables
Constants
Referring to Variables or Constants in Queries
Arrays (4 pages) Simple Arrays Starting Arrays at 1, not 0
Changing the Dimension of Arrays
Multi-dimensional Arrays Looping over Multi-Dimensional Arrays
Two Practical Uses of Arrays Using SPLIT to Split a String into Words ; Using GetRows to Return an Array of Records and Fields
Writing functions (4 pages) What is a Function?
Creating Functions An Example of a Function ; Testing Functions in the Immediate Window
Using a Function in a Query Step One: Creating the Function ; Step Two: Test the Function ; Step Three: Incorporate the Function within your Query
Embedded procedures (6 pages) What are Embedded Procedures?
Attaching Code to Events Step One: Selecting the Form, Report or Control to Attach Code to ; Step Two: Choosing the Event ; Step Three: Writing the Code ; Alternative Method: Using the Code Window to Assign Code
Using Me Using Me to Avoid Hard-Coding a Form or Report Name ; Using Me to Get Autocompletion for Control Names
Major Events Useful Form Events ; Useful Control Events
Renaming Controls and Procedures
The VBA Rabbit Hole (8 pages) Collections and Objects
Referring to Form, Report and Control Objects Referring to Forms or Reports ; Referring to Controls
Properties and Methods Properties ; Changing Properties in Visual Basic ; Methods ; Using Autocompletion to Distinguish between Methods and Properties
The DoCmd Object
The Access Object Models The Full Access Object Model ; The Object Browser
Object Variables Declaring Variables – the SET Command ; Converting Control Types
Loops and Logic (6 pages) Simple Conditions Using IF Simple Conditions ; Testing Alternatives (ELSE)
Multiple Conditions Multiple Conditions Using Nested IF Statements ; Multiple Conditions Using the SELECT statement
Normal Looping Looping Until a Condition is True (DO UNTIL … LOOP) ; Looping While a Condition is True (DO WHILE … LOOP) ; Looping a Set Number of Times (FOR … NEXT) ; Exiting Prematurely from Loops
Looping Over Collections Some Examples of Looping Over Collections
Debugging (10 pages) Our Example
Debugging The Debugging Toolbar ; Starting the Debugger ; Stepping Over or Through ; Moving the Next Execution Line
Breakpoints Setting Breakpoints ; Removing Breakpoints ; Permanent Breakpoints (STOP) ; Conditional Breakpoints (Debug.Assert)
Using the Immediate Window Examples using the Immediate Window ; Executing Statements Using the Immediate Window ; Clearing the Immediate Window ; Using DEBUG.PRINT
Looking at Variables Hovering over Variables in Break Mode ; The Locals Window ; Watching Variables
The Call Stack Displaying the Call Stack ; Using the Call Stack
Handling errors (4 pages) The ERR Object
Trapping Errors and Resuming Execution
Putting It All Together – an Example
Raising Errors
QueryDefs and TableDefs (4 pages) Overview of QueryDefs
Creating and Deleting QueryDefs Creating Queries in Code ; Deleting Queries
An Example – Criteria Form
TableDefs – An Overview Listing out Tables ; The Bad News about TableDefs
Access objects (4 pages) What is an AccessObject?
Accessing an Object Choosing the Containing Object ; Collections Within Code Objects ; Collections within Access Database Data Objects
Putting it Together – Accessing Objects Example: Listing Form Names ; Example: Finding Out if a Form is Open ; Example: Listing Queries ; Example: Listing Database Contents
Working across applications (4 pages) Referencing Other Applications Possible Object Libraries Available
Example: Listing Data in Excel Step One: Defining the Problem ; Step Two: Referencing the Application ; Step Three: Instantiating the Application ; Step Four: The Final Code
Example: Working with Files
DAO and ADO (4 pages) Why you Need to Know This! Comparison of ADO and DAO ; Summary of Differences
Choosing DAO or ADO History of Usage of ADO/DAO by Access ; Considerations when Choosing DAO or ADO
Creating References What Happens if I Reference Both Libraries?
Disambiguation Duplicate References: Possible Solutions
Using Recordsets (DAO) (8 pages) Creating Recordsets The Types of Recordset ; Creating a Recordset
Working with Recordsets Moving through Recordsets ; Example of Moving through Recordsets ; Referring to Fields
Making Changes to Records Editing Records ; Adding New Records ; Deleting Records
Finding Records Creating the Right Type of Recordset for Finding ; Finding Until No More Matches Exists
Sorting and Filtering Sorting Recordsets ; Filtering Recordsets
Using Recordsets (ADO) (10 pages) Using the Right Object Library A Quick Reminder
Types of “Cursor”
Creating a Recordset Creating a Recordset Based on an SQL Command
Working with Recordsets Moving through Recordsets ; Example of Moving through Recordsets ; Referring to Fields
Editing Records Choosing a Lock Type ; Editing Records ; Adding New Records ; Deleting Records
Finding Records Repeated Finds
Importing Data to Excel Step One: Referencing ADO from Excel ; Step Two: Creating a Connection String ; Step Three: The Connection Code
Case Study - Navigation Buttons (4 pages) Wizards versus Creating Your Own
Creating your Navigation Buttons Step One: Adding Form Buttons ; Step Two: Creating the Navigation Buttons Code ; Step Three: Attaching your Function to your Button
Case Study - Database Security (2 pages) Creating a Table of Users
Authentication Code
Case Study - Front Menu (6 pages) Our Menu System
Creating a Splash Form Step One: Ensuring that Forms don’t Fill the Screen ; Step Two: Designing your Form ; Step Three: Ensuring your Form Opens Non-Maximized ; Step Four: Getting your Splash Form to Disappear ; Step Five: Getting your Splash Form to Autostart ; Other Startup Options
Creating a Menu Form
Case Study - Criteria Forms (4 pages) What is a Criteria Form?
Creating the Underlying Query
Creating the Criteria Form Creating the Form ; Writing the Code for the Show Button
Creating the Report Redisplaying the Criteria Form when you Close the Report
Case Study - Validating Forms (4 pages) Overview of Form Validation Form Validation Methods Summarised
Setting Field Validation Rules
Checking Each Control before you Leave it
Checking a Record before you Save It
The Access VBA Rabbit Hole (8 pages) Collections and Objects
Referring to Form, Report and Control Objects Referring to Forms or Reports ; Referring to Controls
Properties and Methods Properties ; Changing Properties in Visual Basic ; Methods ; Using Autocompletion to Distinguish between Methods and Properties
The DoCmd Object
The Access Object Models The Full Access Object Model ; The Object Browser
Object Variables Declaring Variables – the SET Command ; Converting Control Types

Notes:

  1. Since Wise Owl print courseware double-sided to save trees, the number of physical pages in each chapter is roughly half of the number of sides quoted.
  2. Downloads are provided as examples only, and should not be used or distributed in any way or form without the prior written permission of Wise Owl.
This page has 0 threads Add post