Access 2000 Bible

Cary Prague is an internationally best-selling author and lecturer in the database industry. He is the owner of Cary Prague Books and Software, the world's largest Microsoft Access add-on vendor. This direct-mail company creates and markets add-on software, books, and video training for personal computer databases. Formerly, he held numerous management positions in Corporate Information Systems, including Director of Managed Care Reporting for MetraHealth (MetLife and Travelers Insurance joint venture); Director of Software Productivity at Travelers Insurance, where he was responsible for software support and training for 35,000 end users, and Director of Corporate Finance, where he was responsible for the selection and installation of Fixed Asset and Payroll Systems; and Manager of Information Centers for Northeast Utilities. Cary also runs a consulting company, specializing in Microsoft Access applications and training. His clients include many local and national companies, including software companies, manufacturers, public utilities, and broadcast companies. His client list includes Microsoft, Borland International, Otis Elevator, United Healthcare, Pratt and Whitney Aircraft, Rockwell International, and SNET. He is one of the best-selling authors in the computer database management market, having written over thirty-five books on software that have sold nearly one million copies, including Microsoft Access, Borland dBASE IV, Paradox, R:Base, and Framework. Cary's books include the PC World Microsoft Access Bible, recently on several top 10 national bestseller lists and winner of an award for technical excellence; dBASE for Windows Handbook, dBASE IV Programming, winner of the 1989 Computer Press Association's Book of the Year award for Best Software-Specific Book; and Everyman's Database Primer Featuring dBASE IV. 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.

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. Appendix A: Microsoft Access 2000 Specifications. Appendix B: Mountain Animal Hospital Tables. Appendix C: What's on the CD-ROM. Appendix D: Object Cross-Reference Guide. Appendix E: Chapter Cross-Reference Guide. Index. End-User License Agreement. CD-ROM Installation Instructions.