Courses - Microsoft-Access-Introduction

The two-day introductory segment is a comprehensive yet selective exploration of the key features and functions of the powerful Access products. You will learn the crucial configuration steps and design techniques that make it possible to create robust, full-featured database applications without any programming. The major components in Access have dozens and sometimes even hundreds of options for the way they can be used. This course does not attempt to cover everything, rather, it concentrates on the features and functions that will make the most effective use of your time and efforts.

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)