Alan Simpson & Alison Barrows 
Microsoft Office Access 2007 All-in-One Desk Reference For Dummies [PDF ebook] 

Introduction.
Book I: Essential Concepts.
Chapter 1: Introducing Access 2007.
Chapter 2: Getting Started, Getting Around.
Chapter 3: Creating a Database from Templates.
Chapter 4: 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: Relating Your Tables and Protecting Your Data.
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
Pivot Tables.
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
Multiuser 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.
Appendix: Installing Microsoft Access.
Index.

Alan Simpson is the author of over 115 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
sold millions of copies. Though definitely in the techno-geek
category, we let him contribute anyway because sometimes people
like that come in handy.
Margaret Levine Young has co-authored several dozen
computer books about the Internet, UNIX, Word Perfect, Access, and
(stab from the past) PC-File and Javelin, including The Internet
For Dummies (Wiley) and Windows XP Home Edition: The
Complete Reference (Osborne/Mc Graw-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, Word Perfect, Lotus 1-2-3,
and other topics. In addition to writing books, Alison writes and
edits technical documentation and training material. In real life
she hangs out with her ‘guys’ — Parker, 6, and
Mason, 4, and Evan 2 — and tries to carve out some time to
practice yoga. Alison lives with her family in central
Massachusetts.
April Wells is a graduate of the University of Pittsburgh
and holds an MBA from West Texas A&M. She is a database
administrator with expertise in a wide variety of enterprise
database software programs, including Oracle, DB2, My SQL, and
Access. She is the author of several books and white papers on
database software and is a frequent public speaker, trainer, and
consultant.