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 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.
Book I: Essential Concepts.
Chapter 1: Introducing Access 2003.
Chapter 2: Getting Started, Getting Around.
Chapter 3: Designing Your Database the Relational Way.
Book II: Tables.
Chapter 1: Creating and Modifying Tables.
Chapter 2: Entering and Editing Data in Datasheets.
Chapter 3: Sorting, Finding, and Filtering Data.
Chapter 4: Importing and Exporting Data.
Chapter 5: Avoiding “Garbage In, Garbage Out”.
Chapter 6: Protecting Your Data with Referential Integrity.
Book III: Queries.
Chapter 1: Creating Select Queries.
Chapter 2: Letting Queries Do the Math.
Chapter 3: Doing Neat Things with Action Queries and Query Wizards.
Chapter 4: Viewing Your Data from All Angles Using Crosstabs and PivotTables.
Book IV: Forms.
Chapter 1: Designing and Using Forms (And Reports).
Chapter 2: Jazzing Up Your Forms (And Reports).
Chapter 3: Creating Smarter Forms.
Chapter 4: Doing Calculations in Forms (And Reports).
Book V: Reports.
Chapter 1: Creating and Spiffing Up Reports.
Chapter 2: Printing Beautiful Reports.
Chapter 3: Creating Charts and Graphs from Your Data.
Book VI: Macros: Automating Stuff in Access.
Chapter 1: Making Macros Do the Work.
Chapter 2: Making Macros Smarter.
Book VII: Database Administration.
Chapter 1: Database Housekeeping.
Chapter 2: Sharing the Fun — and the Database: Managing Multi-User Access.
Chapter 3: Securing Your Access Database.
Book VIII: Programming in VBA.
Chapter 1: What the Heck Is VBA?
Chapter 2: Writing Code.
Chapter 3: Writing Smarter Code.
Chapter 4: Controlling Forms with VBA.
Chapter 5: Using SQL and Recordsets.
Chapter 6: Debugging Your Code.
Chapter 7: Integrating Office Applications.
Book IX: Access on the Web.
Chapter 1: Creating Data Access Pages.
Chapter 2: Creating Access Projects.
Chapter 3: Introducing XML.
Appendix: Installing Microsoft Access.
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.
|MOM 2003 Database
Prior to writing Microsoft Access 2003 for All-In-One Reference Dummies, we developed a relatively simple order-entry database named MOM 2003 (for Mail Order Manager 2003) to use as an example throughout much of the book. Even though we don't refer to MOM 2003 very often in the book, many (but not all) of the sample tables, forms, reports and other objects actually come from that database.
From here, you can download two different versions of MOM 2003. The Sample Data version includes some hypothetical customers, vendors, products, and orders to play around with. The "clean" version contains all the same objects, but with no phony data. Use the clean version if you'd prefer to add your own real, or fake, data.
First a quick disclaimer. MOM 2003 is not a commercial software product and has not been tested extensively in the real world. It's simply a sample database that illustrates various ways of doing things in Microsoft Access 2003. As such, there is no official technical support (though you can always write us and ask us questions). And most importantly, there are no guarantees or warranties. It's strictly an as-is example for teaching and learning. If you plan to use it in an actual business, you do so at your own risk.
You can download either version, or both, by clicking the links. The files are stored in ZIP archives for easier downloading. If your computer can't open ZIP archives, try downloading the free trial of WinZip.
For more information, including instructions on using these files, you can visit the author's website.
|371.05 KB||Click to Download|
|MOM 2003 with Sample Data||511.32 KB||Click to Download|
|Custom VBA Functions
As promised, we've also included copies of many of the custom VBA functions described in Book 8 of Microsoft Access 2003 All-In-One Reference for Dummies. You can download Custom Functions.mdb, which contains all of the custom functions described in the book. You can then import any functions you wish into any database you create on your own.
The files is stored in a ZIP archive for easier downloading. If your computer can't open ZIP archives, try downloading the free trial of WinZip.
For more information, including instructions on using this file, you can visit the author's website.
|136.98 KB||Click to Download|
- Alan's Access Stuff: www.coolnerds.com/access
- Expert's Exchange: www.experts-exchange.com/Databases/MS_Access
- Microsoft Access Accounting Systems: www.granite.ab.ca/accsacct.htm
- Microsoft Access Advisor: http://accessadvisor.net
- Microsoft Access Compendium: www.cyber-matrix.com/access.htm
- Microsoft Access Help Centre: www.access-programmers.co.uk/
- Microsoft Access Tutorials: www.bcschools.net/staff/AccessHelp.htm
- Microsoft Developers' Network: http://msdn.microsoft.com/access
- Microsoft Help and Support (general): http://support.microsoft.com
- Microsoft Office Assistance Center: http://office.microsoft.com/assistance
- Microsoft's Access Assistance Center: http://search.office.microsoft.com/assistance/producttask.aspx?p=Access
- MS Access FAQ: www.trevor.easynet.co.uk/AccFAQ/
- MS Developer Applications: http://forums.compuserve.com/vlforums/default.asp?SRV=MSDevApps
- MSDN Library : http://msdn.microsoft.com/library
- Office Zealot: www.officezealot.com
- Search Microsoft: http://search.microsoft.com
- TechNet Online: www.microsoft.com/technet
- Tek-Tips Forums: www.tek-tips.com/gthreadminder.cfm/lev2/4/lev3/27/pid/181
- The Access Web: www.mvps.org/access
- The Access Web: www.hammerdata.com/Newsgrp
- Tony's Main Microsoft Access Page: www.granite.ab.ca/accsmstr.htm
- Woody's Office Portal: www.wopr.com/