Register Now      202-747-5000

Introduction to Microsoft Access

365 | 2019 | 2016
1 Day, 9:00-4:00

Course Overview

This instructor-led course, through lecture and hands-on exploration, will explain the basics of a database. Students will learn how to create a simple relational database, define tables, create data-entry forms, add and edit records, create queries to extract information, and design basic reports in Microsoft Access.

Course Objectives

  • Create a new database, create tables, define fields, and modify the structure
  • Create tables and establish a relationship
  • Create and edit forms for data entry
  • Find, sort, and filter data
  • Create, edit, and save queries based on different data types
  • Create reports to output data

Course Outline

Understanding the Basics of Databases

  • Understanding Databases
  • Examining Important Screen Elements
  • Opening Databases
  • Understanding the Main Database Objects
  • Steps for Designing Databases

Creating Databases, Tables, and Relationships

  • Creating Blank Databases
  • Understanding Fields and Data Types
  • Creating and Modifying Tables
  • Customizing the Navigation Pane
  • Opening Tables in Datasheet View
  • Switching between Datasheet and Design Views
  • Closing Tables
  • Establishing Relationships between Tables

Entering Data and Working with Tables

  • Adding Records
  • Using Data Entry Shortcuts
  • Editing Information and Undoing Changes
  • Saving Layout Changes to Tables
  • Entering Data into Related Tables
  • Deleting Records

Creating Forms to Facilitate Data Entry

  • Creating Forms Using the Form Command
  • Closing Forms
  • Opening Forms
  • Switching between Form Views
  • Understanding Form Sections
  • Widening Forms
  • Working with Layouts and Fields
  • Navigating Between Fields
  • Adding Records in Form View

Finding, Sorting, and Filtering Records

  • Navigating Through Tables and Forms
  • Searching for Specific Records
  • Sorting Records
  • Filtering Records

Creating Queries to Extract Information

  • Creating Queries in Design View
  • Adding Query Fields
  • Reviewing Data Types and Criteria Examples
  • Writing Criteria For Queries
  • Running the Query
  • Saving and Closing Queries
  • Modifying Queries
  • Sorting Query Results
  • Deleting Query Fields
  • Printing Query Results
  • Using "AND" Criteria
  • Using "OR" Criteria
  • Creating Multi-Table Queries

Creating Basic Reports

  • Creating Reports Using the Wizard
  • Closing Reports
  • Switching between Report Views
  • Opening Reports
  • Customizing Reports
  • Working with Layouts
  • Saving Reports
  • Changing Page Setup Options
  • Printing Reports
  • Creating Mailing Labels

 

Cost and Delivery Format Options

We offer the above listed class on our public schedule and as a private group class in the following delivery formats:

Public Class: Live Virtual or at Softek
Per student $275
Private Group Class: Live Virtual
1-4 students $700
5-8 students $850
9-12 students* $950
*$50 per additional student
Private Group Class: At Your Location or Softek
1-4 students $850
5-8 students $1000
9-12 students* $1100
*$50 per additional student

Private Group Training

Private group classes are cost effective when you have a group of students who need the same course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

  • A computer for each student (with the appropriate software installed), and
  • An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).

Customization

Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $125 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization. There is a 2-hour minimum fee for customization.

Why Choose Softek?

  • Live, virtual or in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee