Notes

Outline

Office 2000 Does the Web Rick Dobson, Ph.D. CAB, Inc. (http://www.cabinc.net) presented at Internet World Canada February, 1999

Agenda Overview of what’s new with Office 2000 and the web Access, FrontPage, and Excel interoperability Office Web Components with Excel Data Access Pages from Access Selected other Office 2000/web innovations

You Speaker is Rick Dobson He is the Microsoft Press author for Programming Microsoft Access 2000 from Microsoft Press His articles on Office/web technology appear regularly in Microsoft Office & VBA Developer His firm, CAB, offers tutorials on Advanced Access 2000 Development

Rick’s Contact Info

What’s New with Office/Web FrontPage 2000 is a part of Office 2000 Excel Web Queries Office Web Components Spreadsheet Chart Database PivotTable Data Access Pages Web-based collaboration Microsoft Script Editor

FrontPage 2000 Cross-browser DHTML Create web content without overhead of and setup for web server Open and use Office apps directly from FrontPage Uses VBA as a scripting language in addition to JavaScript and VBScript

DHTML Effects in FrontPage

One-Step Export from Access to FrontPage

Edit Imported Tables in FrontPage

Excel Web Queries: New and Improved Web queries move data from the web to a spreadsheet You can still use .iqy file types to specify web queries (as with previous versions) But, an Excel 2000 custom dialog lets you browse to a web page and graphically specify content to extract Refreshing them is as easy as ever

FrontPage to Excel with Web Queries

Edited FrontPage Table in Excel from Web Query

Demo Web Queries Change table in FrontPage See new values entered into web query when you refresh it

Office Web Components Com objects are for publishing spreadsheets, charts, and databases to the web interacting with data in a browser manual or programmatic use 4 Web Components Spreadsheet Chart Data Source PivotTable

Office Web Components (Cont’d) They provide spreadsheet, charting, and database functionality that mimic Excel and Access over the web Automatic download behind a firewall, but your browser must support Com (this includes IE 4 & 5, but not Netscape) Clients must have a Microsoft Office 2000 license to browse a web page interactively

Excel and IE both Dynamically Compute

Make a Spreadsheet Component Instance Save as Web Page Add interactivity

Excel Make Chart Components too Always select chart to show chart + data

Demo Office Web Components Save a spreadsheet interactively for a sales planner Change sales to impact profits Save it non-interactively to show conventional spreadsheet on web Save a chart interactively Changes sales by quarter to update chart

Data Access Pages A web page with one or more Data Source Office Web Components To create, edit, or browse a Data Access Page, you need IE 5+ installed on your workstation You create pages within Access, but you save the pages as HTML files with a shortcut inside Access that points at the file

Data Access Pages Support Three Types of Tasks Interactive reporting consolidate and group information Expand indicators filter and sort data Data entry enables the addition of new records and the deletion of existing ones Data analysis charting and spreadsheet analysis enables PivotTables

Creating Data Access Pages Create from within Access Use a wizard for canned designs Use Design view to develop custom layouts Switch between Page (like Form) view and Design view as you create page Add fields to page from Fields list; add controls from toolbox Perform grouping and consolidation with Add custom code as your needs dictate

A Data Access Page for editing, filtering, and sorting

Design View of Data Access Page

DAP with Expand Buttons

Demo Data Access Pages Create a basic Data Access Page (DAP) Link to the DAP and use it Edit the page in Access/FrontPage and re-link Create a banded Data Access Page Link to the page demo navigation/editing expand/contract bands

Other Office 2000 Web-based Initiatives Office server extensions facilitate web-based document collaboration Office WebBot Components are JavaScript or VBScript applets that can automate an Office document; they bring DHTML to Office-based web pages Microsoft Script Editor is a Visual InterDev environment for writing and debugging web scripts in Excel, Word, and PowerPoint

Web Resources Office 2000 Preview site: http://www.microsoft.com/office/preview/default.htm Getting your preview copy: http://www.microsoft.com/office/2000/office/cpp/default.htm Access/Office 2000 development resources: www.programmingmsaccess.com

Office 2000 Does the Web It brings FrontPage 2000 to the package It incorporates DHTML It enables web-style scripting It has components that simplify web-based data display and analysis