|
|
|
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 |
|
|
|
|
Exams:
-
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
|
|
