How To Take This Class

Course Overview

This Microsoft Access 2010 Introduction Training course is designed for students who wish to learn the basic operations of the Access 2010 database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications. This class provides instructor-led training in Access for students new to the program.

Course Prerequisites

General understanding of the Windows desktop environment

Course Audience

Desktop End-user

What You'll Learn

Upon completion of the course, students will be able to:
  • Navigate the Microsoft Access 2010 interface
  • Create and manage data in tables
  • Examine existing table relationships
  • Query the database
  • Design simple forms
  • Create and modify Access reports
  • Streamline data entry and maintain data integrity
  • Join tables to retrieve data from unrelated tables
  • Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries
  • Improve forms
  • Customize reports to organize the displayed information and produce specific print layouts
  • Share data between Access and other applications

Course Duration

2 Days

Course Outline

  1. Getting Started with Access Databases
    • Identify the Elements of the Access 2010 Interface
    • Identify the Components of a Database
    • Examine the Relational Database Design Process
  2. Building the Structure of a Database
    • Create a New Database
    • Create a Table Using the Design View
    • Manage Tables
    • Establish Table Relationships
  3. Managing Data in a Table
    • Modify Table Data
    • Sort and Filter Records
    • Work with Subdatasheets
  4. Querying a Database
    • Create a Query
    • Add Criteria to a Query
    • Add a Calculated Field to a Query
    • Perform Calculations on a Record Grouping
  5. Designing Forms
    • Create a Form
    • Modify the Design of a Form
    • View and Edit Data Using an Access Form
  6. Generating Reports
    • Create a Report
    • Add a Control to a Report
    • Format the Controls in a Report
    • Enhance the Appearance of a Report
    • Prepare a Report for Print
  7. Controlling Data Entry
    • Constrain Data Entry Using Field Properties
    • Establish Data Entry Formats for Entering Field Values
    • Create a List of Values for a Field
  8. Joining Tables
    • Create Query Joins
    • Join Tables with No Common Fields
    • Relate Data Within a Table
  9. Creating Flexible Queries
    • Set the Select Query Properties
    • Retrieve Records Based on Input Criteria
    • Create Action Queries
  10. Improving Forms
    • Restrict Data Entry in Forms
    • Organize Information with Tab Pages
    • Add a Command Button to a Form
    • Create a Subform
    • Display a Summary of Data in a Form
    • Change the Display of Data Conditionally
  11. Customizing Reports
    • Organize Report Information
    • Format Reports
    • Control Report Pagination
    • Summarize Report Information
    • Add a Subreport to an Existing Report
    • Create a Mailing Label Report
  12. Sharing Data Across Applications
    • Import Data into Access
    • Export Data to Text File Formats
    • Export Access Data to Excel
    • Create a Mail Merge

What Students Receive

Each student will receive:
  • A printed courseware manual for use during and after class.
  • Access to a searchable, electronic version of the courseware manual for reference after class (available for 12 months after class.)
  • A PC headset for communicating with your instructor and fellow students during your Microsoft Access 2010 Training Class
  • A course completion certificate upon successful completion of your Microsoft Access 2010 Training course
  • Six months of post-class email support from a Microsoft Access Instructor