• One-Day Course

    6 Hours
    of training

  • 6 to 20 Participants

    6 to 20
    participants from
    your organization

  • On-Site or Virtual

    On-Site at your
    place of business or
    Virtual via Zoom / Teams

Take your Microsoft Access skills to a new level

WORKSHOP DESCRIPTION

Microsoft Access is a relational database designed to help your team track, manage, and report on large data sets. Whether you want to work with an inventory, track customer interactions, or build a repository of project data, this powerful application is up to the task! Our Microsoft Access training is designed to help your group build databases for a broad range of applications.

This hands-on course will teach you the important functions of this industry-leading software.

Microsoft Access

WHO SHOULD ATTEND:

  • Experienced Access users who work with sophisticated databases

YOU WILL LEARN:

  • Understand the databases that will be used during the course.
  • Enhance tables by creating lookups.
  • Create various types of advanced queries.
  • Create advanced forms by adding controls, subforms, calculations, and graphic images.
  • Create advanced reports by adding controls, grouping, subforms, calculations, graphic images, and charts.
  • Use hyperlinks and current Access tools to connect database objects and related resources.

COURSE OUTLINE

Database Overview

  • Database Overview
  • Review Relational Database Concepts

Enhancing Tables

  • Copying a Database Object
  • Lookup Fields
  • Creating a Lookup
  • Improving Data-Entry Structure

Advanced Queries

  • Query Overview
  • The Query Wizard
  • Nested Queries
  • Query Joins
  • Make Table Queries
  • Append Queries
  • Summary Queries
  • Crosstab Queries

Advanced Forms

  • Form Design
  • Controls
  • Form Properties
  • Subforms
  • Advanced Calculations
  • Customizing Forms

Advanced Reports

  • Designing Reports
  • Sorting and Grouping
  • Layout Properties
  • Calculations
  • Subreports
  • Graphic Reports
  • Chart Wizard

Supplemental Topics: Working with Web Tools

  • Working with Related Resources
  • Hyperlinks
  • Connect Access Data with other Microsoft 365 Tools

Summary and Evaluations

METHODS TO BE USED

This is a live, instructor-led training course with hands-on exercises.

Participants are requested to bring their computers to the session. Laptops are also available to rent for an additional fee.

Back to all Microsoft Office Courses

For more details, customization, or pricing…

Please complete the form below and we will respond to you by the next business day!

– JJ2749 –