Access school training courses in Alexandria, LA (public, in-house or online)

If you need to learn to perform at least the basic operations of Microsoft Access 2007 as part of your day-to-day responsibilities, you should start with this class. You will learn how valuable a relational database program can be in many business applications. Topics include:
◦Examine Database Concepts
◦Describe the Relational Database Design Process
◦Create a New Database
◦Work with Subdatasheets
◦Perform Calculations on a Record Grouping
◦Create a Form
◦Create a Re...

Full archival course description>>

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

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

This is a self-paced course that shows you how you can use JDBC to access an Oracle database from a Java application. The first module teaches you how to use JDBC to run queries and manipulate data in the database; the second module discusses using JDBC in Web-based applications, and the third module deals with some more advanced JDB