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

Learn more about Business Productivity Online Suite

 

Microsoft Access - Advanced
 
   
Course Number:ALTO-1539C
Length:1 Day
Price:$395.00
  
Or Register by Phone 1-888-600-ALTO (2586)

 Upcoming Classes

Start DateEnd DateLocation
10/08/201010/08/2010
Alto
12/03/201012/03/2010
Alto

 Description

  
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

Error Handling
  • Error Handling in Access 
  • Basic Error Handling Syntax 
  • The Call Stack
  • Failing Gracefully 
  • Error Logging 
  • Error Events in Forms and Reports

Multi-User Programming Techniques

  • Application Architecture 
  • Splitting Applications from Data 
  • Data Integrity Overview 
  • ACE Data Integrity 
  • Resource Locking
  • Keeping Recordsets Current
  • Concurrency versus Isolation
  • Transactions

Security

  • ACE/JET Database Security 
  • Security for ACCDB Files and MDB Files
  • Users, Groups, Permissions
  • Security Wizard 
  • Microsoft Office Trust Center

Database Servers 

  • Your Database Options 
  • Configuring Access to Data Sources 
  • Tools in Access 
  • Pass-Through Queries
  • Access Projects

Optimizing Applications 

  • Designing for Performance
  • Measuring Perormance 
  • Creating Custom Ribbons

Developer Extensions and Runtime 

  • What is Developer Extensions and Runtime? 
  • Developer Extensions and Runtime Contents 
  • Access Developer Extension Differences
  • Designing for Distribution
  • Package Solution Wizard
  • What Does and Installation Routine Do?
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