Access 2003 Bible

Author: Prug
Publisher:
Publish Date: 2004-05-01
Features: Microsoft Access 2003 is one of the most outstanding database management systems on 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, and it uses more examples than any other Access book. This is the 9th revision of the book, and this new version provides a comprehensive introduction to Microsoft Office Access 2003 with 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.
Part 1 to Part 3 cover the content that most Access users need to know, including Chapters 1 to 26, 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, which discuss how to migrate Access tables to SQL Server, how to create Access data projects to build true client-server systems, how to create ADO recordset objects to use SQL Server and the Microsoft database engine, and delve into client-server systems, covering how to create stored procedures, triggers, and pass-through queries. Part 5 explains how to create applications using Internet or online data, how to create data access pages, and introduces XML and the new InfoPath product. Part 6 covers 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; discusses advanced selection query topics, including summary queries, cross-tab queries, top-value queries, and union queries; explains action queries and various techniques to improve application performance; and concludes with some issues related to publishing Access applications.
In addition to these six major parts, the book also includes four appendices, listing some rules in Access, showing the database diagrams of the tables used in the book, introducing the accompanying CD-ROM, and discussing standard naming conventions. The book starts with 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 discussed 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 what interests them. The book is highly valuable, more detailed than any other book on Microsoft Access on the market today, and suitable for both beginners and intermediate to advanced users of Access.
Microsoft Access is one of the most outstanding multimedia database management software on the market today and also the best Windows database system. This book provides a comprehensive introduction to Access 2003 with entirely new content, graphics, and sample files. It explains how to create desktop applications, how to create enterprise applications, how to create applications using Internet or online data, and advanced topics in Access 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.