Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
ADVANCED DEVELOPMENT IN MICROSOFT ACCESS
MS Access Training Overview

Level 3 shows you how to move from creating simple applications to creating enterprise-wide, robust applications for multiple users. You’ll learn how to debug and handle errors, how to use ADO to work with data programmatically, how to secure your data with Microsoft Access security, and how to scale up to an Access client/server solution.

MS Access Training Prerequisites

Programming in MS Access – Level 2.

MS Access Training Audience

Computer users needing to work in Microsoft Access 2002/2003.

MS Access Training Course Duration

3 Days

MS Access Training Course outline

Mastering Debugging

  • Why Do You Need Debugging?
  • Getting Started with Debugging
  • Stepping Through Code
  • Evaluating Expressions
  • Tips on Effective Debugging
Taking Advantage of Queries
  • Understanding Joins
  • Action Queries
  • Access SQL
Managing Data with ADO
  • Introducing ActiveX Data Objects
  • Retrieving Data with ADO
  • Searching for Data in a Recordset
  • Updating Data with ADO
Using Error Handling to Bullet-Proof Your Code
  • Handling Runtime Errors
  • The Error Handling Standard
  • Taking a Closer Look
  • Who Handles Errors?
Designing Multiuser Applications
  • Multiuser Architectures
  • Locking
  • Keeping Recordsets Current
  • Transaction Processing
Exploring Replication
  • Replication Basics
  • Replicating a Database
  • Changes Access Makes to a Database When You Replicate It
  • Synchronizing Replicas
  • Conflict Management
  • Partial Replication
Automating Office Applications
  • What Is Automation?
  • Working with Other Applications
  • Example: Building an Excel Chart
  • MailMerge with Word
  • Access as an Automation Server
Securing Your Applications
  • Choosing the Right Security System
  • Workgroups
  • Users and Groups
  • Permissions
  • Using the Security Wizard to Properly Secure Your Database
Building Access Data Projects
  • Introduction to Access Projects
  • Creating a New Project
  • Creating SQL Server Tables
  • Creating SQL Server Database Diagrams
  • Creating SQL Server Views
  • Creating SQL Server Stored Procedures
Developing Client/Server Applications with Access
  • Introduction to Client/Server
  • MDB vs. ADP
  • Designing Client/Server Applications
  • Designing MDB Client/Server Applications
  • Designing ADP Client/Server Applications
Deploying Access Applications
  • The Finishing Touches
  • Managing VBA Code
  • Introducing the Access Runtime Version
  • Developing Runtime Applications
  • Deploying Access Applications
Appendix A: The Reddick VBA Naming Conventions, Version 6.0


Appendix B: Useful VBA Functions


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy