Microsoft® Access 2000 Bible : Quick Start

by Prague, Cary N.; Irwin, Michael R.

• ISBN13: 9780764532863
• ISBN10: 0764532863
• Edition: 1st
• Format: Paperback
• Copyright: 1999-05-21
• Publisher: Wiley

Summary

Client lists. Figure sales. Web research. Take charge of your data before it takes over your business. With expert advice from Cary Prague and Michael Irwin, you'll quickly master Access 2000's top database management capabilities -- and its revolutionary Web features. Using step-by-step instructions and practical examples, the authors demonstrate everything you need to know to organize, present, analyze, and share data efficiently over a corporate network or the Internet.

Author Biography

Cary N. Prague is an internationally known best-selling author and lecturer in the database industry. He is the president of Database Creations, Inc. the world's largest Microsoft Access add-on company. This direct-mail company creates and markets add-on software, books, and video training for personal computer databases. Under Cary's leadership, Database Creations has developed and marketed many add-on software products for Microsoft Access including Yes! I Can Run My Business, a business sales and accounting program and winner of the 1998 Access Advisor Magazine Readers Choice award for best accounting application, Check Writer financial software, winner of the Microsoft Network award for best Access Application, the EZ Access line of developer products, the Access Business Forms Library distributed by Microsoft with Access 2.0 upgrades, TabMaster Pro Wizard, User Interface Construction Kit winner of the 1996 Access Advisor Readers Choice award, the Calendar Construction Kit, the Picture Builder Add-On Picture Pack, and the Command Bar Image Editor and Image Pack. Their web site address is www.databasecreations.com. Cary also manages a very successful consulting company which 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 industry companies. His client list includes Microsoft, Borland International, ABB-Combustion Engineering, Smith and Wesson Firearms, Office Max, Continental Airlines, Pratt and Whitney Aircraft, Otis Elevator, State of Connecticut, United Healthcare, Travelers Insurance, Omar Coffee, Rockwell International, and SNET telephone company. Formerly, he has held numerous management positions in corporate information systems, including Director of Managed Care Reporting for MetraHealth, Director of Software Productivity at Travelers Insurance where he was responsible for software support and training for 35,000 end users, Director in 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. He is one of the best-selling authors in the computer database management market having written over 35 books which have sold nearly one million copies on software including Microsoft Access, Borland's dBASE IV, Paradox, R:Base and Framework. Cary's books include the PC World's Microsoft Access Bible, recently number 1 on the Ingram Best-selling Database Titles list and has been on several top national bestseller lists including amazon.com, Access 95 Secrets, dBASE for Windows Handbook, dBASE IV Programming, winner of the Computer Press Association's Book of the Year award for Best Software Specific Book, and Everyman's Database Primer Featuring dBASE IV. He is currently writing several new Access 2000 books. Cary is certified in both Access as a Microsoft Certified Professional and has passed the MOUS test in end-user subjects in Access and Word. He is a frequent speaker at seminars and conferences around the country. He has been voted the best speaker by the attendees of several national conferences. Recently, he was a speaker for Microsoft sponsored conferences in Hawaii, Phoenix, Chicago, Toronto, Palm Springs, Boston and Orlando. He has also spoken at Borland's Database Conference, Digital Consulting's Database World, Microsoft's Developer Days, Computerland's Technomics Conference, COMDEX, and COMPAQ Computer's Innovate. He was a contributing editor to Access Advisor magazine and continues to write for them. Cary holds a master's degree in computer science from Rensselaer Polytechnic Institute, and an M.B.A and Bachelor of Accounting from the University of Connecticut. He is also a Certified Data Processor. 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. Mr. Irwin 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 over 20 years. Since retiring in June 1992, he runs his own consulting firm, named 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. His local, national, and international clients include many software companies, manufacturers, government agencies and international companies. His range of expertise includes database processing in and between mainframe, minicomputer, and PC-based database systems; he is a leading authority on PC-based databases. 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) and dBASE 5.5 for Windows Programming (Prentice Hall), The Access Bible 97, and Working with the Internet. He has also written a book on Customs and Cultures of Asia (to be released in 1999). Two of his books have won international acclaim. 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 his productivity applications can be obtained from 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

Welcome to the Microsoft Access 2000 Bible Quick Start	v
How Does This Booklet Work with the Microsoft Access 2000 Bible?	v
For More Information	vi
Contact Us!	vi
Creating Your Database	1	(1)
Creating a Database Using the Database Wizard	1	(13)
Creating a quick database using a blank database	4	(1)
Creating a table using the Table Wizard	4	(2)
Entering and editing records in Datasheet view	6	(1)
Editing a table	7	(2)
Changing field properties	9	(1)
Formatting the table	9	(1)
Finding records	10	(2)
Filtering records	12	(2)
Create a New Form with the Form Wizard	14	(1)
Create a New Query with the Query Wizard	15	(2)
Create a New Report with the Report Wizard	17	(2)
Create a Data Access Page Using the Data Access Page Wizard	19	(2)
Access Top Time-savers	21	(1)
Start with a template	21	(1)
Use the first letter to define the data type	22	(1)
Use the shortcut menus	22	(1)
Import a table	22	(1)
Use default values	22	(1)
Use Edit Replace	22	(1)
Freeze columns for quicker datasheet data entry	23	(1)
Use AutoCorrect	23	(1)
Use Is Null to find records with blank fields	23	(1)
Set program options to work the way you do	23