excel高级玩使用...pptVIP

? 1998 Microsoft Corporation. All rights reserved. * Once a your users have gathered or digested information it is important that they be able to take this raw information and turn it into something useful for the overall business. This is Office’s bread and butter - Office is the tool that more people use to analyze information than any other and with Office 2000 we are making it so that your users can now more easily access the powerful analysis capabilities that reside in the product. We do this in a few ways: Making Analysis Tools More Discoverable (per IT input early in development process) Using the web as a platform, Office 2000 will deliver reporting, analysis and tracking applications that enable easy access to information for everyone. This is possible because Office 2000 has Web Components (these are COM controls) that will be hosted in the browser, that are familiar and easy to use. The four components that will be offered are: Spreadsheet component Charting Component Pivot Table Component Data Source Component (plumbing that makes Data Access Pages possible - see below) IT/developers are already familiar with developing solutions inside office can easily and rapidly produce web based solutions that take less time to develop and require fewer resources Easier Analysis of Corporate Information Data Access Pages use an engine called the Data Source Component for data connectivity and manipulation. Data Access Pages deliver a hybrid of a form and a report and provides an interactive Web view of information. Uses the IE Object Model and DHTML(Dynamic HTML). In addition to Data Access Pages, Access now offers powerful SQL interaction, now supporting true SQL client/server interactivity through OLEDB. It also includes several new Wizards to perform common client/server tasks such as creating a new database, report, or form. Excel also supports fast access to very large data stores the Decision Support Services (DSS), a new Online Analytical Process