Share this Page URL

Part III: The Data Pipeline - Pg. 498

498 Part III. The Data Pipeline The four chapters in Part III detail some of the ways in which you can expand your use of Mi-crosoft Access by sharing data with other applications and users and connecting to the data stored in other databases. In the first chapter, "Understanding Access Projects," we provide an overview of how Access works in conjunction with a Microsoft SQL Server database. In an Access project, tables and queries are stored in the SQL Server database, while forms, reports, and other database objects are stored in Access. With an Access project, you can connect to data stored in SQL Server data- bases that might exist throughout an organization or create your own database to take advantage of features that SQL Server provides that are beyond the scope of a standard Access database. You'll also learn how to use Access with some of the other applications that come with the Microsoft Office System, including Microsoft InfoPath 2003 (an application you use to create business forms), Microsoft Outlook, and Microsoft Excel. In the second chapter, "Integration with Office 2003 and SharePoint Services," you'll learn how to use Access together with Microsoft's SharePoint prod-ucts and technologies to set up a collaborative Web site that teams use to manage and share informa- tion. In the next chapter "Working with XML Data in Access," you'll learn some of the basics of XML, a standard markup language used to share data. You'll export Access data into XML, import XML into Access, and see how you can transform and structure XML data to fit the needs of your da- tabase. In the last chapter in this part, "Using Visual Basic to Manage Data," you'll see another exam- ple of how to use Visual Basic to provide options to the users of a database and you'll see several