Microsoft« Access 2000 Bible, Gold Edition

by Cary N. Prague; Michael R. Irwin; Jennifer Reardon

• ISBN13: 9780764534041
• ISBN10: 0764534041
• Edition: CD
• Format: Hardcover
• Copyright: 1999-01-01
• Publisher: Wiley

Summary

With more than 400 pages of additional information on security, help systems, programming, performance optimization, advanced client/server techniques, and more, this deluxe GOLD edition will answer all your Access 2000 questions and help you create state-of-the-art database systems for your business. In this indispensable resource, three of the world2s best-known Access experts share everything they2ve learned through years of building and managing Access databases.

Author Biography

<B>Michael R. Irwin</B> is considered one of the leading authorities on automated database and Internet management systems. He is a noted worldwide lecturer, a winner of national and international awards, best-selling author, and developer of client/server, Internet, Intranet, and PC-based database management systems. His expertise includes database processing in and between mainframe, minicomputer, and PC-based database systems; he is a leading authority on PC-based databases.<BR>Michael has extensive database knowledge gained by working with the Metropolitan Police Department in Washington, D.C. as a developer and analyst for the Information Systems division for more than 20 years. Since retiring in June 1992, he runs his own consulting firm, named Database Integrators, specializing in Internet consulting offices in Cincinnati, Ohio and Manila, Philippines, his company does training and development of Internet and database applications. His local, national, and international clients include many software companies, manufacturers, government agencies, and international companies.<BR>He has authored numerous database books, with several of them consistently on the best-sellers lists. His most recent works include <I>The OOPs Primer</I> (Borland Press), <I>dBASE 5.5 for Windows Programming</I> (Prentice Hall), <I>Microsoft Access 97 Bible</I>, and <I>Working with the Internet</I>. He has also written a book on the customs and cultures of Asia (to be released in 1999). Two of his books have won international acclaim. His books are published in more than 24 languages worldwide.<BR>Michael has developed and markets several add-on software products for the Internet and productivity-related applications. many of his productivity applications can be obtained form several of his Internet sites or on many common download sites. His productivity tools include the Universal Calendar and Scheduling program, the Telephone Contact System, Password Keeper, and several others. All of these systems are distributed as freeware and careware. He has also developed and distributes several development tools and add-ins for a wide range of developer applications.

Table of Contents

Preface	xi	(6)
Acknowledgments	xvii
Part I: First Things First	1	(100)
Chapter 1: What Is Access 2000?	3	(16)
Chapter 2: Installing and Running Access 2000	19	(22)
Chapter 3: A Review of Database Concepts	41	(12)
Chapter 4: A Hands-on Tour of Access 2000	53	(22)
Chapter 5: A Case Study in Database Design	75	(26)
Part II: Basic Database Usage	101	(192)
Chapter 6: Creating Database Tables	103	(42)
Chapter 7: Entering, Changing, Deleting, and Displaying Data	145	(36)
Chapter 8: Creating and Using Simple Data-Entry Forms	181	(20)
Chapter 9: Understanding and Using Simple Queries	201	(28)
Chapter 10: Creating and Printing Simple Reports	229	(22)
Chapter 11: Setting Relationships Between Tables	251	(42)
Part III: Using Access in Your Work	293	(378)
Chapter 12: Using Operators, Functions, and Expressions	295	(26)
Chapter 13: Creating Relations and Joins in Queries	321	(26)
Chapter 14: Creating Select Queries	347	(26)
Chapter 15: Understanding Controls and Properties	373	(36)
Chapter 16: Creating and Customizing Data-Entry Forms	409	(42)
Chapter 17: Creating Great-Looking Forms	451	(22)
Chapter 18: Adding Data-Validation Controls to Forms	473	(28)
Chapter 19: Using OLE Objects, Graphs, and ActiveX Custom Controls	501	(48)
Chapter 20: Creating and Customizing Reports	549	(52)
Chapter 21: Presentation Quality Reports and Printing	601	(34)
Chapter 22: Creating Calculations and Summaries in Reports	635	(36)
Part IV: Advanced Database Features	671	(188)
Chapter 23: Working with External Data	673	(38)
Chapter 24: Advanced Select Queries	711	(32)
Chapter 25: Creating Action Queries	743	(24)
Chapter 26: Advanced Query Topics	767	(30)
Chapter 27: Creating and Using Subforms	797	(32)
Chapter 28: Creating Mailing Labels and Mail Merge Reports	829	(30)
Part V: Applications in Access	859	(290)
Chapter 29: An Introduction to Macros and Events	861	(24)
Chapter 30: Using Macros in Forms and Reports	885	(40)
Chapter 31: Creating Switchboards, Command Bars, Menus, Toolbars, and Dialog Boxes	925	(62)
Chapter 32: Using Data Access Pages, Intranets, and the Internet	987	(34)
Chapter 33: Using Access with the Microsoft Database Engine and SQL Server	1021	(36)
Chapter 34: Introduction to Applications with VBA	1057	(34)
Chapter 35: The Access 2000 Programming Environment	1091	(58)
Part VI: Advanced Access Topics	1149	(258)
Chapter 36: Optimizing Performance	1151	(52)
Chapter 37: Securing an Access Application	1203	(42)
Chapter 38: Creating Help Systems in Access 2000	1245	(30)
Chapter 39: Using the Microsoft Office Developer	1275	(38)
Chapter 40: Integrating with Microsoft Office 2000	1313	(24)
Chapter 41: Exploring Replication	1337	(36)
Chapter 42: Exploring Add-Ins and Libraries	1373	(34)
Appendix A: Microsoft Access 2000 Specifications	1407	(4)
Appendix B: Mountain Animal Hospital Tables	1411	(6)
Appendix C: What's on the CD-ROM	1417	(14)
Appendix D: Example CD Object Cross-Reference Guide	1431	(8)
Appendix E: Chapter Cross-Reference Guide	1439	(6)
Index	1445	(54)
End-User License Agreement	1499	(7)
CD-ROM Installation Instructions	1506