Microsoft Access Training Courses in London and UK
Unlike training companies offering scheduled courses, we offer the alternative of your Microsoft Access Training Course delivered in central London on a date of your choice, either onsite or at our offices in Moorgate. We offer Access training courses for Introduction or Beginners, Intermediate and Advanced right up to seminars looking at the VBA programming language or upgrade training for individuals or groups.
In addition we also run custom Access coursestailored to your exact requirement. You select required topics to build your own bespoke MS Access training course. Our unique Access Course Builder tool lets you create a shopping basket of training topics for your bespoke Access course.
Whether you need a consultative 1 to 1 Access training session using your examples or group Access training, our trainers can deliver a highly professional service. The course contents below are general for all versions and levels of Access.
If this sounds like the training service you require, then please contact us on 020 7920 9500 or click the Contact Me Now button below. A member of our team will get back to you asap.
Microsoft Access Training Course Levels and Course Contents
Intro
Inter
Advanced
VBA
Custom Course
TNA
Microsoft Access Introduction Training Course
Duration - This is a 2 day course starting at 09:30 until 16:30 each day
Access Course Objectives -To understand the concept and purpose of a database and to gain a good working knowledge of Access to be able to create and edit Access databases.
Screen Layout
Navigating Microsoft Access
Access Overview
Database Container
Tables
Queries
Forms
Reports
Macros
Pages
Modules
Grouping Favourites
Planning a Database
Designing a Database
Normalisation
Relational Databases
Creating Tables
Create a Database
Designing a Table
Rules for entering Field Names
Enter data types, field descriptions
Setting a Primary Key
Setting Multiple Primary Keys
Removing a Primary Key
Table Properties and Structure
Defining Field Properties
Working with Input masks
The Input Mask Wizard
Validation Rule
Validation text
Other field Properties
Insert fields
Delete fields
Move Fields
Rename Fields
Table Wizards
Entering and Editing Data
Switching Views in Access
Enter data into a table
Modify data in a table
Working in Data Entry Mode
Sorting Data
Finding & Replacing Data
Hiding and Unhiding Fields
Importing and 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
Using Filters and Select Queries
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 multiple criteria
Working with Conditions - BETWEEN, AND, OR, NOT, NULL
Calculated fields
Simple Query Wizard
Removing fields from a query
Specifying Text, numeric, date, and logic criteria
Specifying sub string searches using wild Card Characters
Working with multiple criteria
Working with Conditions - BETWEEN, AND, OR, NOT, NULL
Calculated fields
Simple Query Wizard
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 Subdatasheets
Removing Subdatasheets
Expanding and Contracting Subdatasheets
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
Form Layout and Formatting
Resizing Forms
The Field List Box
Selecting Controls
Formatting Controls
Format Painter and AutoFormat
Resizing and Moving Controls
Properties of an item
Creating Reports
Standard Reports using Wizard
Inserting, Moving, Sizing, deleting controls
Customising Reports
Grouping Data
Using Expressions
Mailing Labels
Page setup
Microsoft Access Intermediate Training Course
Duration - This is a 1 day course starting at 09:30 until 16:30 each day
Course Objectives - To build on previous knowledge and explore advanced functionality within Access, giving delegates a greater understanding of advanced queries, forms and reports to retrieve the information required.
Relationships
Why create relationships between tables?
Different types of relationships
Conditions for setting up a relationship
Referential Integrity
Cascade Update
Cascade Delete
More on Queries
Calculated fields
Parameter Queries
Summary Queries
Crosstab Query Wizard
Editing a Crosstab Query manually
Top Values Query
Action Queries
Make Table
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
Advanced Forms Continues
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
Formatting a chart
Changing the type of chart
Parameter chart Charting based on individual record
Microsoft Access Advanced Training Course
Duration - This is a 1 day course starting at 09:30 until 16:30 each day
Course Objectives - Use Microsoft Access to Automate and simplify navigation.
What is a Macro
What are Macro Actions
Macros
Creating Macros
Running Macros
Using the Names Macro
Auto Keys
Using ^ + letter
Using ^ + Number
Function keys
Conditional Macros
Exploring macro Actions
Msgbox
Set value
Using functions
Event Procedures
On open/close
On got/lost focus
Creating A switchboard
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
Microsoft Access VBA (Visual Basic) Training Course
Duration - This is a 2 day course starting at 09:30 until 16:30 each day
Course Objectives -This course is designed to take your Access databases to the next level by using VBA.
Working with Macros
Creating Macros
Assigning Macros to Controls
Group Macros
Conditional Macros
The AutoExec Macro
The AutoKeys Macro
Synchronising Forms using Macros
Visual Basic For Applications
What is it, and Why use it?
The Environment
Working with Modules
Converting Macros to VBA
DoCmd
Event Driven Programming
VBA Syntax
Getting Help
Code Structures
Loop structures
Decision making structures
Subroutines and Functions
Calling
Availability
Variables and Constants
Option Explicit
Variable Type
Scoping a Variable
Testing Variable Contents
User Interaction
MsgBox
InputBox
Error Trapping and Debugging
Breakpoints
Stepping Code
The Immediate Window
Creating Error Traps
Data Access Objects (DAO)
The Workspace Session
Manipulating Recordsets
Creating Queries
Creating Tables
ActiveX Controls
VBA Menus and Toolbars
Micosoft 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!
We provide a free Access Training NeedsAnalysis (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.
Below you will find all our Microsoft Access Training Courses for all versions of MS Access and also all levels, from Introduction to Advanced and beyond.
After this Access course, you will be able to create a database using tables, forms, queries and reports. You will have a good understanding of relational databases concepts and development.
Our Advanced Access course will introduce you to database automation using macros. Creating a user interface for your database and also learn to automate import and export procedures.
Using VBA in your database will enable you to build more complex statements, automation and validation on data. This course is designed for Advanced Access users.
After this course, you will be able to create a database using tables, forms, queries and reports. You will have a good understanding of relational databases.
Building on the introduction course, this course will enable you to create more complex queries, better forms and reports and relational databases with join type queries.
Our Advanced Access course will introduce you to database automation using macros. Creating a user interface for your database and also learn to automate import and export procedures.
Using VBA in your database will enable you to build more complex statements, automation and validation on data. This course is designed for Advanced Access users.
With our Access Advanced course for 2002, we will guide you through automating repetitive tasks, like running running a sequence of queries using Access Macros.
For the advanced user, this course is aimed at creating complex statements in VBA for Access. Validating, error handling and looping structures are all included in the course.
After this Access course, you will be able to create a database using tables, forms, queries and reports. You will have a good understanding of relational databases.
Building on the Access introduction course, this course will enable you to create more complex queries, better forms and reports and relational databases with join type queries.
Our Advanced Access course will introduce you to database automation using macros. Creating a user interface for your database and also learn to automate import and export procedures.
Using VBA in your Access database will enable you to build more complex statements, automation and validation on data. This course is designed for Advanced Access users.
After this Access course, you will be able to create a database using tables, forms, queries and reports. You will have a good understanding of relational databases.
Building on the introduction course, this course will enable you to create more complex queries, better forms and reports and relational databases with join type queries.
Our Advanced Access course will introduce you to database automation using macros. Creating a user interface for your database and also learn to automate import and export procedures.
Using VBA in your database will enable you to build more complex statements, automation and validation on data. This course is designed for Advanced Access users.
1-to-1 training courses are charged at £450 per day. (Our offices or your venue)
All IT training courses at our offices are charged at a daily rate of £695 per day, for 2 to 8 delegates.
We also offer training at your venue for £595 per day. If required, laptops are available at an additional £150 per day.
For courses outside the M25, trainer travel and accomodation expenses are not included in the above prices but are charged at cost.
Build your course
With our course builder form, you can choose your own topics and build a course that suits your needs and your time scale. Select a application below to go to the Course Builder page
Microsoft Access Training Courses in London and UK
MS Access 2007 Training Courses
