Introduction to Microsoft Access

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
Per student	$325

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
1-4 students	$950
5-8 students	$1100
9-12 students*	$1200
*$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 $150 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.