Access 2003 All-in-One Desk Reference For Dummies

• Creating and modifying tables and entering and editing data
• Sorting, finding, and filtering data
• Creating queries, including update queries, action queries, and the Query Wizards
• Building forms with AutoForm and Wizards
• Creating charts and graphs from your data
• Maintaining, sharing, and securing your Access database
• Letting Access do the math, whether it’s calculating simple cost per unit or performing complex financial functions

Microsoft Office Access 2003 All-In-One Desk Reference For Dummies was written by three computer gurus: Alan Simpson, author of over 80 computer books; Margaret Levine Young, co-author of several dozen computer books, including The Internet for Dummies; and Alison Barrows, book author and writer and editor of technical documentation and training material. To give you hands-on experience and demonstrate practical applications of database management, there is a Web site that complements the book and features a fully functioning mail order management database used in examples throughout the book. You can download it and follow along as you explore:

• Working with external data sources such as Microsoft SQL Server
• Writing and debugging code
• Using HTML, JavaScript, Jscript, VB Script, and Java to facilitate the exchange of information on the Internet among different programs on disparate platforms
• Using data access pages (DAP) to share information on your intranet

With Access 2003 All-In-One Desk Reference For Dummies, you’ll discover how to put information to work for you.

9 books in 1— one great price for nine handy guides

Your one-stop guide to building databases and managing information with Access 2003

Think of this book as the ultimate user-friendly Access companion, loaded with information that’s simple to find. It will have you creating and using a database in no time, and the self-contained minibooks include information that works for Access 2000, 2002, and 2003. From storing, organizing, and sharing data to customizing databases with VBA, it gives you easy Access.

The Dummies Way

• Coverage of the essentials and beyond
• Explanations in plain English
• "Get in, get out" information
• Thumbtabs and other navigation aids
• Tear-out cheat sheet
• A dash of humor and fun

Alan Simpson is the author of over 80 computer books on all sorts of topics: Windows, databases, Web site design and development, programming, and network administration. His books are published throughout the world in over a dozen languages and have millions of copies. When not building computers or writing books about them, Alan eats or sleeps. He doesn’t have a fancy job title, because he’s never had a real job, and still doesn’t know how to tie a tie.

Margaret Levine Young has co-authored several dozen computer books about the Internet, UNIX, WordPerfect, Access, and (stab from the past) PC-File and Javelin, including The Internet For Dummies (published by Wiley Publishing, Inc.) and Windows XP Home Edition: The Complete Reference (published by Osborne/McGraw-Hill). She met her future husband Jordan in the R.E.S.I.S.T.O.R.S., a high-school computer club before there were high school computer clubs. Her other passions are her children, music, Unitarian Universalism (www.uua.org), reading, and anything to do with cooking or eating.

Alison Barrows has authored or co-authored books on Windows, the Internet, Microsoft Access, WordPerfect, Lotus 1-2-3, and other topics. In addition to writing books, Alison writes and edits technical documentation and training material. She holds a B.A. in International Relations from Wellesley College and an M.P.P. from Harvard University. In real life she hangs out with her “guys” — Parker, 3, and Mason, 1, and tries to carve out some time to practice yoga. Alison lives with her family in central Massachusetts.