Exclusive
Office

Mastering Microsoft Office 2000 Solution Development
(Microsoft Training Course: 1301) - 5 days - £2640 exc VAT



> Target Audience
THIS COURSE HAS NOW RETIRED. PLEASE SEE THE SUPPLEMENTARY INFORMATION FOR DETAILS OF ALTERNATIVE COURSES.
This course will teach developers how to build solutions that access data and automate business processes by using Microsoft Office 2000.
> Course outline
  1. Designing Custom Solutions
  2. Using Visual Basic Editor
  3. Applying Visual Basic-Related Skills in Office 2000
  4. Retrieving Data in an Office Solution
  5. Building Documents in Microsoft Excel
  6. Analysing and Presenting Data in Microsoft Excel
  7. Building Documents in Microsoft Word
  8. Expanding Your Office Solution
  9. Advanced Issues in Office Development
  10. Using FrontPage 2000

Supplementary InformationThis course has now retired and is no longer available. It is possible for us to run a closed Office 2007 course for more than two people. Please call for details.
Module 1: Designing Custom Solutions
  • Working with Office 2000
  • Developing an Office solution
  • Overview of the course
  • Lab 1.1 Viewing the lab solution
Skills
  • Identify the advantages that Visual Basic for Applications provides to developers.
  • Identify the ways in which you can present data from Office applications in hypertext markup language (HTML) pages.
  • Identify the additional features in Office Developer that help developers build solutions.
  • Identify the types of solutions that you can build in Office 2000.
  • Identify the three roles Office 2000 plays in solution development.
  • List the options developers can choose from to deploy their Office solutions.
top
Module 2: Using Visual Basic Editor
  • Where code is stored
  • Working with Visual Basic Editor
  • Writing and running code
  • Debugging
  • Lab 2.1 Using Visual Basic Editor
Skills
  • Choose the best location to store code in an Office solution.
  • Describe how Visual Basic for Applications projects relate to Office documents.
  • List the elements that you can include in a project, and describe the purpose of each element.
  • Record a simple macro in Microsoft Excel and then view, modify, and run the macro code by using Visual Basic Editor.
  • Insert a new module or a user form into a project.
  • Insert a Sub or Function procedure into a module.
  • Use breakpoints, watch expressions, and step options to find and fix run-time errors and errors in programming logic.
top
Module 3: Applying Visual Basic-Related Skills in Office 2000
  • Visual Basic syntax review
  • Using the Office object models
  • Working with forms
  • Customizing menus and toolbars
  • Lab 3.1 Building the user interface
Skills
  • Declare variables that have the appropriate scope level for the procedures that will use them.
  • Write code that uses decision control and looping statements to control program execution.
  • Describe the purposes and benefits of using an object model.
  • List and describe the objects that are members of the shared object model in Office 2000.
  • Choose whether to declare object variables by using early binding or late binding.
  • Build a form that incorporates standard controls and uses the properties and methods of these controls in code.
  • Write code that responds to form and control events.
  • Write code that validates user input in a form.
  • Write code that hides or unloads a form based on user actions.
  • Use the CommandBars collection to create a toolbar button and a menu item that invokes a procedure when clicked.
top
Module 4: Retrieving Data in an Office Solution
  • The role of data in an Office solution
  • Using ADO
  • Retrieving data from a data source
  • Building a query
  • Handling data access errors
  • Lab 4.1 Retrieving data in an Office solution
Skills
  • Choose the best location for data in an Office solution.
  • Choose the Microsoft Office applications best suited for working with data.
  • List the major components of the ADO object model.
  • Connect to a data source by using ADO.
  • Use an ADO Recordset object to retrieve and manipulate data.
  • Use the Simple Query wizard in Microsoft Access to build SQL statements that retrieve selected data.
  • Run a SQL statement that returns an ADO Recordset object.
  • Explain how to handle some common errors by using ADO.
top
Module 5: Building Documents in Microsoft Excel
  • Overview
  • Working with the Microsoft Excel application
  • Working with workbooks
  • Working with worksheets
  • Returning a Range object
  • Working with a Range object
  • Lab 5.1 Building the Sales Reports workbook
Skills
  • Describe the capabilities of the Microsoft Excel object model.
  • Programmatically create and save a new workbook.
  • Programmatically add a worksheet to a workbook and rename it.
  • Write code that references cell ranges on a worksheet.
  • Write code that programmatically formats and inserts values and formulas into a worksheet.
  • Write code that applies formatting to cells in a worksheet.
