Courses - Microsoft-Access-Advanced

The one-day advanced segment is an absolutely intense day intended for experienced Access developers who want to fine-tune their applications to exploit the many powerful features and functions built into Access. Access applications have numerous options for dealing with multiple users: different forms of security, concurrency and isolation can be combined to solve any conceivable design problem. Access can be extended by incorporating server-based data sources, ActiveX controls and servers into your applications.

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)