Microsoft Access Training Courses
With our MS Access training courses, you will gain the required knowledge to create, maintain and process large amounts of data easily. We have expert MS Access trainers to show how to make use of all the powerful tools.
MS Access courses can be run at our Access training centre in London, or onsite at your office, anywhere in the UK. Depending on your current Access knowledge, you might want to attend a standard course, e.g. Access Introduction or Access Advanced. Alternatively, we also run bespoke MS Access training courses, e.g. Queries Only, or Form Development. This is what makes us different. We can tailor any part of the courses to suit your needs.
If you have just upgraded to MS Access 2007, we also run Access 2007 upgrade training courses, to get you up to speed with the new and enhanced functionality.
If you would like to discuss your MS Access training course needs further with no obligation, then please contact us. We are a training company run by trainers, not sales staff. Therefore we can help you build your perfect MS Access training course.
Microsoft Access 2007 Training Courses
WIth the latest version of MS Access, learn how to create, maintain or edit a new or existing database by attending a Access 2007 training courses. Remember that we can tailored the courses to suit your needs.
- Access 2007 Upgrade Training Course
- Access 2007 Introduction Training Course
- Access 2007 Intermediate Training Course
- Access 2007 Advanced (Macros) Training Course
- Access 2007 VBA Training Course
Microsoft Access 2003 Training Courses
Learn how to use MS Access 2003 with a training course listed below:
- Access 2003 Introduction Training Course
- Access 2003 Intermediate Training Course
- Access 2003 Advanced (Macros) Training Course
- Access 2003 VBA Training Course
Standard Access Training Levels / Training Details / Locations / Schedule
Select a MS Access training course level below to view all the information you need about the course, including the cost of the course, the available training formats and much more.
- Introduction
- Intermediate
- Advanced
- Visual Basic
- Course Builder
- TNA
Access Introduction Training Course
This course is designed for new Access users, or self taught users. The course will cover all aspects of database design and objects.
Course Duration
This is a 2 day Access training course. The course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This Access introduction course can be run Onsite, at our Access training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.
Access Introduction / Beginners Training Course Contents
Database Overview / Terms / Planning
- An overview of databases, database objects and terminology
- Tables, Queries, Forms, Reports, Macros, Pages and Modules
- Planning a database structure and tables
- Creating a new database
Working with Tables
- Designing a Table, Rules for entering Field Names
- Enter data types, field descriptions
- Setting a Primary Key and Setting Multiple Primary Keys
- Removing a Primary Key
- Defining Field Properties(Default values, Input masks, Validation rules and text,
- Insert, Delete, Move and Rename Fields
- Table Wizards
Entering and Editing Data
- Switching Views in Access
- Entering and Editing Data
- Working in Data Entry Mode
- Sorting Data, Finding & Replacing Data
- Hiding and Un hiding Fields
Importing & Linking Data
- Importing from Access and Excel
- Linking to an external Access Database Table
- Linking to an Excel Workbook using the Wizard
- Renaming and Copying Tables
Queries and Filters
- Create a filter by selection
- Create a filter by form
- Save a filter by form as a select query
- Running a Select Query
- The Query Design Window
- Creating a query from the query window
- Adding fields to a query, Display/Suppress the display of a field
- Removing fields from a query
- Specifying Text, numeric, date, and logic criteria
- Specifying sub string searches using wild Card Characters
- Working with Conditions - BETWEEN, AND, OR, NOT, NULL
- Calculated fields
Relationships
- Why create relationships between tables?
- Different types of relationships
- Conditions for setting up a relationship
- Referential Integrity
- Cascade Update
- Cascade Delete
- Relationships Report
- Inserting Sub Datasheets
- Removing Sub Datasheets
- Expanding and Contracting Sub Datasheets
Multi Table Queries
- Multiple Table Queries
- Joining Tables for a query
- Join Properties - Inner and Outer Joins
- Find Unmatched Query Wizard
- Find Duplicates Query Wizard
Creating Forms
- Creating Forms using the Auto Form Tabular/Datasheet/Pivot Form wizard
- Creating Forms Using the Form Wizard
- Data Entry in Forms
- Resizing and Moving Controls
- Changing Text Attributes
- Resizing Forms
- The Field List Box
- Selecting Controls
- Formatting Controls
- Format Painter and AutoFormat
- Resizing and Moving Controls
- Properties of an item
Reports
- Standard Reports using Wizard
- Inserting, Moving, Sizing, deleting controls
- Customising Reports
- Grouping Data
- Using Expressions
- Mailing Labels
- Page setup
Access Intermediate Training Course
This course is designed for existing Access users. The course will focus more on Queries, Forms and reports. We also cover more advanced relationships.
Course Duration
This is a 1 day Access training course. The course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This Access Intermediate course can be run Onsite, at our Access training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.
Access Intermediate Training Course Contents
Relationships
- Why create relationships between tables?
- Different types of relationships
- Conditions for setting up a relationship
- Referential Integrity
- Cascade Update
- Cascade Delete
Advanced Queries
- Calculated fields
- Parameter Queries
- Summary Queries
- Crosstab Query Wizard
- Editing a Crosstab Query manually
- Top Values Query
- Make Table Query
- Append Query
- Delete Query
- Update Query
Advanced Forms
- Composite Forms including Main Form and sub forms
- Displaying Yes/No values
- Option groups
- Command buttons
- Setting form properties
- Calculations within Forms
- Combining Text Values
- Changing the data source
- Keyboard Short Cuts for Fields
- Tab Order
- Adding and Removing Filters(Selection and Forms)
- Defining Validation Rules
- Template Forms
Advanced Reports
- Using Expressions
- Adding Sub Reports
- Parameter reports
- Report Templates
- The Keep Together property
- Group on and group interval properties
- Advanced Grouping techniques
- Page setup
Charts and Pivots
- Formatting a chart
- Changing the type of chart
- Parameter chart Charting based on individual record
- Creating Pivots
Access Advanced Training Course
This course is designed for existing Access users whom need to start automating database tasks or simply complex database sequences
Course Duration
This is a 1 day Access Advanced course. The course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This Access Advanced course can be run Onsite, at our Access training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.
Access Advanced Training Course Contents
Macros
- An Overview
- Creating Macros and Running Macros
- Various Macro Actions
Names Macros
- Using ^ + letter
- Using ^ + Number
- Function keys
Conditional Macros
- Msgbox
- Set value
- Using functions
Event Procedures
- On open/close
- On got/lost focus
Creating a Switchboard (User Interface)
- Designing a switchboard
- Using Macros associated with Command Buttons
- Using Macros associated with Code
- Formatting switchboard forms
- Creating a Splash Screen
- Using autoexec
- Custom toolbar
- Custom menu
- Start-up Menu
VBA
- Sample subroutine
- Sample function
Access VBA Training Course
This course is designed for advanced Access users whom need to start automating database tasks or simply complex database sequences
Course Duration
This is a 2 day Access VBA course. The course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This Access VBA course can be run Onsite, at our Access training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.
Access VBA Training Course Contents
Macros
- Creating Macros
- Assigning Macros to Controls
- Group Macros
- Conditional Macros
- The AutoExec Macro
- The AutoKeys Macro
VBA
- An overview
- The Environment
- Working with Modules
- Converting Macros -DOCMD
- Events
Coding Structures
- Control Structures
- Looping Structures
Functions
- Purpose
- Creating and using Functions
Variables
- Option Explicit
- Variable Type
- Scoping a Variable
- Testing Variable Contents
User Interaction
- MsgBox
- InputBox
Debugging and Error Handling
- Breakpoints
- Stepping Code
- The Immediate Window
- Creating Error Traps
Data Access Objects (DAO)
- The Workspace Session
- Manipulating Recordsets
- Creating Queries
- Creating Tables
Active X Controls
- VBA Menus and Toolbars
Microsoft Access Tailored Courses
We have developed our own Custom Course Builder, where you can choose the topics you want to include in your MS Access training course. Each topic has an estimated teach time, so you can see how long it would take to learn what you want!
GO TO ACCESS COURSE BUILDER
MS Access Training Needs Analysis
We provide a free Access Training Needs Analysis (TNA) for all our clients to ensure the course is exactly what you need. Simply download our Access TNA. After completion, send this back to us. We can then build an Access Training Course that will ensure you only get shown relevant topics, unlike scheduled Access training courses.
Previous MS Access Training Course Versions and Levels
Below are all our different versions of MS Access Training Courses
Microsoft Access 2002 Training Courses
- Access 2002 Introduction Training Course
- Access 2002 Intermediate Training Course
- Access 2002 Advanced (Macros) Training Course
- Access 2002 VBA Training Course
Microsoft Access 2000 Training Courses
- Access 2000 Introduction Training Course
- Access 2000 Intermediate Training Course
- Access 2000 Advanced (Macros) Training Course
- Access 2000 VBA Training Course
Microsoft Access 97 Training Courses
- Access 97 Introduction Training Course
- Access 97 Intermediate Training Course
- Access 97 Advanced (Macros) Training Course
- Access 97 VBA Training Course
Access Resources
Access Training Los Angeles - provided by Training Connection
Access Training Toronto - provided by Servitor Training Services
Access Training Vancouver - provided by Alandale Computer Training
Access Training Sydney - provided by Raising the Bar



