Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

Introduction to Microsoft Access

Version 2010 • 2013 • 2016

1 Day, 9:00-4:00, 6 Hours

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

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

View Upcoming Schedule or Register for a Class

Is this the right course for you? Please contact our office at (202) 747-5000 if you have any questions.

Back to Agenda

Investment

Public Class

$275 per student
Or one voucher

View Schedule or Register

Private Group Classes

Conducted at Your Office

$850 flat fee for up to 8 students
$950 for up to 12 students
$50 per additional student

Conducted at Softek’s Facility

$1000 flat fee for up to 8 students
$1100 for up to 12 students
$50 per additional student

Have more or fewer students? Or, need to schedule more than one training day? Fill out our quote request form for a price quote based on your training needs. 

Softek also offers a 3-hour series for this application. Visit our agendas page  to view our 3-hour classes. 

Why choose Softek?

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