Access 2013: Intermediate MOS Edition

Course ID

27060

Course Description

This course provides students with additional skills and concepts needed to use Microsoft Access 2013 productively and efficiently. They will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields.

Prerequisites

Access 2013: Basic

Audience

Students who wish to gain intermediate-level skills with working knowledge in constructing relational databases, database maintenance, advanced queries and reports, and Access program integration.

Course Content

    Relational databases
  • Database normalization
  • Table relationships
  • Referential integrity

    Related tables
  • Creating lookup fields
  • Modifying lookup fields
  • Subdatasheets

    Complex queries
  • Joining tables in queries
  • Using calculated fields
  • Summarizing and grouping values

    Advanced form design
  • Adding unbound controls
  • Graphics
  • Adding calculated values
  • Adding combo boxes
  • Advanced form types

    Reports and printing
  • Report formatting
  • Calculated values and subreports
  • Printing
  • Labels

    Charts
  • Charts in forms
  • Charts in reports

For More Information

For training inquiries, call 850-308-1376

or email us at eramos@gbsi.com

Course Details

Duration - 1 day
Price - $250.00 USD


(Discounts may apply. Call for more information.)

Course Actions

Schedule

Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.