Application Development with Microsoft Access 97 - Part 3

This is the final course in a three part series that will provide database programmers and developers with a foundation in application development using Microsoft Access 97.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

This course is designed for experienced database programmers and developers who want to leverage their existing development experience to learn to develop applications in Microsoft Access 97. Participants should have completed the first two courses in the series.

Objective

• Use database replication to enable synchronization within a multiuser environment.
• Describe the process of securing an application and implement security programmatically.
• Use the Setup Wizard to distribute all files required for standalone application.

Topics Include

Unit 1: Database Replication

• Match the database replication terms with their characteristics.
• Match the Microsoft Jet Replication Architecture components with their functions.
• Identify the situations in which you use database replication.
• Match the database replication topologies with their characteristics.
• Identify the changes made to a database during database replication.
• Implement database replication.
• Configure the Replication Manager.
• Identify the characteristics of the two types of synchronization.
• Synchronize the two members of a replica set.
• Sequence the steps involved in configuring the computer components for the Internet synchronization.
• Resolve a synchronization conflict when two records have different information in synchronization replicas.
• Resolve a data error that arises when synchronizing replicas in a replica set.
• Write the DAO code to convert a nonreplicated database into a replicable database.
• Write the DAO code to synchronize replicas.
• Write the DAO code to resolve a conflict that has occurred for a specific table.
• Identify the benefits of partial replication.
• Write the DAO code to create a partial replica.
• Write the DAO code to synchronize a partial replica with a Design Master.

Unit 2: Security

• Identify the advantages of implementing security in a database.
• Identify the characteristics of the two types of security available in Microsoft Access 97.
• Match the elements in the Microsoft Jet security model with their description.
• Identify the mechanism involved in storing information about a workgroup in a workgroup information file.
• Create an User account and Group account.
• Match the permissions with the tasks that they enable a user to perform.
• Assign the permissions granted to a user for a database object.
• Change the owner of a database object.
• Create a workgroup information file unique to an application.
• Create a new administrator.
• Secure an Access application.
• Identify the functions of database encryption.
• Remove security from a secured database.

Unit 3: Distributing an Application

• Identify the attributes of a run-time version of Access 97.
• Create an MDE file from an Access 97 database.
• Sequence the steps involved in creating an Access 97 run-time application.
• Create a Startup Form.
• Write the DAO code to maintain custom settings in the Windows Registry.
• Write the DAO code to set a reference to the Microsoft Remote Data Object 2.0 library.
• Identify the features of a setup program.
• Create a custom setup program.
• Add an ActiveX control to an application.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

• Application Development with Microsoft Access 97 - Part 1
• Application Development with Microsoft Access 97 - Part 2