Skip Ribbon Commands
Skip to main content
Microsoft Access - Introduction
Course Number:(ALTO-1539A)
Course Length:2 Day
Course Price:$795
Or Register by Phone 1-888-600-ALTO (2586)

 Upcoming Classes

TBA

 Course Description

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 Outline

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

​​​