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/Investment

Public Course at Softek Private Course at Your Office Private Course at Softek
$275 per student $850 flat fee up to 8 students $1000 flat fee up to 8 students
or 1 voucher $950 flat fee up to 12 students $1100 flat fee up to 12 students
10% discount when 3+ attend $50 per additional student $50 per additional student

Private Group Training

Private group courses are cost effective when you have a group of students who need the same course. Pricing is based on the maximum number of students anticipated per day per course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your office, you are responsible for the classroom setup, including student computers, instructor station, LCD projector, and software installation. For courses conducted at Softek, we take care of classroom setup.

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, in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee