Access 2003 Bible (Includes one CD-ROM)

Author: Prug
Publisher:
Publish Date: 2004-05-01
Features: Microsoft Access is one of the most outstanding multimedia database management software in the market today, and also one of the best Windows database systems. This book provides a comprehensive introduction to Access 2003 using entirely new content, graphics, and sample files. It covers how to create desktop applications, how to create enterprise applications, how to create applications using Internet or data on the Internet, as well as advanced Access topics such as data exchange between Access and other Office products, database security, creating and running help systems, advanced selection queries, speeding up application performance, and publishing Access applications. The book is well-structured, rich in content, authoritative, and provides in-depth explanations, making it suitable for a wide range of computer users, technical managers, and especially those involved in database development and application. Microsoft Access 2003 is one of the most outstanding database management systems in the market today and the best Windows database system. This book guides readers step by step to understand this powerful and user-friendly database management system, using more examples than any other Access book. This is already the 9th revision of the book, and this new version provides a comprehensive introduction to Microsoft Office Access 2003 using entirely new content. The book contains 39 chapters, divided into 6 parts: Using Tables and Queries, Creating Forms and Reports, Automating Applications, Creating Enterprise Applications, Creating Web Applications, and Advanced Topics in Access. Parts 1 to 3 cover the content that most Access users need to know, including the first 26 chapters, which cover the entire process of creating personal or group applications, including creating tables, using queries, creating forms and reports, and using VBA programming. Part 4 includes chapters 27 to 29, explaining how to migrate Access tables to SQL Server, how to create Access data projects to establish true client-server systems, how to create ADO recordset objects to use SQL Server and the Microsoft database engine, and provides an in-depth introduction to client-server systems, including how to create stored procedures, triggers, and pass-through queries. Part 5 covers how to create applications using Internet or data on the Internet, how to create data access pages, and introduces XML and the new InfoPath product. Part 6 introduces advanced topics in Access, including how to exchange data between Access and other Office products, how to protect databases, how to create and run help systems, and discusses advanced selection query topics, including summary queries, cross-tab queries, top-value queries, and union queries. It also covers operational queries and various techniques to improve application performance. Finally, it introduces some issues related to publishing Access applications. In addition to these 6 major parts, the book also includes 4 appendices, listing some rules in Access, showing the database diagrams of the database tables used in the book, introducing the accompanying CD-ROM, and discussing standard naming conventions. The book starts with the most basic concepts and gradually delves into all aspects of Access. When it is necessary to review the content of previous chapters, the book revisits already explained concepts, so although the entire book is an organic whole, each part is relatively independent and has its own sample files. Readers can skip any chapter or topic and read directly about the subject they are interested in. The book is highly valuable, more detailed than any other book on Microsoft Access currently on the market, and suitable for both beginners and intermediate to advanced users of Access.