Overview

Learn to:

  • Navigate the Access interface and understand database architecture
  • Build tables to organize data and create forms for easy data entry
  • Query your data and produce reports
  • Build custom interfaces for all users

Drowning in data? Manage it all and make it useful with the tools in Access 2013

You ...

See more details below
Access 2013 For Dummies

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$13.99
BN.com price
(Save 44%)$24.99 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.

Overview

Learn to:

  • Navigate the Access interface and understand database architecture
  • Build tables to organize data and create forms for easy data entry
  • Query your data and produce reports
  • Build custom interfaces for all users

Drowning in data? Manage it all and make it useful with the tools in Access 2013

You need Access. You need it to organize your data, produce reports that make you look like a genius, create forms that enable your staff to enter and manage more data, and find the significant drop of data you're looking for in that huge pool of information. This book is the key that unlocks the Access magic — read on, and access the power!

  • Essential Access — learn what Access can do, navigate the workspace and new features, and master the lingo
  • Begin building — plan your database, decide how to structure it and what to store, explore templates, and build tables
  • Share data — reduce data-entry errors by bringing content into your database from text files and Excel
  • Web publishing — add hyperlinks to your database and publish data online
  • Info, please — use the Find, Sort, and Filter commands to locate the information you need quickly
  • Rave reports — create quick one-table or multi-table reports, and learn to spruce up the work with the Report Wizard
  • Analyze this — explore Analyzer tools that help document your database and fine-tune its performance

Open the book and find:

  • Advice on building a new database
  • The difference between flat-file and relational databases
  • A review of new features
  • Ways to repurpose reports and forms
  • How Access works with the web
  • Guidance on finding, filtering, and sorting data
  • Directions for creating mass mailings from Access
  • Ten tips for Access success
Read More Show Less

Product Details

  • ISBN-13: 9781118568507
  • Publisher: Wiley
  • Publication date: 3/14/2013
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 456
  • Sales rank: 168,261
  • File size: 16 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Laurie Ulrich Fuller is a professional technology trainer and author. She has written books on Excel, Photoshop, and Dreamweaver. Ken Cook is a professional database developer and author who has written extensively on Access and Excel.

Read More Show Less

Table of Contents

Introduction  1

Part I: Getting Started with Access 2013  9

Chapter 1: Access 2013 Basic Training 11

Chapter 2: Navigating the Access Workspace 33

Chapter 3: Database Basics 55

Part II: Setting the Table  73

Chapter 4: Table Tune Ups 75

Chapter 5: Remodeling Your Data 91

Chapter 6: Types, Masks, and Triggers 109

Part III: Data Management Mania  131

Chapter 7: A Form for All Reasons 133

Chapter 8: Importing and Exporting Data 147

Chapter 9: Automatic Data Editing 159

Chapter 10: Access and the Web 171

Part IV: Ask Your Data, and Ye Shall Receive Answers  193

Chapter 11: Finding, Filtering, and Sorting Your Data — Fast 195

Chapter 12: I Was Just Asking for Answers 211

Chapter 13: I Want These AND Those OR Them 237

Chapter 14: Number Crunching with the Total Row 245

Chapter 15: Express Yourself with Formulas 257

Chapter 16: Take Charge with Action Queries 271

Part V: Simple and Snazzy Reporting  281

Chapter 17: Fast and Furious Automatic Reporting 283

Chapter 18: Professionally Designed Reports Made Easy 305

Chapter 19: Headers and Footers and Groups, Oh My! 331

Chapter 20: Magical Mass Mailings 353

Part VI: More Power to You  361

Chapter 21: Analyze This! 363

Chapter 22: Steer Users in the Right Direction with Navigation Forms 375

Part VII: The Part of Tens  383

Chapter 23: Ten Common Problems 385

Chapter 24: Ten Uncommon Tips 397

Appendix: Getting Help  405

Index  413

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

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

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