Exclusive
Office

Mastering Access 97 Development
(Microsoft Training Course: 1200) - 5 days - £2640 exc VAT



> Target Audience
THIS COURSE HAS NOW RETIRED. PLEASE SEE THE SUPPLEMENTARY INFORMATION FOR DETAILS OF ALTERNATIVE COURSES.
This course is intended for developers experienced with database programming in Microsoft Access and teaches how to extend the power of their applications using the advanced features of Access Basic and Data Access Objects (DAO)
> Course outline
  1. Introduction to Visual Basic for Applications in Microsoft Access
  2. Object Programming and Accessing External Data
  3. Debugging and Error Handling
  4. Working with Record Sets
  5. Class Modules
  6. Integrating Microsoft Office Applications
  7. ActiveX Controls
  8. Dynamic-Link Libraries
  9. Replication
  10. Security
  11. Distributing an Application

Supplementary InformationThis course has now retired and is no longer available. It is possible for us to run a closed Access 2007 course for more than two people. Please call for details.
Module 1: Introduction to Visual Basic for Applications in Microsoft Access
  • Working with code
  • Procedures
  • Variables
  • Control structures
  • Getting Microsoft Visual Basic Help
Skills
  • Interpret and edit Visual Basic for Applications code.
  • Describe the difference between Sub and Function procedures.
  • Call procedures from other procedures and modules.
  • Store data in variables.
  • Create custom data types.
  • Use Microsoft Office Assistant to get Visual Basic Help.
top
Module 2: Object Programming and Accessing External Data
  • Working with objects and collections
  • Data access object model
  • Tables, fields, and indexes
  • Queries, containers, and relationships
  • Properties collection and Property object
  • Accessing external data
  • Accessing client/server applications
  • Optimizing external data performance
Skills
  • Define and work with objects and collections.
  • Describe the difference between a property and a method.
  • Identify the purpose of the DBEngine object.
  • Navigate within the DAO model.
  • Identify the two different workspaces used in Microsoft Access.
  • Programmatically create tables.
  • Manipulate Field and Index objects.
  • Programmatically create and execute queries.
  • Identify two ways to access external data.
  • Connect to an Open Database Connectivity (ODBC) data source with ODBCDirect.
  • Work with linked data in both file/ server and client/server environments.
  • Create a table in an external data source.
top
Module 3: Debugging and Error Handling
  • Types of errors
  • Using the module options
  • Debugging tools and techniques
  • Error handling
Skills
  • Set breakpoints to stop program execution.
  • Run selected portions of code.
  • Trace the program execution sequence.
  • Monitor variable values.
  • Test data and procedures in the Debug window.
  • Add and edit watch expressions.
  • Trap run-time errors.
  • Use the Err object in Microsoft Access.
  • Use the DAO Error object and Errors collection.
top
Module 4: Working with Record Sets
  • Overview of record sets
  • Working with record sets
  • Navigating records
  • Manipulating data
  • Transaction processing
Skills
  • Identify and differentiate record set types.
  • Manipulate data by using DAO.
  • Create a record set object.
  • Move through a record set.
  • Find, filter, and sort records in a record set object.
  • Edit, add, and delete records.
  • Use transaction processing.
top
Module 5: Class Modules
  • Relationship between classes and objects
  • Creating custom properties
  • Creating custom methods
  • Working with objects
  • Object Browser
Skills
  • Define and create class modules.
  • Identify the scope of a class module.
  • Create custom methods and properties.
  • Open and refer to multiple instances of a form.
  • Use Object Browser to view members of a class.
top
Module 6: Integrating Microsoft Office Applications
  • Linking and embedding
  • Automation basics
  • Microsoft Access as an Automation controller
  • Microsoft Access as an Automation server
Skills
  • Describe how Automation works.
  • Use Object Browser to view an object model.
  • Describe the purpose of an object library and how to reference an object library.
  • Control other Microsoft Office applications through the use of Automation code.
  • Control Microsoft Access from other applications through the use of Automation code.
  • Share data by controlling linked and embedded objects
top
Module 7: ActiveX Controls
  • Introduction to ActiveX controls
  • Microsoft Windows common controls
  • Registering and adding ActiveX controls
  • Working with ActiveX controls
Skills
  • Identify types of ActiveX controls.
  • Add controls to a form.
  • Define Windows common controls.
  • Use the CommonDialog control.
top
Module 8: Dynamic-Link Libraries
  • Introduction to DLLs
  • Declaring DLLs
  • Calling DLLs
  • Additional DLL information
Skills
  • Describe the purpose and advantages of DLLs.
  • Identify the different types of DLLs.
  • Use Windows API Viewer to browse DLL procedures.
  • Map C data types to Visual Basic for Applications data types.
  • Describe the purpose of the Any data type.
  • Describe the difference between the ByVal and ByRef keywords.
  • Identify the purpose of using callback procedures.
top
Module 9: Replication
  • Understanding replication
  • Replicating a database
  • Synchronization
  • Managing conflicts and errors
  • Replication using DAO
  • Partial replication
Skills
  • Define the concept of database replication.
  • Identify the role of the design master.
  • Identify the various tools that can be used for replication.
  • Synchronize data from multiple replicas.
  • Indicate the differences between direct and indirect synchronization.
  • Identify and correct database conflicts and errors.
  • Use DAO to replicate and synchronize a database.
  • Create and synchronize partial replicas.
top
Module 10: Security
  • Security basics
  • Workgroups
  • Permissions and ownership
  • Securing your database
  • Database encryption
  • Using DAO to program security
  • Removing security from a database
Skills
  • Describe the Microsoft Jet security model.
  • Differentiate between user-level and share-level security.
  • List the steps for implementing security.
  • Create a workgroup information file and a new Admin user.
  • Use Microsoft Access User-Level Security Wizard to secure a database.
  • Determine application access and level of access by adding users and groups.
  • Describe the function of database encryption.
  • Programmatically set security options.
top
Module 11: Distributing an Application
  • Microsoft Office Developer Edition
  • Attributes of run-time Microsoft Access
  • About MDE files
  • Designing run-time applications
  • Using Setup Wizard
  • Distributing ActiveX controls
  • Programming the reference object
Skills
  • Describe the contents of Microsoft Office Developer Edition.
  • Explain the essential differences between the full and run-time versions of Microsoft Access.
  • Describe the design process for creating a run-time application.
  • Use Setup Wizard in Office to create a Setup program for your custom solution.
  • Explain some of the entries that appear in the Windows registry when you distribute an application.
  • Describe the method for distributing ActiveX controls.
  • Programmatically create references for add-ins.
top
> Pre-Requisites
Mastering Access 97 Development (MOC Course No. 1200) - 5 days
  • (Print Flyer in PDF format) What is PDF?
  • Target Audience: This course is intended for developers experienced with database programming in Microsoft Access and teaches how to extend the power of their applications using the advanced features of Access Basic and Data Access Objects (DAO).
  • Pre-requisites: Before attending this course, students must have three to six months’ experience using Microsoft Access.
> Purpose
The overall aim of the course is to give the delegate a sound knowledge of programming in Access.
> Supplementary Information
This course has now retired and is no longer available. It is possible for us to run a closed Access 2007 course for more than two people. Please call for details.