Skills measured by exam 70-175 |
Course 1013 |
Course 1016 |
Course 1298 |
Developing the Conceptual and Logical Design |
Given a conceptual design, apply the principles of modular design to derive the components and services of the logical design. |
¤ |
¤ |
• |
Deriving the Physical Design |
Assess the potential impact of the logical design on performance, maintainability, extensibility, scalability, availability, and security. |
|
¤ |
¤ |
Design Visual Basic components to access data from a database in a multi-tier application. |
¤ |
¤ |
• |
Design 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).
- Install MTS.
- Set up security on a system package.
|
|
• |
¤ |
Configure a client computer to use an MTS component.
- Create packages that install or update MTS components on a client computer.
|
|
• |
• |
Creating User Services |
Implement navigational design.
- Dynamically modify the appearance of a menu.
- Add a pop-up menu to an application.
- Create an application that adds and deletes menus at run time.
- Add controls to forms.
- Set properties for controls.
- Assign code to a control to respond to an event.
|
¤ |
¤ |
¤ |
Create data input forms and dialog boxes.
- Display and manipulate data by using custom controls. Controls include TreeView, ListView, ImageList, Toolbar, and StatusBar.
- Create an application that adds and deletes controls at run time.
- Use the Controls collection to manipulate controls at run time.
- Use the Forms collection to manipulate forms at run time.
|
¤ |
|
|
Write code that validates user input.
- Create an application that verifies data entered at the field level and the form level by a user.
- Create an application that enables or disables controls based on input in fields.
|
• |
|
|
Write code that processes data entered on a form.
- Given 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.
- Create a Visual Basic client application that uses a COM component.
- Create 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.
- Set appropriate properties to enable user assistance. Help properties include HelpFile, HelpContextID, and WhatsThisHelp.
- Create HTML Help for an application.
- Implement messages from a server component to a user interface.
|
¤ |
|
|
Implement error handling for the user interface in distributed applications.
- Identify and trap run-time errors.
- Handle inline errors.
- Determine 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.
- Create an ActiveX control that exposes properties.
- Use control events to save and load persistent properties.
- Test and debug an ActiveX control.
- Create and enable property pages for an ActiveX control.
- Enable the data-binding capabilities of an ActiveX control.
- Create an ActiveX control that is a data source.
|
• |
|
|
Create an active document.
- Use code within an active document to interact with a container application.
- Navigate 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.
- Use the Package and Deployment Wizard to create a package.
- Import existing packages.
- Assign names to packages.
- Assign security to packages.
|
|
• |
¤ |
Add components to an MTS package.
- Set transactional properties of components.
- Set security properties of components.
|
|
• |
• |
Use role-based security to limit use of an MTS package to specific users.
- Create roles.
- Assign roles to components or component interfaces.
- Add users to roles.
|
|
• |
¤ |
Compile a project with class modules into a COM component.
- Implement an object model within a COM component.
- Set 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.
- Use a stored procedure to execute a statement on a database.
- Use 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.
- Use the Immediate window to check or change values.
- Use the Locals window to check or change values.
|
¤ |
|
|
Implement project groups to support the development and debugging processes.
- Debug DLLs in process.
- Test and debug a control in process.
|
• |
¤ |
|
Given a scenario, define the scope of a watch variable. |
¤ |
|
|
Deploying an Application |
Use the Package and Deployment Wizard to create a setup program that installs a distributed application, registers the COM components, and allows for uninstall. |
• |
|
¤ |
Register a component that implements DCOM. |
|
|
|
Configure DCOM on a client computer and on a server computer. |
|
|
|
Plan and implement floppy disk-based deployment or compact disc-based deployment for a distributed application. |
|
|
|
Plan and implement Web-based deployment for a distributed application. |
|
|
¤ |
Plan and implement network-based deployment for a distributed application. |
|
|
|
Maintaining and Supporting an Application |
Implement load balancing. |
|
|
|
Fix errors, and take measures to prevent future errors. |
|
|
|
Deploy application updates for distributed applications. |
|
|
|