* Updated to cover all the latest features and capabilities of
Access 2007, this resource provides new and inexperienced Access
users with eight task-oriented minibooks that cover begininning to
advanced-level material
* Each minibook covers a specific aspect of Access, such as
database design, tables, queries, forms, reports, and macros
* Shows how to accomplish specific tasks such as database
housekeeping, security data, and using Access with the Web
* Access is the world’s leading desktop database solution and is
used by millions of people to store, organize, view, analyze, and
share data, as well as to build powerful, custom database solutions
that integrate with the Web and enterprise data sources
Tabela de Conteúdo
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.
Sobre o autor
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.