Dummies.com
  • Print
  • Share
Microsoft Office Access 2007 All-in-One Desk Reference For Dummies (0470036494) cover image

Microsoft Office Access 2007 All-in-One Desk Reference For Dummies

ISBN: 978-0-470-03649-5
Paperback
768 pages
December 2006
US $29.99 Add to Cart
Other Available Formats: E-book
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 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 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.

Buy Both and Save 25%!

+ Buy Microsoft Office Access 2007 All-in-One Desk Reference For Dummies (List Price: US $29.99)
with Access 2010 For Dummies (List Price = US $24.99)
Total List Price: US $54.98
Discounted Price: US $41.23
You Save: US $13.75 Add BOTH to Cart
Cannot be combined with any other offers. Learn more.
  • Print
  • Share