Building Client/Server Applications with Microsoft Access 2000(Microsoft Training Course: 1379) - Microsoft Training Courses London South West UK

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

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

Target Audience		Pre-requisites
Purpose		Print 2 Page Flyer
Exams		Price Options

COURSE OUTLINE

Overview of Client/Server Application Design		Creating an Access Project
Creating an MSDE Database		Using Stored Procedures to Access and Modify Data
Displaying Data in Bound Forms		Creating Unbound Forms by Using ActiveX Data Objects
Displaying Disconnected Data in Unbound Forms		Distributing an Access Client/Server Application

Target Audience: 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) 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

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.

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.

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.

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.

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.

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.

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.

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.

There are no exams directly associated with this course

Price Options ex VAT:

Classroom Training ?	Distance Learning ?	eLearning Options ?	Book Learning ?
£ 1185 (€1683)	£ 674.00 (€957)	-	No Books Supported for Course at present
	Call Free on 0800 169 1890 Print 2 Page Flyer Last Modified 01 May 2008