Access 2010 school training courses in Colorado Springs, CO (public, in-house or online)

Lesson 1: Controlling Data Entry
Topic 1A: Constrain Data Entry Using Field Properties
Topic 1B: Establish Data Entry Formats for Entering Field Values
Topic 1C: Create a List of Values for a Field

Lesson 2: Joining Tables
Topic 2A: Create Query Joins
Topic 2B: Join Unrelated Tables
Topic 2C: Relate Data Within a Table

Lesson 3: Creating Flexible Queries
Topic 3A: Retrieve Records Using Select Queries
Topic 3B: Retrieve Records Based On Input Criteria
Top...

Full archival course description>>

Program Fundamentals


Introduction to Databases


Starting Access 2010


Opening a Database


What’s New in Access 2010


Understanding the Access Program Screen


Giving Commands


Using Command Shortcuts


Using Help





Database Basics


Working with Database Objects


Tour of a Table


Adding, Editing and Deleting Records


Tour of a Form
Full archival course description>>

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.)
Access to a Microsoft Access 2010 eLearning course for reviewing course topics 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 cou...

Full archival course description>>

This course is for End-users seeking to attain competency in Access 2007; end-users seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access ; end-users seeking to obtain Microsoft Application Professional certification; end-users seeking a basic IT certification such as ECDL/ ICDL, or an equivalent.

This advanced Access 2010 training class targets people who intend to design databases at an advanced level and/or improve existing Access databases.

Class Goals
•Learn to manage Access 2010 relational databases.
•Learn advanced form customization techniques.
•Learn to optimize and administer Microsoft Access 2010.
•Learn to manage relational databases.