Create and manage a robust Access database using this advanced guide. You'll get full coverage of all the new features, including Smart Tags and enhanced XML support. Learn to write advanced queries with the query wizard and the design view, import and export data, program with Web Matrix and .NET, and build Access Data Projects with SQL Server. Database backup and security issues are also covered.

Contents

• Introducing Office 2003
• Designing and Prototyping Enterprise Databases with Microsoft Access
• Building Advanced Queries with the Query Wizard Building Advanced Queries with the Query Design View
• Programming Microsoft Access with Web Matrix
• Programming Microsoft Access with .NET Importing and Exporting Data
• Working with Access XML
• Introducing Access Data Projects Building an Access Data Project Managing Access Databases
• Visual Basic for Applications
• Access 2003 XML Objects
• PivotTable and PivotCharl Basics
• Data Access Pages
• Index