Synopses & Reviews
Become more productive right away using the hands-on directions and targeted information in this innovative how-to reference. Loaded with to-the-point techniques, this complete resource provides insightful answers to common questions as quickly as you can turn its pages. Use Access as a key data management tool. Design databases and program advanced queries. Manage data through advanced import and export techniques, including leveraging new XML features. Explore advanced techniques for integrating Access with Microsoft SQL Server. Plus--this thorough book explains why as well as how techniques work so that you can adapt concepts to your specific needs.
- Explore querying capabilities and learn to use the query tools effectively
- Integrate Access 2003 and Microsoft SQL Server, and work with Access Data Projects
- Manipulate and massage data for import and export quickly
- Design and prototype enterprise databases
- Use Web Matrix and Visual Studio .NET to build data-driven applications
- Learn advanced XML capabilities
- Explore advanced data management techniques
- Outperform even your highest expectations
Advanced techniques for the millions of experienced users moving to Access 2003!
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.
This guide covers key features in Access 2003, including significant XML capabilities. It also provides insights and techniques into using Access as a data management tool to show readers how to get the information they need in the most effective way.
About the Author
Noel Jerke is the Senior Vice President of Operations for Judd's OnLine, Inc. in Winchester, Virgina. The author of several books on Visual Basic, Jerke is an experienced technology manager and has a strong background in corporate development, e-commerce, and Internet Technologies. Jerke received a B.S. degree in Computer Science and Economics from Trinity University, San Antonio, Texas.
Table of Contents
1: Introducing Office 2003
2: Designing and Prototyping Enterprise Databases with Microsoft Access
3: Building Advanced Queries with the Query Wizard
4: Building Advanced Queries with the Query Design View
5: Programming Microsoft Access with Web Matrix
6: Programming Microsoft Access with .NET
7: Importing and Exporting Data
8: Working with Access XML
9: Introducing Access Data Projects
10: Building an Access Data Project
11: Managing Access Databases
12: Visual Basic for Applications
Appendix A: Access 2003 XML Objects
Appendix B: PivotTable and PivotChart Basics
Appendix C: Data Access Pages