Access – Supported – Half Day

$ 240.00

Module Duration: 3.5 Hours

Class Agenda

Resource Setup 30 Minutes
Training Session 3 Hours
Breaks Prescribed by Instructor

Our Access classes start by introducing you to the core concepts of simple databases and the Access application. Learn the ways data can be entered, find the information you need within it, and display it in professional reports that can be shared with others. Then we’ll see how data relationships are formed and learn how to optimize your database. Gain exposure to more advanced techniques to locate the data you want and build reports to display it. Finally, we’ll learn the skills you need to manage your database, increase your productivity by automating common processes, and securely make the information in your database available to other applications and colleagues who lack your level of database knowledge.

Module 1: Introduction to Relational Databasing

  • Launch Access and Open a Database
  • Use Tables to Store Data
  • Use Queries to Combine, Find, Filter, and Sort Data
  • Topic D: Use Forms to View, Add, and Update Data
  • Use Reports to Present Data
  • Get Help and Configure Options in Microsoft Access
  • Plan an Access Database
  • Start a New Access Database
  • Create a New Table
  • Establish Table Relationships

Module 2: Introduction to Database Output

  • Create Basic Queries
  • Sort and Filter Data in a Query
  • Perform Calculations in a query
  • Start a New Form
  • Enhance a Form
  • Start a New Report
  • Enhance Report Layout

Module 3: Data Structure and Integrity

  • Restrict Data Input through Field Validation
  • Restrict Data Input  through Forms and Record Validation
  • Data Normalization
  • Associate Unrelated Tables
  • Enforce Referential Integrity
  • Create Lookups within a Table
  • Work with Subdatasheets

Module 4: Intermediate Data Retrieval

  • Create Query Joins
  • Create Subqueries
  • Summarize Data
  • Apply Conditional Formatting
  • Create Tab Pages with Subforms and Other Controls
  • Apply Advanced Formatting to a Report
  • Add a Calculated Field to a Report
  • Control Pagination and Print Quality
  • Add a Chart to a Report

Module 5: Data Migration and Updating

  • Import and Link Data
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
  • Create Subreports
  • Create a Navigation Form
  • Show Details in Subforms and Popup Forms

Module 6: Database Management and Security

  • Create a Standalone Macro to Automate Repetitive Tasks
  • Create a Macro to Program a User Interface Component
  • Filter Records by Using a Condition
  • Create a Data Macro
  • Introduction to VBA
  • Use VBA with Form Controls
  • Back Up a Database
  • Manage Performance Issues
  • Document a Database
  • Split a Database for Multiple-User Access
  • Implement Security
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

Event Details

Phone: (602)252-3955


Scroll to Top