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

Plus, when you sign up for this course, you'll also get these extras:

  1. Exercise files – to help you become proficient with the material.
  2. Instructor demo files – use the same database files used by your instructor.
  3. An optional online quiz (45 questions) - to test what you've learned.
  4. A certificate of completion - to tell everyone you've aced the course.

Microsoft Access remains a fantastic 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 it's more advanced features.

Course curriculum

  • 1

    Section 1: Introduction

    • Course Overview and Content
  • 2

    Section 2:Primary Keys and Indexes

    • Primary Keys and Indexing Rules and Guidelines

    • More About Indexes
  • 3

    Section 3: Using Datasheet View

    • Setting-up Northwind Database

    • Working in a Datasheet View

    • Customizing Datasheet View and Advanced Sorting and Filtering

    • Subdatasheets

    • Exercise 01
  • 4

    Section 4: Linking to Other Access Databases

    • Linking Two Tables to Other Access Databases
  • 5

    Section 5: Using ODBC and SQL Server

    • Acquiring and Installing SQL Server Express

    • Setting Up SQL Server Database

    • Exercise 02
  • 6

    Section 6: Splitting an Access Database

    • Splitting an Access Database into Front-end and Back-end

    • Converting Shared Table into Local Table; Moving Back-end Database

    • Exercise 03

    • Addressing Multi-user Issues when Sharing Data
  • 7

    Section 7: Macros

    • Basics of Macros

    • Macros on Events; AutoExec

    • More About AutoExec; Bypassing AutoExec

    • Macro Security Settings

    • Exercise 04
  • 8

    Section 8: The Ribbon

    • Customizing the Ribbon and Quick Access Toolbar
  • 9

    Section 9: Visual Basic for Applications

    • Convert Macros to VBA; VBA Editor and Property Windows

    • VBA Modules; Running Code and Error Handling

    • Creating Modules; Subs, Functions, Intellisense and Variables

    • Scope, Variable Naming aand Strings

    • Standard Functions; Logical, Case and Loop Statements
  • 10

    Section 10: Access Events Model

    • Adding Events to Assets Database

    • Exercise 05

    • Common Events; Form and Report Events

    • Switchboard and Navigation Form; Error Handling

    • Exercise 06
  • 11

    Section 11: Forms

    • Formatting Bound and Control Form

    • Split Forms; Macro Error Handling

    • Creating Form with Tab

    • Go To Combo Box and Its Properties

    • Exercise 07
  • 12

    Section 12: Advanced Use of Queries

    • Basics of Queries

    • Syntax of SQL Statements

    • Use of Multiple Where Criteria & Select Statements Function

    • Exercise 08

    • Action Queries - Part 1

    • Action Queries - Part 2
  • 13

    Section 13: Packaging You Application

    • Steps in Packaging Access Application

    • Exercise 9
  • 14

    Section 14: Conclusion

    • Course Close
  • 15

    Exercise and Course Files

    • Course Files

    • Exercise Files