In our Intermediate Access class you’ll learn how to use action queries, use calculated fields, adjust data types, set field properties, and perform database maintenance. You will also use input masks, use controls in forms, learn the lookup feature, work with Access and the Internet, and work further with queries and reports.

Chapter One: Creating Relational Databases

• Understanding Table Relationships
• Creating Relationships between Tables
• Enforcing Referential Integrity
• Testing Referential Integrity and Printing and Deleting Table Relationships
• Understanding Relationship Types

Chapter Two: Working with Queries

• A Quick Review
• Understanding the Different Types of Queries
• Creating a Multiple Table Query
• Creating a Calculated Field
• Working with Expressions and the Expression Builder
• Using an IIF Function
• Summarizing Groups of Records
• Display Top or Bottom Values
• Parameter Queries
• Finding Duplicate Records
• Finding Unmatched Records
• Crosstab Queries
• Delete Queries
• Append Queries
• Make-Table Queries
• Update Queries

Chapter Three: Working with Forms

• Creating a Form with AutoForm
• Modifying a Form
• Adding and Deleting Fields
• Moving and Sizing Controls
• Changing the Tab Order
• Working with Control Properties
• Control Property Reference
• Working with Form Properties
• Form and Report Property Reference
• Working with Multiple Controls
• Adding, Cutting, Copying, and Pasting Controls
• Changing a Control’s Data Source
• Creating a Calculated Control
• Changing a Control’s Default Value
• Using the Control Wizard
• Creating a Subform
• Modifying and Working with Subforms

Inquire about the MS ACCESS course now
Chicago: (312) 920-8822
Oak Brook: (630) 705-9999