Share this Page URL
Help

The Microsoft Office Access 2003 Inside ... > The Microsoft Office Access 2003 Ins... - Pg. xxiv

The Microsoft Office Access 2003 Inside Track Road Map · · · · · · xxiv Set up the SQL Server 2000 Database Engine Upsize an Access database to SQL Server Create an Access project Create and modify tables in an Access project Use database diagrams Design and modify the types of queries (known as views and stored procedures) you work with in an Access project Chapter 15: Integration with Office 2003 and SharePoint Services Before beginning this chapter: You should understand how to link to an external data source. You should also understand the relationship between fields and tables. You can find information about linking to data in Chapter 4, "Importing and Linking to Data." You can find information about fields and tables in Chapter 2, "The Basics of Database Design," and Chapter 3, "Managing the Consistency, Format, and Integrity of Your Data." In this chapter, you will learn how to: · · · · Extend SharePoint using Access Work with Access data in InfoPath Analyze Access data through Excel Work with Outlook data in an Access database Chapter 16: Working with XML Data in Access Before beginning this chapter: You should understand how tables are structured and the relationship between fields and tables. You can find information about fields and tables in Chapter 2, "The Basics of Database Design," and Chapter 3, "Managing the Consistency, Format, and Integrity of Your Data." In this chapter, you will learn how to: · Use Access to export and import XML data · Use an XSLT to format XML data · Define the structure of the output: Extensible Schema Definition (XSD) and XSLT stylesheet Chapter 17: Using Visual Basic to Manage Data Before beginning this chapter: You should be familiar with the basics of writing Visual Basic code that runs when an Access event occurs, as described in Chapter 5, "Using Visual Basic to Automate Your Database." You should also review the introduction to object models presented in Chapter 5 and be familiar with the struc- ture of an SQL statement, which is described in Chapter 9, "Extending Your Use of Queries." In this chapter, you will learn how to: · Create a custom report feature · Use Visual Basic to work with Access data in other Microsoft Office applications, including Mi- crosoft Out look, Microsoft Excel, and Microsoft PowerPoint · Work with recordsets using ADO