Access 2010: Intermediate

Course ID

27030

Course Description

Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.

Prerequisites

Access 2010: 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
  • Customized headers and footers
  • Calculated values
  • Printing
  • Labels

    Charts
  • Charts in forms
  • Charts in reports

    PivotTables and PivotCharts
  • PivotTables
  • Modifying PivotTables
  • PivotCharts
  • PivotTable forms

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.