Access Training

for Users and Database Builders

Four 1-day Modules
User Track: Modules 1 and 3
Database Builders Track: Modules 1, 2, 3 and 4

Module 1: Quick Start - One Day

Objectives
To enable delegates to:
create basic tables for recording unique records;
build queries to sort and select data from a single table;
create mailing labels or merge to Word

Suitable for Users and Database Builders

Pre-requisites
A working knowledge of MS Office Word or Excel and Windows

1. Single Table Databases
How Access stores data; Creating a table; Defining data types; Field sizes for numeric data; Data validation rules; Index fields; Required and Optional fields; Importing data from Excel or Word; Viewing data in a form; Searching for a specific record; Wildcard searching; Filtering the data
2. Creating a Query, a Report and Merge to Word
Querying the table; Sorting the output; Sorting on more than one field; Printing the results; Changing the order of fields; Setting criteria; Improving productivity with wildcards in criteria; AND and OR criteria; Creating Mailing Labels and Mail Merge Letters within Access; Creating a neatly formatted report with data grouped logically together

Module 2: Nuts and Bolts - One Day

Objectives
To enable delegates to:
create related tables for recording more complex data relationships
work with multiple relationships;
build and run queries across tables; and
to automate updating, deleting build and use Forms to control data entry.

Suitable for Database Builders

Pre-requisites
A working knowledge of MS Office Word or Excel and Windows and Module 1

1. Working with Multiple Tables:
Unavoidable Relational Theory - Why use multiple tables, and what data goes where?; Understanding and creating a One-to-Many Relationship; Understanding and setting Referential Integrity Rules; Overcoming Many-to-Many Relationship problems; Selecting a Primary Key field; Field Naming conventions; Using the Caption Property; Setting Table Properties to assist data Validation; Viewing data in related tables; When to use a Lookup table; Building a Form to populate multiple tables; Creating a Query to interrogate multiple tables

2. Using Form Properties and Controls to Manage data Input:
Understanding Form Sections, and adding text boxes to display the results of Calculations; Adding Command Buttons to a Form; Replacing Text Boxes with Combo boxes to give users a list to choose from; Populating Combo Boxes from a Lookup table; Using the same Form for new data or editing existing data; Working in Design View on a Form; Working with controls singly or as groups; Manipulating Tab Order to make forms more useable; Creating a Form that is not linked to a Table; Using a Dialog Form instead of Parameters in a Query; Creating a Multi-Page Switchboard Form; viewing a sub-form design within a master form

Module 3: Management Information - One Day Course Code: AC200203

Objectives
To enable delegates to:
build and run queries across tables to analyse data;
build and run better presented reports

Suitable for Users and Database Builders

Pre-requisites
A working knowledge of MS Office Word or Excel and Windows and Module 1

1. Developing Powerful, Re-usable Queries and Reports:
Creating a Parameter Query; Controlling the data type entered as a Parameter; Concatenating a Parameter and other text; Creating a Calculated Field; Using a Calculated Field in another calculation; Setting Field Properties; Using the Expression Builder to create a calculated criterion; Using Totals in Queries; Creating a report with Section Totals; Introduction to Report Properties; Enhancing a Report created by the Report Wizard; Working in Design View on a Report; Conditional Formatting; Working with controls singly or as groups; Using Section Properties and Group Properties to control the Pagination of a report; Creating a Crosstab Query with the Crosstab Query Wizard; Creating a Report based on a Crosstab Query; Using the Find Unmatched and Find Duplicates Query Wizards; Creating a Report with a Sub-Report; Publishing a Report or a Data Page to the Internet/Intranet

Module 4: Optimising Your Applications - One Day Course Code: AC200204

Objectives
To enable users to automate:
record management through action queries;
database administration

Suitable for Database Builders

Pre-requisites
A working knowledge Modules 1, 2 and 3

1. Action Queries and Introduction to Automation:
Using an Update Query to modify data values; Using criteria with an Update Query; Using a Make Table Query to create a New Table in your database; Using an Append Query to add data to an existing Table; Using a Delete Query to delete batches of Data; Using a Delete Query with Criteria; Understanding the Warning messages that appear when some records violate data integrity rules; Creating a macro to automate Archiving

2. Database Administration:
Setting Startup Options; Hiding the Database Window; Setting Group and User Accounts and Permissions; Using linked tables to create a shared database; Using the Form Locking Property to control user access to a form and its data; Compacting the Database; Understanding and Creating Replicas; Documenting the Database

3. Macros:
Sequential Macros; Macro Groups; Conditional Macros; Attaching Macros to buttons; Macros that run at Startup

4. Event Procedures:
How VBA SubProcedures work; Creating Event Procedures for Forms and Reports; The sequence of events on Forms, Reports, and Controls; Using Procedures to manipulate data; Using Mouse and Keyboard Events to trigger Procedures

Please note: IPS offers: a follow-on course 2 day Access/VBA; customised workshops dedicated to helping you complete your own projects. We can also develop databases for you. Please ask for details of any of these services.