Given a business scenario, identify which architecture type is appropriate. Architecture types include monolithic and client/server.
	Identify which technologies are appropriate for implementation of a given Office 2000 solution. Microsoft Windows NT Server technologies such as Internet Information Server and Index Server proprietary technologies technology environment of the company, both current and planned selection of development tools type of solution, such as enterprise, distributed, centralized, and collaborative
	Choose a data storage architecture. JET SQL public folders in Microsoft Outlook Microsoft Exchange
	Test the feasibility of a proposed technical architecture. Demonstrate that business requirements are met. Demonstrate that use-case scenarios are met. Demonstrate that existing technology constraints are met. Assess the impact of shortfalls in meeting requirements.
	Develop appropriate deployment strategy.

 

	Construct a conceptual design. Considerations include scenarios, context, workflow process, task sequence, and physical environment models.
	Given a conceptual design, apply the principles of modular design to derive the components and services of the logical design.
	Incorporate business rules into object design.
	Assess the potential impact of the logical design on performance, maintainability, extensibility, scalability, availability, and security.
	Assess the financial impact of the solution. total cost of ownership (TCO) return on investment (ROI)
	Establish schedule and deployment tools for implementation of an Office 2000 solution. CD-ROM floppy disk Internet with CAB files Package & Deployment Wizard Microsoft Systems Management Server

 

	Identify the logical sequence of flow for the user interface for a given Office 2000 solution.
	Identify input validation procedures that should be integrated into the user interface.
	Evaluate methods of providing online user assistance. Office Assistant status bars ToolTips Help files
	Construct a prototype user interface that is based on business requirements, user interface guidelines, and the organization's standards.
	Establish the appropriate type of output. printed material HTML screen disk data exported to other applications

 

Assess the potential impact of the physical design on performance, maintainability, extensibility, scalability, availability, and security.

 

	Establish the environment for source-code version control. location data environments development tools
	Install the development tools.
	Install and configure Microsoft Data Engine (MSDE).
	Identify where code should be stored. documents templates COM add-ins

 

	Implement the navigation for the user interface. Create toolbars, menus, and pop-up menus by using the CommandBars object model. Create a command bar that calls custom Visual Basic for Applications procedures by using the shared object model.
	Create data input forms, dialog boxes, and wizards.
	Validate user input.
	Process user input from a form or a dialog box.
	Use a Microsoft ActiveX control on the user interface. The user interface can include user forms and Office 2000 documents.
	Incorporate existing code, such as templates and wizards.
	Provide a personalized interface for users that is based on user profiles or group membership.
	Instantiate and invoke a COM component. Microsoft Word Microsoft Excel Microsoft Access Microsoft PowerPoint Microsoft FrontPage Microsoft Outlook Office 2000 shared components
	Implement online user assistance in an Office 2000 application.
	Implement error handling in the user interface.
	Create a Web page that includes tables, graphics, and animation.
	Customize the Office Assistant by using the shared object model. Create balloons. Respond to user input. Use the WindowsInstaller object library to check and configure Office 2000 components.

 

	Create a COM add-in that implements business rules or logic. location deployment tools deployment methods
	Add error handling.
	Apply a digital signature to a COM add-in.
	Debug a COM add-in.
	Register a COM add-in.
	Respond to events in a COM add-in.

 

Access and manipulate a data source by using ADO.

 

Use the debugging tools to debug your solution. Locals window Immediate window call stack breakpoints Watch window

 

	Create a setup program that installs an application, registers the COM components, allows for an application to be uninstalled, and redistributes a database engine.
	Use CAB files to package and distribute an Office 2000 solution.
	Plan floppy-disk-based deployment or compact-disc-based deployment for an application.
	Plan network-based deployment for an Office 2000 solution.
	Secure and apply a digital signature to your project.

 

	Publish and distribute Web content and components to a Web site.
	Establish mechanisms for posting content on a Web site.

 

	Fix errors, and take measures to prevent future errors.
	Deploy Office 2000 solution updates.

 

	Create and modify a Word document and its contents by using the Word object model. Create a new Word document based on an existing template by using the Word object model. Define an area of a document by using the Range object. Locate the contents of the selected region of the document by using the Selection object. Redefine an existing Range object by using the Move methods or the Collapse method. Use AutoText to define or insert recyclable text in a document.
	Add navigational structure to a Word document. Navigational elements include tables of contents, bookmarks, hyperlinks, captions, and cross-references. Add hyperlinks to a Word document by using the Word object model. Dynamically add a table of contents or index entries to a Word document by using the Word object model. Add bookmarks to identify a specific location in a document. Use a bookmark to insert data at a specific location in a document.
	Add data to a Word document by using the Word object model. Data sources include databases, spreadsheets, Web pages, and application memory. Add data to a table by using the Word object model. Add data to a field. Insert data from another Office 2000 application into a Word document.
	Prepare documents for distribution by using the Word object model. Connect a data source to a mail-merge master document by using the Word object model. Insert fields into a mail-merge master document by using the Word object model. Handle missing data in a mail merge by using the Word object model. Print documents by using the Word object model. Publish a Word document to a Web server in HTML. Route a Word document by using the Word object model. Routing methods include e-mail and fax.
	Use the Word event model to react to user or system events in Visual Basic for Applications code. application events document events template events
	Use Word linguistic functions in Visual Basic for Applications code. spelling checker thesaurus

 

	Create and modify a workbook or worksheet and its contents by using the Excel object model. Create a new workbook or worksheet by using the Excel object model. Insert data into a range of cells by using the Excel object model. Create, use, or specify a reference to a cell or region of cells by using the Excel object model. Format data by using the Excel object model. Add formulas to a worksheet by using the Excel object model.
	Analyze the data in your Excel workbook. Create or modify a pivot table on an Excel worksheet. Create or modify a chart by using the Excel object model.
	Insert external data into a worksheet. Data sources include databases, spreadsheets, Web pages, and application memory. Insert a Web query. Run a new or saved query. Import a text file. Define an OLAP cube.
	Use the Excel event model to react to user or system events in Visual Basic for Applications code. application events workbook events worksheet events Before events
	Use Excel worksheet formulas in Visual Basic for Applications code.
	Prepare a workbook for distribution by using the Excel object model. Publish an Excel worksheet to a Web server in HTML. Publish an Excel worksheet by using the Office 2000 Web components. Components include worksheets, pivot charts, pivot tables, and data control. Route a finished worksheet by using the Excel object model. Print a finished worksheet by using the Excel object model.