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
Synopsis
Advanced techniques for the millions of experienced users moving to Access 2003!
Synopsis
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.
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