Mastering Microsoft Office 2000 Solution Development(Microsoft Training Course: 1301) - Microsoft Training Courses London South West UK

Exchange Server

Office (inc Access)

SQL Server

Visual Studio .NET

Windows

Web Development

Visual FoxPro

Programming

Business

Knowledge Management

Certification

Learning Options

Reserve a Place
No scheduled Course : Contact for Details

View Other Courses in Same Category

Mastering Microsoft Office 2000 Solution Development - (Microsoft Training Course: 1301) - 5 days

Target Audience		Pre-requisites
Purpose		Print 2 Page Flyer
Exams		Price Options

COURSE OUTLINE

Designing Custom Solutions		Using Visual Basic Editor
Applying Visual Basic-Related Skills in Office 2000		Retrieving Data in an Office Solution
Building Documents in Microsoft Excel		Analysing and Presenting Data in Microsoft Excel
Building Documents in Microsoft Word		Expanding Your Office Solution
Advanced Issues in Office Development		Using FrontPage 2000

Target Audience: This course will teach developers how to build solutions that access data and automate business processes by using Microsoft Office 2000 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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

There are no exams directly associated with this course

Price Options ex VAT:

Classroom Training ?	Distance Learning ?	eLearning Options ?	Book Learning ?
£ 1750 (€2486)	£ 995.00 (€1413)	-	No Books Supported for Course at present
	Call Free on 0800 169 1890 Print 2 Page Flyer Last Modified 01 May 2008