Access school training courses in Charlotte, NC (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>>

Getting Started
Introduction to Programming in Access
Why Program in Access?
Understanding the Development Environment
Using Visual Basic Help
Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Function Procedure
Naming Procedures
Organizing Code and Procedures
Working with the...

Full archival course description>>

When you have completed this Access course, you will be able to:

•Import and exporting data to/from the database
•Analyze your database design
•Create advanced queries for maintenance and deeper analysis
•Create advanced forms and reports
•Manage your database objects
•Create macros, and VBA modules
•Manage your complete database
Access computing skills are essential, and with lecture and demonstration this hands-on training course is designed to teach you how to beco...

Full archival course description>>

In the course, students create and modify new databases and their various objects. They learn how to maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Accessâ„?2007 with other applications. (Second Edition)

Objective :
Upon successful completion of this course, students will be able to: - examine the basic database concepts and explore the Microsoft Office Access 2007 environment. - design a simple database. - build a new database with re...

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>>