Skip Navigation Links
Home
Development
Infrastructure
Training
CRM
SharePoint
 
Skip navigation links
Class Registration
Classes Offered
Developer Courses
Infrastructure Courses
SharePoint Courses
CRM Courses
Custom Training Solutions
Testimonials
Brochures
Class Schedule
Room Rental
Custom Training
More Information
Training Facilities
Frequently Asked Questions
Hotels
Map to Alto
Contact Us


Microsoft Access - Intermediate
 
   
Course Number:ALTO-1539B
Length:2 Day
Price:$795.00
  
Or Register by Phone 1-888-600-ALTO (2586)

 Upcoming Classes

Start DateEnd Date
04/28/201004/29/2010
06/23/201006/24/2010
08/11/201008/12/2010

 Description

  
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)
 
Sign In


Alto Consulting & Training | 7210 Metro Blvd Minneapolis, MN 55439 | phone 952.831.6604 fax 952.893.8080
Copyright © 1996-2009, and Hosted by Alto Consulting and Training