Course Overview

Microsoft Access remains an amazing tool for when your data outgrows spreadsheets. Unlike many other database tools, it's far more user-friendly and ideal if you're not a developer.

In this Microsoft Access advanced course, we start where the beginner's course finishes and dives straight into more advanced Access features. This course assumes you know the basics of Access, including how to set up your database, how tables work, how to create forms and how to run simple queries.

In this advanced Access course, we look at using ODBC and SQL Server. We also take a deeper dive on using Macros and VBA in Access, splitting databases and advanced form creation. It's perfect if you have a working knowledge of Access but need to utilize its more advanced features.

Learning Objectives:

In this course you will learn:

  • All about Primary Keys and Indexes in Access
  • About customizing and filtering on the Datasheet View
  • How to link to other databases
  • All about using ODBC and SQL Server
  • How to split an Access database into front and back-end
  • All about Macros in Access including AutoExec
  • How to do basic VBA in Access including code and error handling
  • More advanced techniques around creating forms in Access
  • Advanced queries including "multiple where" criteria

Course Format

  • This is a video-led course.
  • This course includes practice exercise files.
  • This course is suitable for Windows users.

This course has a minimum of 25 learner registrations for us to provide a quotation.

Request a Quotation
Language
UK
Date last updated
5/29/2023
Duration
7 Hours
Suitable Devices
  • PC
  • Tablet
Audio is Required
  • Yes
Includes Video
  • Yes
Downloadable Resources
  • Accessibility Files
  • Exercise Files
  • Transcripts
Completion Criteria
  • Visit all pages
Pass Mark
  • None
Course Technology
  • HTML5
  • SCORM 1.2
Can be customised
  • No
Accreditation or Endorsements
  • No
Languages
  • English
Image of a SkillStation dashboard

Let's get started

with a demo and a 30-day free trial.

Cookies

To provide you with the best experience, we use cookies. You can read the details on our

Privacy Policy.