Courses - Microsoft-Access-Intermediate

The two-day intermediate segment is intended for those already familiar with basic Access operations and are ready to make the transition from Access user to application developer. You will learn how to directly control and manipulate Access from behind the scenes to create queries, data entry forms and reports that function precisely in the manner you require. Access is far more powerful and flexible than it might initially appear, making Access suitable for every kind of database application.

Course Outlines

Key Concept

Access is a vast product - you need to learn the 'good stuff' and get started with the right tools and efficient techniques for creating sophisticated applications without programming.

Overview of Access and the Jet Database Engine

The Importance of Database Design
Table Design
Field Data Types
Important Field Properties
Maintaining Data Integrity
Using Datasheets

Query Fundamentals

Basic SELECT Queries
Filtering and Sorting
Calculated Columns
Joining Multiple Tables
Insert, Update and Delete Queries

Form Design

Controls and Properties
Single Record Forms
Continuous Forms
Main/Sub Forms
Forms

Importing, Exporting and Attaching Data

Text Files
Spreadsheets
FoxPro/dBase and Others
Server-based Data

Report Design

Using Groups and Totals
Controlling Page Breaks and Grouping
Calculations
Subtotals, Grand Totals, Running Sums

Automating Tasks with Macros

Startup Housekeeping
Switchboards
Multi-Step Processes

Or Register by Phone 1-888-600-ALTO (2586)