Access 2007 All-in-One Desk Reference For Dummies (For Dummies Series)

( 1 )

Overview

  • 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, ...
See more details below
Paperback
$22.77
BN.com price
(Save 24%)$29.99 List Price
Other sellers (Paperback)
  • All (47) from $1.99   
  • New (12) from $2.00   
  • Used (35) from $1.99   

Overview

  • 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
Read More Show Less

Product Details

  • ISBN-13: 9780470036495
  • Publisher: Wiley
  • Publication date: 12/26/2006
  • Series: For Dummies Series
  • Edition number: 1
  • Pages: 736
  • Sales rank: 799,637
  • Product dimensions: 9.10 (w) x 10.88 (h) x 1.63 (d)

Meet the Author

Alan Simpson is the author of over 115 computer books on allsorts of topics: Windows, databases, Web-site design anddevelopment, programming, and network administration. His books arepublished throughout the world, in over a dozen languages, and havesold millions of copies. Though definitely in the techno-geekcategory, we let him contribute anyway because sometimes peoplelike that come in handy.

Margaret Levine Young has co-authored several dozencomputer books about the Internet, UNIX, WordPerfect, Access, and(stab from the past) PC-File and Javelin, including The InternetFor Dummies (Wiley) and Windows XP Home Edition: TheComplete Reference (Osborne/McGraw-Hill). She met her futurehusband Jordan in the R.E.S.I.S.T.O.R.S., a high-school computerclub before there were high-school computer clubs. Her otherpassions are her children, music, Unitarian Universalism(www.uua.org), reading, and anything to do with cooking oreating.

Alison Barrows has authored or co-authored books onWindows, the Internet, Microsoft Access, WordPerfect, Lotus 1-2-3,and other topics. In addition to writing books, Alison writes andedits technical documentation and training material. In real lifeshe hangs out with her “guys” — Parker, 6, andMason, 4, and Evan 2 — and tries to carve out some time topractice yoga. Alison lives with her family in centralMassachusetts.

April Wells is a graduate of the University of Pittsburghand holds an MBA from West Texas A&M. She is a databaseadministrator with expertise in a wide variety of enterprisedatabase software programs, including Oracle, DB2, MySQL, andAccess. She is the author of several books and white papers ondatabase software and is a frequent public speaker, trainer, andconsultant.

Read More Show Less

Table of Contents

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 QueryWizards.

Chapter 4: Viewing Your Data from All Angles Using Crosstabs andPivotTables.

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: ManagingMultiuser 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.

Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Posted October 25, 2011

    Great reference

    Unlike some technical compuer books, the Dummies books give just enough information and not too much. Access 2007 is no exception, plus it combines 8 Access help books in one. Included section on visual basic that is clear and concise.
    I haven't used Access for a few years.....this book was all I needed to get back to using Access.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)