(<img height='1' width='1' border='0' src="http://www.googleadservices.com/pagead/conversion/1072619999/?value=1&label=Lead&script=0" />)
F1
About F1Course ScheduleOther ServicesSite MapContactHome

Mastering Access 97 Development

Exchange Server
Office (inc Access)
SQL Server
Visual Studio .NET
Windows
Web Development
Visual FoxPro
Programming
Business
Knowledge Management
Certification
Learning Options
Reserve a Place
No scheduled Course : Contact for Details
View Other Courses in Same Category

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
.

Exams:

  • There are no exams directly associated with this course

Price Options ex VAT:

Classroom Training
?		 Distance Learning
?		 eLearning Options
?		 Book Learning
?
£ 1750
(€2486) 		£ 995.00
(€1413) 		- No Books Supported for Course at present

Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008