Microsoft Access 97 Bible

by Prague, Cary N.; Irwin, Michael R.; Foxall, James D.; Amo, William C.

• ISBN13: 9780764533556
• ISBN10: 076453355X
• Edition: 1st
• Format: Hardcover
• Copyright: 1999-03-12
• Publisher: Wiley

Summary

The Ultimate Guide to Access 97! In this indispensable resource, four of the world's best-known Access experts share everything they've learned through years of building and managing Access. With over 400 pages of additional information on security, programming, integrating with Microsoft Office, and more, this Gold Edition of the bestselling Access 97 Bible will answer all your questions and help you create the perfect database systems for your business. Inside, Find Everything You Need to Know to: Add controls, complex data validation, and multimedia elements to your systemBuild multi-table, action, and other advanced queriesGenerate reports, including mail-merge reports and mailing labelsIntegrate data from other Office applications or other databasesMaster one-to-many relationshipsUse macros and VBA to automate manual processesDevelop custom toolbars, dialog boxes, and pull-down help menusCreate add-ins, wizards, and stand-alone applicationsPublish databases to the Web or a corporate intranetAward-winning business applications on CD-ROM!Check Writer -- Microsoft Network Award for Best ApplicationFlex Search, the Access File Utilities, and more from Database Creations's EZ Access Developers Suite SamplerYes! I Can Run My Business working demo -- 1998 Access Advisor Readers Choice AwardLinks to Cary Prague's Database Creations on the Web, the world's largest Access add-on companyPlus all the examples, templates, and code from the book Shareware programs are fully functional, free trial versions of copyrighted programs. If you like particular programs, register with their authors for anominal fee and receive licenses, enhanced versions, and technical support. Freeware programs are free, copyrighted games, applications, and utilities. You can copy them to as many PCs as you like-- free-- but they

Author Biography

About the Authors Cary N. Prague, a Microsoft Certified Professional, is an internationally best-selling author and lecturer in the database industry. He is also the president of Database Creations, Inc., the world's largest Microsoft Access add-on company. This direct-mail business creates and markets add-on software, books, and video training for personal computer databases. Its Web site is at www.databasecreations.com. Cary also manages a very successful consulting company that is a Microsoft Certified Solution Provider, specializing in Microsoft Access application. His local and national clients include many Fortune 500 software companies, manufacturers, defense contractors, and insurance companies. Cary is one of the best-selling authors in the computer database management market. He has written nearly 35 books, which have sold almost one million copies, covering such software as Microsoft Access, Borland's dBASE IV, Paradox, R:Base, and Framework. He is currently writing several new Access 2000 books. He was a contributing editor for Access Advisor magazine and continues to write for it. 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, a best-selling author, and a developer of client/server, Internet, intranet, and PC-based database management systems. Mr. Irwin has extensive database knowledge gained from working as a developer and analyst for the Information Systems Division of the Washington, D.C., Metropolitan Police Department for over 20 years. Since retiring in June 1992, he runs his own consulting firm, Database Integrators, specializing in Internet database integration and emphasizing client/server and net solutions. With consulting offices in Cincinnati, Ohio, and Manila, Philippines, his company does training and development of Internet and database applications. Michael has authored numerous database books, several of them consistently on best-seller lists. His most recent works include the Access 97 Bible (IDG Books Worldwide); he has also written a book on Asian customs and cultures, to be released in 1999. His books are published in over 24 languages worldwide. Michael has developed and markets several add-on software products for the Internet and productivity-related applications, many of which can be obtained from his various Internet sites or on many common download sites. He has also developed and distributes several development tools and add-ins for a wide range of developer applications.

Table of Contents

Preface	xi
Acknowledgments	xvii
Part I: First Things First	1	(102)
What Is Access 97?	3	(14)
Installing Access 97	17	(12)
Getting Started with Access 97	29	(16)
A Review of Database Concepts	45	(12)
A Hands-On Tour of Access 97	57	(20)
A Case Study in Database Design	77	(26)
Part II: Basic Database Usage	103	(186)
Creating Database Tables	105	(40)
Entering, Changing, Deleting, and Displaying Data	145	(36)
Creating and Using Simple Data-Entry Forms	181	(22)
Understanding and Using Simple Queries	203	(28)
Creating and Printing Simple Reports	231	(22)
Setting Relationships Between Tables	253	(36)
Part III: Using Access in Your Work	289
Using Operators, Functions, and Expressions	291
Creating Relations and Joins in Queries	317
Creating Select Queries	343
Understanding Controls and Properties	371
Creating and Customizing Data-Entry Forms	407
Creating Great-Looking Forms	449
Adding Data-Validation Controls to Forms	471
Using OLE Objects, Graphs, and ActiveX Custom Controls	499
Creating and Customizing Reports	549
Database Publishing and Printing	601
Creating Calculations and Summaries in Reports	635