How To Take This Class

Course Overview

In this Microsoft Access 2013 Training course, students will learn how to use Access 2013 to manage data, including creating a new database; constructing tables; designing forms and reports, creating queries to join, filter, and sort data, write advanced queries, structure existing data, share data across applications, and customize reports. Students can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2013.

Course Prerequisites

Basic computer experience required.

Course Audience

This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2013, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

What You'll Learn

After successfully completing this course, students will be able to:
  • Organize data efficiently by using a database management system; start Access, open Access databases and identify components of the Access window.
  • Plan and create a database; use Datasheet view and Design view; create, modify, and work in tables; and set the primary key for a table.
  • Modify a table’s design; use the Attachment data type; find and replace values; and sort, filter, and delete records.
  • Set field properties; create input masks; and set validation rules.
  • Create queries, and sort and filter the results; modify queries; and perform operations in queries.
  • Create, modify, and work with forms; and use them to sort and filter records.
  • Create, modify, and print reports; and add summary fields to a report.
  • Normalize tables, analyze tables, and view object dependencies; set table relationships; implement referential integrity between related tables; and set cascading deletes and updates.
  • Create lookup fields and multi-valued fields; modify lookup field properties; and use a subdatasheet to add data to related tables.
  • Create join queries; create calculated fields in a query; and use queries to view summarized and grouped data.
  • Add unbound controls, graphics, and calculated fields to a form; and create multiple-item forms, split forms, datasheet forms, and subforms.
  • Add headers and footers in a report; use functions to add calculated values in a report; print database objects and database documents; and create labels.
  • Create and modify charts in forms and reports.

Course Duration

2 Days

Course Outline

  1. Getting started
    • Database Concepts
    • Exploring the Access environment
  2. Databases and tables
    • Planning and designing databases
    • Exploring tab les
    • Creating tables
  3. Fields and records
    • Changing the design of a table
    • Finding and editing records
    • Organizing records
  4. Data Entry rules
    • Setting field properties
    • Working with input masks
    • Setting validation rules
  5. Basic queries
    • Creating and using queries
    • Modifying query results and queries
    • Performing operations in queries
  6. Using forms
    • Creating forms
    • Using Design view
    • Sorting and filtering records
  7. Working with reports
    • Creating reports
    • Modifying and printing reports
  8. Relational databases
    • Database normalization
    • Table relationships
    • Referential integrity
  9. Related tables
    • Creating lookup fields
    • Modifying lookup fields
    • Subdatasheets
  10. Complex queries
    • Joining tables in queries
    • Using calculated fields
    • Summarizing and grouping values
  11. Advanced form design
    • Adding unbound controls
    • Graphics
    • Adding calculated values
    • Adding combo boxes
    • Advanced form types
  12. Reports and printing
    • Report formatting
    • Calculated values and subreports
    • Printing
    • Label printing
  13. Charts
    • Charts in forms
    • Charts in reports

What Students Receive

Each student will receive:
  • A printed courseware manual with examples and hands-on exercises for use during and after class.
  • A PC headset for communicating with your instructor and fellow students during your Microsoft Access 2013 Training Class
  • A course completion certificate upon successful completion of your Microsoft Access 2013 Training course
  • Six months of post-class live, online chat support from a Microsoft Access Instructor