Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Handheld Computing
Hardware
Money Management Software
Multimedia
Office Productivity Software
Operating Systems

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


By Alan Simpson, Margaret Levine Young, Alison Barrows, April Wells, Jim McCarter

ISBN: 978-0-470-03649-5
Format: Paper
Pages: 768 Pages
Pub. Date: December 2006

E-mail a Friend About This Book
Price: $29.99
Description
Author Information
Table of Contents
Read Excerpt: Chapter (PDF)
Read Excerpt: Table of Contents (PDF)
Read Excerpt: Index (PDF)
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.

Related Articles
Office 2007: Sharing Data with the Office Clipboard
Adding and Removing Tables in Microsoft Access 2007
Exporting Access 2007 Tables to Other File Formats
Creating a Calculated Field with Access 2007
Adding a Logo to Access 2007 Reports
Related Titles
Microsoft Office Live For Dummies
Access 2007 Workbook For Dummies
Microsoft Office 2000 9 in 1 For Dummies Desk Reference
Microsoft Office 2000 For Windows For Dummies
Microsoft Office 2000 for Windows For Dummies: Quick Reference