In addition to the list of contacts, the search result includes a Search by country hyperlink at the bottom of the result list. Figure 5 shows the result of a search for a particular name. To use the Northwind Contacts sample, enter a first or last name in the Search For text box. The Employees and Customers tables were combined to make the Contacts table, shown in Figure 4.įigure 4: The sample uses ADO.NET to open and query an Access 2003 table.
The source data is based on Microsoft's Northwind Traders database from Microsoft SQL Server or Microsoft Office Access 2003. The steps you're about to walk through are needed to create a simple research service that allows the end user to search for contacts in a database.
A custom research service could provide a way for users to query corporate data, or it could be a front-end to a publicly available service such as Google's Web APIs ( Querying a Corporate Database: A Contacts Sample The ability to add services means that developers can create research services of their own for end users to use in Excel 2003, Word 2003, or PowerPoint 2003. It's this button that separates the Research Library from other useful features available in interactive Office 2003.įigure 1: The Research Library is available from the task pane.Īlthough you could parse the XML string with string functions, it is far easier to load the XML string as an XmlDocument object.įigure 2: The Research Library includes several built-in and online resources by default.įigure 3: Office 2003 provides a long list of choices for customizing the Research task pane's list of resources. Although these resources may be useful, they are not as intriguing as the command button in the bottom left-hand corner of the dialog box: the Add Services button. These resources are mostly international versions of the default resources. The Research Options dialog box, shown in Figure 3, lists additional resources. You can customize the Research task pane to show other resources by clicking Research Options at the bottom of the pane. As you can see in Figure 1, the Research task pane provides a text box for you to enter the word or phrase on which to search, a drop-down list where you can choose to limit the search to a single resource, and an area for displaying the results.Ī custom research service could provide a way for users to query corporate data or it could be a front-end to a publicly available service such as Google's Web APIs.įigure 1 shows the Research task pane after the user has queried the thesaurus for a particular word the user could have selected any of the resources shown in Figure 2 or searched all resources for the same term. You can display the Research task pane by selecting Research from the Tools menu, or by pressing Ctrl+F1 and choosing Research from the Other Task Panes drop-down list. The Research Library is available from the task pane in Microsoft Office Excel 2003, Microsoft Office PowerPoint 2003, Microsoft Office Word 2003, and Microsoft Office Outlook 2003. Working with the Research Library in the Task Pane
#Microsoft office berkeley windows how to
You'll also learn how to use various formatting tags to change the appearance of the result and how to provide a custom search form for your research service. NET (VB.NET), you will become familiar with some of the coding techniques needed to create research services in VB.NET. If you are new to Microsoft Visual Basic. In this article, you'll look at the nuts and bolts of the Research Library and see how you can use Microsoft Visual Studio.
The Research Library is also extensible: you can add your own research service simply by creating a Web service that follows schemas defined by Microsoft for research services. Microsoft Office 2003 Editions add a powerful new tool to the Office task pane: the Research Library.īy default, the Research Library allows you to type in a word or phrase and search for the term using several built-in resources.
0 kommentar(er)
