Microsoft Access 2000 Bible

Michael R. Irwin 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. 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. He has authored numerous database books, with several of them consistently on the best--sellers lists. His most recent works include The OOPs Primer (Borland Press), dBASE 5.5 for Windows Programming (Prentice Hall), Microsoft Access 97 Bible, and Working with the Internet. 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. 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.

Preface. Acknowledgments. PART I: First Things First. Chapter 1: What Is Access 2000? Chapter 2: Installing and Running Access 2000. Chapter 3: A Review of Database Concepts. Chapter 4: A Hands--on Tour of Access 2000. Chapter 5: A Case Study in Database Design. PART II: Basic Database Usage. Chapter 6: Creating Database Tables. Chapter 7: Entering, Changing, Deleting, and Displaying Data. Chapter 8: Creating and Using Simple Data--Entry Forms. Chapter 9: Understanding and Using Simple Queries. Chapter 10: Creating and Printing Simple Reports. Chapter 11: Setting Relationships Between Tables. PART III: Using Access in Your Work. Chapter 12: Using Operators, Functions, and Expressions. Chapter 13: Creating Relations and Joins in Queries. Chapter 14: Creating Select Queries. Chapter 15: Understanding Controls and Properties. Chapter 16: Creating and Customizing Data--Entry Forms. Chapter 17: Creating Great--Looking Forms. Chapter 18: Adding Data--Validation Controls to Forms. Chapter 19: Using OLE Objects, Graphs, and ActiveX Custom Controls. Chapter 20: Creating and Customizing Reports. Chapter 21: Presentation Quality Reports and Printing. Chapter 22: Creating Calculations and Summaries in Reports. PART IV: Advanced Database Features. Chapter 23: Working with External Data. Chapter 24: Advanced Select Queries. Chapter 25: Creating Action Queries. Chapter 26: Advanced Query Topics. Chapter 27: Creating and Using Subforms. Chapter 28: Creating Mailing Labels and Mail Merge Reports. PART V: Applications in Access. Chapter 29: An Introduction to Macros and Events. Chapter 30: Using Macros in Forms and Reports. Chapter 31: Creating Switchboards, Command Bars, Menus, Toolbars, and Dialog Boxes. Chapter 32: Using Data Access Pages, Intranets, and the Internet. Chapter 33: Using Access with the Microsoft Database Engine and SQL Server. Chapter 34: Introduction to Applications with VBA. Chapter 35: The Access 2000 Programming Environment. PART VI: Advanced Access Topics. Chapter 36: Optimizing Performance. Chapter 37: Securing an Access Application. Chapter 38: Creating Help Systems in Access 2000. Chapter 39: Using the Microsoft Office Developer. Chapter 40: Integrating with Microsoft Office 2000. Chapter 41: Exploring Replication. Chapter 42: Exploring Add--Ins and Libraries. Appendix A: Microsoft Access 2000 Specifications. Appendix B: Mountain Animal Hospital Tables. Appendix C: What's on the CD--ROM. Appendix D: Example CD Object Cross--Reference Guide. Appendix E: Chapter Cross--Reference Guide. Index. End--User License Agreement. CD--ROM Installation Instructions.