Access school training courses in Allentown, PA (public, in-house or online)

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

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

This course provides the knowledge and skills that IT Professionals need to configure identity and access solutions with Windows Server 2008 Active Directory.

Objective :
After completing this course, students will be able to: - Describe identity and access solutions. - Configure Active Directory Certificate Services. - Deploy and manage certificates. - Configure Active Directory Lightweight Directory Services. - Configure Active Directory Federation Services. - Configure Active Dire...

Full archival course description>>

This workshop provides students with the knowledge and skills needed to use advanced data access features and techniques in the Microsoft .NET Framework and Microsoft Visual Studio 2005.

Objective :
After completing this workshop, students will be able to: - Minimize and handle database operation conflicts. - Handle large objects. - Enhance database performance. - Create managed code objects for SQL Server 2005. - Query XML by using XPath. - Transform XML by using XSLT style sheets. ...

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