Boot Camp Pricing
Windows 2000 MCSE | NT 4.0 MCSE | MCSE Classes | MCSE FAQs | MCSE Exam Info

70-156:

Designing and Implementing Desktop Applications with Microsoft Visual FoxPro 6.0

Exam 70-156 is available as of February 17, 2000.

Microsoft Certification Path

When you pass the Designing and Implementing Desktop Applications with Microsoft Visual FoxPro 6.0 exam, you achieve Microsoft Certified Professional (MCP) status. You also earn core or elective credit toward Microsoft Certified Solution Developer (MCSD) certification.

Skills Being Measured

This certification exam measures your ability to design and implement desktop application solutions by using Microsoft Visual FoxPro version 6.0. Before taking the exam, you should be proficient in the job skills listed below.

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.

Developing a Logical Data Model

Group data into entities by applying normalization rules.

• Use the primary key.

Specify the relationships between entities.

Choose the foreign key that will enforce a relationship between entities and ensure referential integrity.

Identify the business rules that relate to data integrity.

Incorporate business rules and constraints into the data model.

Given a situation, decide whether denormalization is appropriate.

Deriving the Physical Design

Assess the potential impact of the logical design on performance, maintainability, extensibility, and availability.

Design the Visual FoxPro interface to access data from a database.

Design the properties and methods of the interface.

Design class libraries. Considerations include inheritance, encapsulation, containership, delegation, and polymorphism.

Establishing the Development Environment

Establish the environment for source-code version control.

Install and configure Visual FoxPro for developing desktop applications.

Creating User Services

Implement navigational design.

• Create a menu.
• Add a shortcut menu to an application.
• Add controls to forms.
• Set properties for controls.
• Assign code to a control to respond to an event.
• Create a toolbar.

Create and manage data input forms and dialog boxes.

• Display, manipulate, and bind data by using controls.
• Add, delete, and manipulate controls at run time.
• Use the Forms collection to manipulate forms at run time.
• Given a scenario, add code to the appropriate form event. Events include Init, Destroy, Load, Unload, QueryUnload, Activate, and Deactivate.

Validate user input. Considerations include single-tier, two-tier, and n-tier applications.

Write code that processes data entered on a form.

Add a Microsoft ActiveX control to a form or other container to manipulate data. Controls include TreeView, ListView, ImageList, and Web Browser controls.

Provide a personalized interface for users that is based on user profiles or group membership.

Instantiate, invoke, and manipulate a COM component. Considerations include office automation.

Implement online user assistance in a desktop application.

• Set appropriate properties to enable user assistance. Help contents include
• HelpFile, HelpContextID, and WhatsThisHelp.
• Create HTML Help for an application.

Implement error handling for the user interface in desktop applications.

• Identify and trap run-time errors.
• Handle inline errors.
• Notify users of errors.

Extend functionality through the Windows API.

Create and manage reports.

Creating and Managing COM Components

Create a COM component that implements business rules or logic.

Create a COM component that interacts with other components.

Add error handling to a COM component.

Log errors into an error log for error handling and debugging.

Use the Component Gallery to manage components.

Register and unregister a COM component.

Creating Data Services

Access and manipulate data by using ADO and ODBC.

Access and manipulate data by using Visual FoxPro native data handling and querying capabilities, including local views.

Access and manipulate data by using SQL pass-through.

Access and manipulate data by using remote views.

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.

Write SQL statements that create views.

Use appropriate locking and buffering strategies to ensure data integrity. Strategies include pessimistic, optimistic, row, and table.

Create and manipulate Visual FoxPro stored procedures.

Create triggers that implement rules.

Creating a Physical Database

Programmatically create and maintain Visual FoxPro databases.

Create databases and database tables that enforce data integrity and referential integrity. Create and maintain indexes. Considerations include optimization (via Rushmore), programmatic, and visual.

Testing and Debugging the Solution

Determine appropriate debugging techniques.

Identify and describe the elements of a test plan. Elements include beta testing, regression testing, unit testing, integration testing, and stress testing.

Given a scenario, select the appropriate build options.

Use conditional compilation in an application.

Monitor the values of expressions and variables by using the Debug window.

• Use the Watch window to check or change values.
• Use the Locals window to check or change values.
• Use the Call Stack window to find bugs in an application.
• Use asserts in an application.

Use the Coverage Profiler to identify performance bottlenecks and code coverage.

Use event tracking to determine the order of events.

Set a breakpoint to debug an application.

Deploying an Application

Use the Setup Wizard to create a setup program that installs a desktop application, registers the COM components, and allows for uninstall.

Plan and implement floppy disk-based deployment or compact disc-based deployment for a desktop application.

Plan and implement Web-based deployment for a desktop application.

Plan and implement network-based deployment for a desktop application.

Maintaining and Supporting an Application

Plan for and implement disaster recovery procedures.

Fix errors, and take measures to prevent future errors.

Maintain anomaly logs.

Deploy application updates for desktop applications.

Home | Technical Schedule | Application Classes | Class Outlines | MCSE, MCDBA, MCSD Training | Microsoft .NET Programming | Cisco Classes | Linux, Unix, AIX | CompTIA Certification | Webmaster Training | Pricing | Locations | Financing | E-mail Us