Virtual and Classroom Training - All our courses are available virtually. We have also started a safe return to classroom training. Click here to learn more.

banner image

Access Advanced

1 Day Course
course icon

Course Information

Overview

Level

Advanced

Version

2016

Course Outline

1. Trusted Locations & Default Locations
  • Specifying a trusted location
  • Specifying the default file location
2. Queries
  • About queries
  • Creating & running an update query
  • Creating & running a delete query
  • Creating & running a make table query
  • Creating & running an append query
  • Creating & running a crosstab query
  • Creating & running a find duplicates query
  • Creating & running a find unmatched records query
  • What is a parameter query?
  • Creating & running a one variable parameter query
  • Modifying a one variable parameter query
  • Creating & running a two variable parameter query
  • Modifying a two variable parameter query
  • Using wildcards in a query: star
  • Using wildcards in a query: brackets & dash
  • Using wildcards in a query: exclamation mark
  • Using wildcards in a query: hash
  • Showing maximum or minimum values in a query
  • Using calculated fields that perform arithmetic calculations
  • Grouping information in a query using functions ‐sum
  • Grouping information in a query using functions ‐count
  • Grouping information in a query using functions ‐average
  • Grouping information in a query using functions ‐max & min
3. Forms
  • Types of form controls
  • Bound controls vs. Unbound controls
  • Creating, modifying & deleting bound controls: text box
  • Creating, modifying & deleting bound controls: combo box
  • Creating modifying & deleting bound controls: listbox
  • Creating bound controls: check box
  • Modifying & deleting bound controls: check box
  • Manipulating bound controls: option groups
  • Applying bound control properties: limit to list
  • Applying bound control properties: distinct values
  • Manipulating unbound controls containing arithmetic expressions
  • Manipulating unbound controls containing logical expressions
  • Modifying the tab order within a form
  • What is a sub‐form?
  • Creating a sub‐form
  • Linking a sub‐form
4. Reports
  • Formatting arithmetic calculation controls to display a percentage
  • Formatting arithmetic calculation controls to display currency
  • Formatting arithmetic calculation controls to display specific decimal places
  • Applying a running sum for a group or over all
  • What is concatenation?
  • Concatenating fields within a report.
  • Inserting a data field into a report group
  • Inserting a data field into a report page
  • Inserting a data field into report headers & footers
  • Sorting & grouping records in a report by field(s)
  • Forcing page breaks for groups in a report
  • Creating a linked sub‐report
5. Macros
  • Macro to close an object & open another object
  • Macro to open & maximize an object
  • Macro to print & close an object
  • Assigning a macro to a command button
  • Assigning a macro to an object
  • Assigning a macro to a control
6. Linking Data
  • Linking external data in an excel workbook to a database
  • Linking external text data in a txt file to a database
  • Linking external text data in a csv file to a database
  • Linking external data to a database using existing database files
7. Importing Data
  • Importing an excel file into a database
  • Importing a csv text into a database
  • Importing a txt file into a database
  • Importing an xml file into a database
  • Importing an existing database file into a database

Private Courses

We can arrange your own private Access course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

What Our Clients Think

Excellent course, The trainer was very helpful and taught the group a wide range of new Word skills.

Ben Cooper - TSS

The trainer was a really good instructor, he took the time to help us with individual issues and also tried to cater the course to meet our collective needs.

Ben Knight - Atlas Copco Ltd

As usual a first class training course.

Wendy Thomas - Aldi Stores Ltd

This course was great, the trainer was very knowledgeable and has improved my knowledge considerably. The facilities are fantastic. Thank You!

Kurtis Fleming - HM Revenue & Customs

Course is well structured and instructor delivered the content, and more, perfectly. No question left unanswered, no theory unexplained.

Aidan Hamill - Intact Software

The trainer demonstrated a deep and knowledgeable understanding of the software and was able to simplify its complexities.

Nathan Lewis - Lincolnshire County Council

Related Courses

Introduction 1 Day
You will gain an essential understanding of Microsoft Access  create a new database, construct data tables, design forms and create queries.
Intermediate 1 Day
You will learn intermediary level skills for querying, reports, lookups, relationships and joins together with exporting and printing data.
Advanced 1 Day
You will gain advanced techniques including update queries. forms and controls, reports, macros, linking to external data and importing data. 
Administration 1 Day
You will learn how to exchange data with other applications, automate business processes by using VBA code and secure and share databases.
Introduction to VBA 3 Days
You will master the essential skills you need to automate your databases using VBA procedures and functions, controlling execution, debugging code and handling errors.