Exclusive
Visual Studio

Building Data-Centric Business Applications with Microsoft Visual Basic 6 (VB)
(Microsoft Training Course: 1633) - 3 days - £1700 exc VAT



> Target Audience
THIS COURSE HAS NOW RETIRED. PLEASE SEE THE SUPPLEMENTARY INFORMATION FOR DETAILS OF ALTERNATIVE COURSES.
This course teaches foundational Microsoft Visual Basic programming skills in the context of building an actual application. Students use their expanding skills to build the Product Support application during the class
> Course outline
  1. Business Application Overview
  2. Connecting to a Data Source
  3. Using the ADO Recordset Object
  4. Multiuser Considerations
  5. Querying the Data Source
  6. Database Reports
  7. Beyond This Course

Supplementary InformationThis course has now retired and is no longer available. We suggest you look at Courses [[{http://www.F1Comp.Co.UK/computer_training/Microsoft_Training_Courses/Visual-Studio-2005/2541.aspx}2541: Core Data Access with Microsoft Visual Studio 2005]] and [[{http://www.F1Comp.Co.UK/computer_training/Microsoft_Training_Courses/Visual-Studio-2005/2542.aspx}2542: Advanced Data Access with Microsoft Visual Studio 2005]].
Module 1: Business Application Overview
  • Exploring the Business Problem
  • Product Support Database Platform
  • Product Support Database Design
  • Product Support Database Views
  • The User Interface
  • The Closed Requests Report
Skills
  • Define the business problem that will be solved in this course.
  • Describe client/server architecture and why this architecture was selected for the business solution created in this course.
  • Describe the database platform that forms the basis of the business solution.
  • Describe the database design that supports the business solution.
  • Describe the user interface design for the business solution.
  • Describe the report layout and features for the business solution.
top
Module 2: Connecting to a Data Source
  • Introduction to Data Access in Visual Basic
  • Using the Data Environment
  • Introduction to the ActiveX Data Objects (ADO) Object Model
  • Using the ADO Connection Object
  • Handling Database Errors
  • Introduction to Security
  • Lab: Enhancing the Application and Adding the Login Form
  • Lab: Authenticating Users
Skills
  • Compare the different ways that data is accessed from a Visual Basic application.
  • Describe the purpose of a data environment in Visual Basic.
  • Use the data environment to connect to a data source.
  • Use a Command object in a data environment to bind data to controls on a form.
  • Describe the ADO objects and their individual purposes.
  • Connect to a data source by using the ADO Connection object.
  • Use the Errors collection to handle connection errors.
  • Describe the types of security commonly used to validate a user.
top
Module 3: Using the ADO Recordset Object
  • Working with the ADO Recordset Object
  • Using SQL to Open a Recordset
  • Navigating Through a Recordset
  • Modifying Records in a Recordset
  • Implementing Data Validation
  • Lab: Creating the Requests Form
  • Lab: Working with Records
  • Lab: Implementing Security
Skills
  • Use the ADO Recordset object to retrieve data from a data source.
  • Reference fields in a recordset by using the Fields collection.
  • Open a new Recordset object by using an SQL SELECT statement.
  • Use the MoveFirst, MoveNext, MoveLast, and MovePrev methods to navigate through a recordset.
  • Use the AddNew, Edit, Update, and Delete methods of the Recordset object to modify the records in a data source.
  • Describe the need for client-side versus server-side data validation.
  • Validate data by using range checks, null data checks, length checks, and data type validation.
top
Module 4: Multiuser Considerations
  • Managing Database Connections
  • Managing Database Locking
  • Lab: Handling Locks
Skills
  • Identify the need for using a single Connection object in a data access application.
  • Describe how disconnected recordsets are used to manage database connections.
  • Use record-locking to handle collisions in a multiuser data access environment.
  • Add error-handling code to handle locking errors.
top
Module 5: Querying the Data Source
  • Using the Command Object
  • Searching and Sorting the Recordset
  • Binding Data-Bound Controls to a Recordset
  • Lab: Adding the Search Form
  • Lab: Adding the Request Tracking Form
Skills
  • Use the ADO Command object to run a query.
  • Use the ADO Command object and the Parameters collection to run a parameterized query.
  • Use the Find method to locate a record in a recordset.
  • Use the Filter property to limit the accessible records in a recordset.
  • Sort records in a recordset by using the Sort property of the Recordset object.
  • Bind a DataGrid control and a DataCombo control to a recordset.
top
Module 6: Database Reports
  • The Purpose of a Report
  • Report Features
  • Using the Microsoft Data Report Designer
  • Lab: Creating the Closed Requests Report
Skills
  • Describe the different features of a report, such as headers, details, footers, sorting, grouping, and totals.
  • Use the Microsoft Data Report designer to create a report.
  • Create a child command in the Data Environment designer and use it to build a report.
top
Module 7: Beyond This Course
  • Introduction to Enterprise Development
  • The Curriculum Tree
Skills
  • Describe the high-level architecture of an enterprise solution that uses Microsoft's enterprise development strategy.
  • Explain the terminology and concepts of Microsoft Windows 2000 Distributed interNet Applications (DNA).
  • Identify the Visual Basic programming courses in the Microsoft curriculum.
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
> Purpose
At the end of the course, students will be able to understand the business problem explored in this course and the database design that supports the business solution; describe the different ways to connect to data through the Visual Basic development environment; validate a user by using custom security; use ActiveX Data Objects (ADO) to connect to a data source, and retrieve and edit data; use various techniques to make data-access code more efficient in a multiuser environment, use the ADO Command object to run a parameterized query; use properties and methods of the Recordset object to find, filter, and sort data; create reports by using the Microsoft Data Report designer; describe how three-tier client/server architecture differs from two-tier architecture
> Supplementary Information
This course has now retired and is no longer available. We suggest you look at Courses [[{http://www.F1Comp.Co.UK/computer_training/Microsoft_Training_Courses/Visual-Studio-2005/2541.aspx}2541: Core Data Access with Microsoft Visual Studio 2005]] and [[{http://www.F1Comp.Co.UK/computer_training/Microsoft_Training_Courses/Visual-Studio-2005/2542.aspx}2542: Advanced Data Access with Microsoft Visual Studio 2005]].