Access 2010: Basic

Course ID

27020

Course Description

After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports.

Prerequisites

Students should be comfortable with basic navigation tasks of the Windows ® environment.

Audience

Students who wish to establish a foundation in Microsoft Access 2010 and build the necessary skills to create a database, construct data tables, design forms/reports and create queries.

Course Content

    Getting started
  • Database concepts
  • Exploring the Access environment
  • Getting help

    Databases and tables
  • Planning and designing databases
  • Exploring tables
  • Creating tables

    Fields and records
  • Changing the design of a table
  • Finding and editing records
  • Organizing records

    Data entry rules
  • Setting field properties
  • Working with input masks
  • Setting validation rules

    Basic queries
  • Creating and using queries
  • Modifying query results and queries
  • Performing operations in queries

    Using forms
  • Creating forms
  • Using Design view
  • Sorting and filtering records

    Working with reports
  • Creating reports
  • Modifying and printing report

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.