Dale Rainwater Consulting
MCP:  Visual Basic 6.0 Distributed

Home Services Experience Certifications Skills Training About Us Contact Information Site Map

 

Description

A Microsoft Certified Professional (MCP) in Visual Basic 6.0 Distributed Application Design and Implementation has the ability to design and implement distributed or enterprise application solutions by using Microsoft Visual Basic 6.0 and is required to successfully complete Microsoft Exam 70-175, Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0.  The exam objectives are listed below.

The Microsoft Certified Solution Developer (MCSD) certification track for Visual Basic 6.0 requires completion of four Microsoft Certified Professional (MCP) exams comprised of three core exams and one elective exam.  The Visual Basic (VB) Distributed Exam 70-175 is a core exam.

Currently, target markets of Dale Rainwater Consulting are the geographical regions of New York City, NY and Northwest Arkansas.

Exam Content / Objectives

(Note: Click blue diamonds below for details, not all diamonds have details)

 

Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0

 

Developing the Conceptual and Logical Design

 
bulletGiven a conceptual design, apply the principles of modular design to derive the components and services of the logical design.

 

Deriving the Physical Design

 
bulletAssess the potential impact of the logical design on performance, maintainability, extensibility, scalability, availability, and security.
bulletDesign Visual Basic components to access data from a database in a multi-tier application.
bulletDesign the properties, methods, and events of components.

 

Establishing the Development Environment

 
Establish the environment for source-code version control.
Install and configure Visual Basic for developing distributed applications.
Configure a server computer to run Microsoft Transaction Server (MTS).
bulletInstall MTS.
bulletSet up security on a system package.
Configure a client computer to use an MTS component.
bulletCreate packages that install or update MTS components on a client computer.

 

Creating User Services

 
Implement navigational design.
bulletDynamically modify the appearance of a menu.
bulletAdd a pop-up menu to an application.
bulletCreate an application that adds and deletes menus at run time.
bulletAdd controls to forms.
bulletSet properties for controls.
bulletAssign code to a control to respond to an event.
Create data input forms and dialog boxes.
bulletDisplay and manipulate data by using custom controls. Controls include TreeView, ListView, ImageList, Toolbar, and StatusBar.
bulletCreate an application that adds and deletes controls at run time.
bulletUse the Controls collection to manipulate controls at run time.
bulletUse the Forms collection to manipulate forms at run time.
Write code that validates user input.
bulletCreate an application that verifies data entered at the field level and the form level by a user.
bulletCreate an application that enables or disables controls based on input in fields.
Write code that processes data entered on a form.
bulletGiven a scenario, add code to the appropriate form event. Events include Initialize, Terminate, Load, Unload, QueryUnload, Activate, and Deactivate.
Add an ActiveX control to the toolbox.
Create dynamic Web pages by using Active Server Pages (ASP) and webclasses.
Create a Web page by using the DHTML Page Designer to dynamically change attributes of elements, change content, change styles, and position elements.
Use data binding to display and manipulate data from a data source.
Instantiate and invoke a COM component.
bulletCreate a Visual Basic client application that uses a COM component.
bulletCreate a Visual Basic application that handles events from a COM component.
Create call-back procedures to enable asynchronous processing between COM components and Visual Basic client applications.
Implement online user assistance in a distributed application.
bulletSet appropriate properties to enable user assistance. Help properties include HelpFile, HelpContextID, and WhatsThisHelp.
bulletCreate HTML Help for an application.
bulletImplement messages from a server component to a user interface.
Implement error handling for the user interface in distributed applications.
bulletIdentify and trap run-time errors.
bulletHandle inline errors.
bulletDetermine how to send error information from a COM component to a client computer.
Use an active document to present information within a Web browser.

 

Creating and Managing COM Components

 
Create a COM component that implements business rules or logic. Components include DLLs, ActiveX controls, and active documents.
Create ActiveX controls.
bulletCreate an ActiveX control that exposes properties.
bulletUse control events to save and load persistent properties.
bulletTest and debug an ActiveX control.
bulletCreate and enable property pages for an ActiveX control.
bulletEnable the data binding capabilities of an ActiveX control.
bulletCreate an ActiveX control that is a data source.
Create an active document.
bulletUse code within an active document to interact with a container application.
bulletNavigate to other active documents.
Design and create components that will be used with MTS.
Debug Visual Basic code that uses objects from a COM component.
Choose the appropriate threading model for a COM component.
Create a package by using the MTS Explorer.
bulletUse the Package and Deployment Wizard to create a package.
bulletImport existing packages.
bulletAssign names to packages.
bulletAssign security to packages.
Add components to an MTS package.
bulletSet transactional properties of components.
bulletSet security properties of components.
Use role-based security to limit use of an MTS package to specific users.
bulletCreate roles.
bulletAssign roles to components or component interfaces.
bulletAdd users to roles.
Compile a project with class modules into a COM component.
bulletImplement an object model within a COM component.
bulletSet properties to control the instancing of a class within a COM component.
Use Visual Component Manager to manage components.
Register and unregister a COM component.

 

Creating Data Services

 
Access and manipulate a data source by using ADO and the ADO Data control.
Access and manipulate data by using the Execute Direct model.
Access and manipulate data by using the Prepare/Execute model.
Access and manipulate data by using the Stored Procedures model.
bulletUse a stored procedure to execute a statement on a database.
bulletUse a stored procedure to return records to a Visual Basic application.
Retrieve and manipulate data by using different cursor locations. Cursor locations include client-side and server-side.
Retrieve and manipulate data by using different cursor types. Cursor types include forward-only, static, dynamic, and keyset.
Use the ADO Errors collection to handle database errors.
Manage database transactions to ensure data consistency and recoverability.
Write SQL statements that retrieve and modify data.
Write SQL statements that use joins to combine data from multiple tables.
Use appropriate locking strategies to ensure data integrity. Locking strategies include read-only, pessimistic, optimistic, and batch optimistic.

 

Testing the Solution

 
Given a scenario, select the appropriate compiler options.
Control an application by using conditional compilation.
Set watch expressions during program execution.
Monitor the values of expressions and variables by using the Immediate window.
bulletUse the Immediate window to check or change values.
bulletUse the Locals window to check or change values.
Implement project groups to support the development and debugging processes.
bulletDebug DLLs in process.
bulletTest and debug a control in process.
Given a scenario, define the scope of a watch variable.

 

Deploying an Application

 
bulletUse the Package and Deployment Wizard to create a setup program that installs a distributed application, registers the COM components, and allows for uninstall.
bulletRegister a component that implements DCOM.
bulletConfigure DCOM on a client computer and on a server computer.
bulletPlan and implement floppy disk-based deployment or compact disc-based deployment for a distributed application.
bulletPlan and implement Web-based deployment for a distributed application.
bulletPlan and implement network-based deployment for a distributed application.

 

Maintaining and Supporting an Application

 
bulletImplement load balancing.
bulletFix errors, and take measures to prevent future errors.
bulletDeploy application updates for distributed applications.

 

 

 

 

 

Home ] Services ] Experience ] Certifications ] Skills ] Training ] About Us ] Contact Information ] Site Map ]