Microsoft Access Training
At a basic level, you can use Access to develop simple, personal database-management systems. Some people accululate everything from their wine collections to their home finances.
Companies use Access to develop Customer Databases, Asset Databases and many more. Access makes it easier to not only store information but also to create user forms to suit the user run queries on the stored data and run reports.
Good database design will make a difference for the end user and the amount of effort required in finding the necessary information.
With the help of our excellent trainers, you can learn how to design database that will suit your requirements. From small, one table database design to big databases with multiple tables linked together and automated actions created in Visual Basics, we will be happy to assist with all aspects of database creation.
Please select the version that you’re interested from below:
Please select the level that you’re interested in
Microsoft Access 2016 Intermediate
This course is designed for existing Microsoft Access users with sound basic database skills. The course will focus more on advanced features of Tables, Queries, Forms and Reports.
You must have sound Access skills and understand key concepts of a database, equivalent to our Access Introduction course contents.
This is a 1 day MS Access Intermediate course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.
Our Microsoft Access Intermediate course be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.
Access 2016 Intermediate Course Outline
Calculating a field
Multiple primary keys
Formatting a field
Link to external data source Recap and More on Relationships
Why create relationships between tables?
Different types of relationships
Adding tables to the relationship window
Creating, editing and deleting relationships
Conditions for setting up a relationship
Understanding Referential Integrity
Using the Cascade Update option
Using the Cascade Delete option
ADVANCED & ACTION QUERIES
Creating Calculated fields
Creating Parameter Queries
Creating Summary Queries
Creating a Crosstab Query
Editing a Crosstab Query
Use the Top Values option in a Query
Create and use a Make Table Query
Create and use an Append Query
Create and use a Delete Query
Create and use an Update Query
Main Form and sub forms
Exploring Layout View
Using Checkboxes & toggle buttons
Using combo boxes
Adding Option group controls
Adding Command button Controls
Setting more form properties
Calculation in a Form
Concatenating Text Values
Changing the data source options
Setting the Tab Order
Adding and Removing Filters (Selection and Forms)
Defining Validation Rules
Using advanced controls
Customise your Report
Format the controls
Adding Sub Reports
The Keep Together property
Grouping interval properties
Group Headers/footers calculations
IMPORTING & LINKING DATA
Importing from Access and Excel
Linking to an external Access Database Table
Linking to an Excel Workbook
Renaming and Copying Tables
Linked table manager
Export to various formats
CHARTS AND PIVOTS
Create a PivotChart / PivotTable
Edit Pivot Table options
Formatting a chart
Changing the chart type
Chart based on single record
One to One
(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training
Group for up to 8 learners
What Our Clients Say
This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.