Exclusive
Office

Building Client/Server Applications with Microsoft Access 2000
(Microsoft Training Course: 1379) - 3 days - £1700 exc VAT



> Target Audience
THIS COURSE HAS NOW RETIRED. PLEASE SEE THE SUPPLEMENTARY INFORMATION FOR DETAILS OF ALTERNATIVE COURSES.
This course will teach Microsoft Access 2000 developers how to design, develop, and deploy a client/server database application by using Access 2000 and Microsoft Data Engine (MSDE)
> Course outline
  1. Overview of Client/Server Application Design
  2. Creating an Access Project
  3. Creating an MSDE Database
  4. Using Stored Procedures to Access and Modify Data
  5. Displaying Data in Bound Forms
  6. Creating Unbound Forms by Using ActiveX Data Objects
  7. Displaying Disconnected Data in Unbound Forms
  8. Distributing an Access Client/Server 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: Overview of Client/Server Application Design
  • Topics:
  • Design life cycle
  • Application architectures
  • Design considerations
  • Lab scenario
  • Lab:
  • Exploring the Hanson Brothers MDB
Skills
  • Students will be able to:
  • Diagram the different types of application architectures.
  • Identify the reasons for selecting an application architecture.
  • Identify the considerations for designing a client/server application.
  • Describe the benefits of using transactions.
  • List the issues involved with multiple users in a client/server environment.
top
Module 2: Creating an Access Project
  • Topics:
  • Access as a client/server development environment
  • Creating an Access project
  • Upsizing an Access database (MDB)
  • Lab:
  • Upsizing an MDB
Skills
  • Students will be able to:
  • Determine whether to use an MDB or an Access project (ADP).
  • Determine whether to use a Jet database engine, MSDE, or Microsoft SQL Server™ database.
  • Install MSDE.
  • List the elements in MSDE.
  • Create an Access project.
  • Upsize an MDB file to an ADP file and an MSDE database by using the Upsizing Wizard.
top
Module 3: Creating an MSDE Database
  • Topics:
  • Login and user accounts
  • Creating tables
  • Creating views
  • Creating triggers
Skills
  • Students will be able to:
  • Create login and database user accounts.
  • Create and modify tables in an MSDE database.
  • Create and modify views.
  • Create and modify triggers.
top
Module 4: Using Stored Procedures to Access and Modify Data
  • Topics:
  • Introduction to stored procedures
  • Creating stored procedures
  • Using parameters in stored procedures
  • Modifying records by using stored procedures
  • Advanced processing in stored procedures
  • Lab:
  • Creating stored procedures
Skills
  • Students will be able to:
  • Create a stored procedure that returns a recordset.
  • Run a stored procedure.
  • Create a stored procedure that uses input and output parameters.
  • Create a stored procedure that uses conditional execution.
  • Implement transactions in stored procedures.
  • Return multiple recordsets from a stored procedure.
  • Handle errors in stored procedures.
top
Module 5: Displaying Data in Bound Forms
  • Topics:
  • Binding to data
  • Using bound forms
  • Using bound list boxes and combo boxes
  • Lab:
  • Binding forms to stored procedures
Skills
  • Students will be able to:
  • Display data from stored procedures in bound forms.
  • Use controls that are bound to stored procedures.
  • Pass parameters to stored procedures.
top
Module 6: Creating Unbound Forms by Using ActiveX Data Objects
  • Topics:
  • Overview of unbound forms
  • Accessing data
  • Using the command object
  • Navigating through recordsets
  • Displaying data in unbound list boxes and combo boxes
  • Modifying data in a database
  • Lab:
  • Using ActiveX Data Objects
Skills
  • Students will be able to:
  • Decide whether to use bound or unbound forms in a given scenario.
  • Create an ADO Connection object and open a connection to a data source.
  • Create an ADO Command object to execute a stored procedure.
  • Create an ADO Recordset object and navigate through a recordset.
  • Use ADO objects to access and manipulate data.
top
Module 7: Displaying Disconnected Data in Unbound Forms
  • Topics:
  • Connected vs. disconnected recordsets
  • Creating a disconnected recordset
  • Saving changes from a disconnected recordset
  • Handling batch update errors
  • Best practices for client/server applications
  • Lab:
  • Using disconnected recordsets
Skills
  • Students will be able to:
  • Explain the reasons for using disconnected recordsets in a client/server application.
  • Use a disconnected ADO recordset to access and modify data.
  • Handle batch update errors.
top
Module 8: Distributing an Access Client/Server Application
  • Topics:
  • Deploying applications
  • Migrating to SQL Server
  • Distribution issues
  • Lab:
  • Creating an ATL control
Skills
  • Students will be able to:
  • Create an .ADE file to help protect elements in an ADP.
  • Use the Package and Deployment Wizard, included in Microsoft Office Developer, to create a Setup program for your custom solution.
  • Explain how to migrate an MSDE database to a SQL Server database.
  • List distribution factors to consider in deploying Access 2000 client/server applications.
top
> Pre-Requisites
This course assumes that the student has the skills to perform the following:
  • Design a relational database.
  • Design a workgroup Access application.
  • Use Access to:
  • Create a database with multiple tables, forms, and reports.
  • Create queries.
  • Write Structured Query Language (SQL) SELECT, UPDATE, INSERT, and DELETE statements that retrieve and modify records in a database.
  • Use an event-driven programming language, such as Microsoft Visual Basic® to:
  • Create functions and subprocedures.
  • Declare variables.
  • Create loops and conditional statements.
  • Create event procedures.
  • Add error handling to procedures.
  • Recommended Courses:
  • Course 1539, Mastering Database Fundamentals Using Microsoft Access 2000.
  • Course 1300, Mastering Microsoft Access 2000 Programming.
  • The course materials, lectures, and lab exercises are in English. To benefit fully from our instruction, students need an understanding of the English language and completion of the prerequisites.
> Purpose
At the end of the course, students will be able to:Design a client/server application that uses Access 2000 and MSDE. Move an Access application from a Microsoft Jet database to an MSDE database. Use the Access data tools to create MSDE elements such as tables, relationships, stored procedures, triggers, views, and data diagrams. Create stored procedures that add, manipulate, and delete data in MSDE tables. Create forms to display recordsets returned from stored procedures. Create unbound forms by using Microsoft ActiveX® Data Objects (ADO). Create unbound forms to display and manipulate disconnected recordsets. Deploy a client/server Access application
> 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.