top
Module 6: Analysing and Presenting Data in Microsoft Excel
  • Creating charts
  • Creating PivotTable dynamic views
  • Presenting results to the user
  • Lab 6.1 Analysing the sales data
Skills
  • Programmatically create a chart from worksheet data.
  • Modify the style and formatting of a chart.
  • Programmatically create a PivotTable from worksheet data.
  • Modify the layout and format of a PivotTable.
  • Publish Office documents as HTML.
  • Publish Excel components as interactive Web pages.
top
Module 7: Building Documents in Microsoft Word
  • Overview
  • Working with documents
  • Working with areas of a document
  • Working with document content
  • Lab 7.1 Building the Sales Report document
Skills
  • Choose the Word features to use in designing a solution.
  • List and describe the components of the Word object model.
  • Create and save a Word document based on a template programmatically.
  • Open an existing Word document programmatically.
  • Insert and format text in a Word document programmatically.
  • Insert Microsoft Excel data into a Word document programmatically.
  • Publish a Word document for viewing on the World Wide Web.
top
Module 8: Expanding Your Office Solution
  • Working with the Microsoft PowerPoint presentation graphics program
  • Working with Assistant
  • Working with Microsoft Access
  • Working with the Microsoft Outlook messaging and collaboration client
  • Lab 8.1 Expanding your Office solution
Skills
  • List and describe some commonly used objects in the PowerPoint, Assistant, Microsoft Access, and Outlook object models.
  • Build a PowerPoint presentation and publish it as a Web page.
  • Use the Assistant object model to customize Office Assistant and display information.
  • Use the Microsoft Access object model to programmatically open a database, create a report, and save it as a Web page.
  • Use the Outlook object model to customize your Outlook client application.
top
Module 9: Advanced Issues in Office Development
  • Microsoft Office Developer
  • Using Code Librarian
  • Using COM add-ins
  • Using digital certificates
  • Deploying an Office solution
  • Lab 9.1 Creating and deploying a COM add-in
Skills
  • Import code from Code Librarian into a Visual Basic for Applications project.
  • Build a COM add-in by using the Add-In Designer in Visual Basic Editor.
  • Describe the two steps necessary to register a COM add-in on a user's system.
  • Describe the security issues involved in developing and distributing an Office solution.
  • Sign a Visual Basic for Applications project.
  • Choose the appropriate deployment strategy for an Office solution.
top
Module 10: Using FrontPage 2000
  • Planning a Microsoft FrontPage Web site
  • Creating a FrontPage Web site
  • Managing a Web site
  • Programming in FrontPage
  • FrontPage object models
  • Lab 10.1 Creating the Northwind Sales Web site
  • Lab 10.2 Using the FrontPage object model
Skills
  • Describe a general strategy for planning and developing Web sites.
  • Distinguish between FrontPage Server Extensions and Office Server Extensions.
  • Create a Web site by using Corporate Presence Web Wizard.
  • Add a new Web page to an existing FrontPage Web site.
  • Import files and folders to an existing FrontPage Web site.
  • Use the category component to add hyperlinks to a Web page.
  • Use reports to track hyperlink status, slow files, and review status of Web pages.
  • Use the Application object model to respond to FrontPage application events.
  • Use the Web object model to navigate and list the structure of a Web site.
  • Describe the capabilities of the Page object model.
top
> Pre-Requisites
This course requires that students meet the following prerequisites:
  • Use basic features of the Microsoft Word and Excel applications.
  • Record simple macros by using Macro Recorder and invoke them.
  • Demonstrate familiarity with the Visual Basic development system and event-driven programming concepts
> Purpose
At the end of the course, students will be able to:Describe design considerations and deployment scenarios when building a custom solution by using Microsoft Office 2000. Determine whether Microsoft Visual Basic for Applications code should be part of a specific document, a document template, or a component object model (COM) add-in. Use Visual Basic Editor to write and run Visual Basic for Applications code and manage files. Customize the user interface of Office 2000 applications by using command bars and forms. Connect to data sources and retrieve data by using ActiveX Data Objects (ADO). Use the Office 2000 applications to access data in a relational or nonrelational database, and manipulate and present the data. List and describe some of the more commonly used objects in the Office 2000 object models. Use the Microsoft Excel object model to programmatically navigate, format, present, and analyse data. Use the features in Office 2000 Developer to build a COM add-in, use digital signatures to enhance security, and deploy your applications. Use the Microsoft FrontPage 2000 Web site creation and management tool to create a Web site and display documents created in other Office 2000 applications
> Supplementary Information
This course has now retired and is no longer available. It is possible for us to run a closed Office 2007 course for more than two people. Please call for details.