Schedule your class   Schedule >

Access Advanced (Level 3)

Course length:  1-day

Exercise Files

 

Course Description

Microsoft’s Office Access is Microsoft’s popular database program.  Microsoft Access is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you. Access makes it easy to keep track, organize, and sort your data.

 

This advanced course builds upon intermediate Microsoft Access skills to help students become power users.

 

In this advanced Microsoft Access course, students will delve deeper into the program by studying how to manage a database, create macros, write SQL queries, split databases for multi-user environments; and much more.

 

This course is delivered using Access 2016. With the exception of the new modern look and touch screen support, there are few differences between the Office suites; therefore, users currently operating on Office 2010 and later will benefit from the material in this course.

 

Prerequisites

Before attending this course, students must have completed Access Foundation (Level 1) and Access Intermediate (Level 2) or have equivalent knowledge.

 

Course Outline

Managing Your Database

In this module, students will learn to manage, maintain and optimize a database using built-in tools in Access.

  • Compacting and Repairing a Database
  • Encrypting a Database with a Password
  • Backing Up Your Database
  • Exporting a Database and Database Objects
  • Printing Database Objects

Advanced Query Tasks

This module will give students basic knowledge on how to write and use SQL queries in Access and a basic understanding of SQL statements and SQL keywords.

  • Understanding SQL Statements
  • Basic SQL Keywords
  • Creating SQL Queries
  • Using the Expression Builder

Creating Basic Macros

This module shows students how to create macros to automate processes in a database.

  • Creating a Standalone Macro
  • Using the Action Catalog
  • Adding Comments to Macros
  • Using If-Then Actions
  • Handling Macro Errors

Advanced Macro Tasks

Students will take a closer look into macros and learn to organize and execute them more efficiently.

  • Creating Event Procedures
  • Creating Data Macros
  • Creating Submacros
  • Grouping Submacros

Creating Navigation Forms

Next, students are shown how to create a navigation form and add tabs to it, create a tab hierarchy in a navigation form, and automatically display a navigation form when the database opens.

 

  • Creating a Navigation Form
  • Adding Tabs to a Navigation Form
  • Creating a Tab Hierarchy
  • Displaying the Navigation Form when the Database Opens

Creating Modal Dialog Boxes

Modal dialog boxes get a thorough look in this module. Topics include how to create, format, and modify a modal dialog box.

  • Creating a Modal Dialog Box
  • Adding Controls
  • Setting Properties
  • Formatting a Modal Dialog Box

 Splitting the Database

When dealing with databases, it’s a good idea to have tools to manipulate them effectively. This module takes a look at how to back up a database, split a database, configure Access 2013 for a multi-user database, and set record locking options.

  • Backing Up the Database
  • Splitting the Database
  • Configuring Access 2013 for a Multi-User Database
  • Setting Record Locking Options

 

Schedule your class   Schedule >