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) |
|
|
|
3 | (14) |
|
|
|
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) |
|
|
|
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 | |
|
|
|
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 | |