Microsoft Access 2010 Plain & Simple

( 3 )

Overview

Get the guide that makes learning Microsoft Access 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to build a database and sort information, using easy-to-follow steps and concise, straightforward ...

See more details below
Paperback
$18.68
BN.com price
(Save 25%)$24.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (28) from $1.99   
  • New (17) from $14.31   
  • Used (11) from $1.99   
Microsoft Access 2010 Plain & Simple

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)
$11.49
BN.com price
(Save 42%)$19.99 List Price

Overview

Get the guide that makes learning Microsoft Access 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to build a database and sort information, using easy-to-follow steps and concise, straightforward language. You'll learn how out-of-the-box templates and reusable components make Access 2010 a fast and simple database solution.

Here's WHAT you'll learn:

  • Design and build your own database quickly
  • Use Access forms to collect information with ease
  • Create and modify tables to organize your data
  • Store files such as documents and images
  • Exchange data with other databases and documents
  • Bring your data alive with colorful reports


Here's HOW you'll learn it:
  • Jump in whenever you need answers
  • Easy-to-follow STEPS and SCREENSHOTS show exactly what to do
  • Handy TIPS teach new techniques and shortcuts
  • Quick TRY THIS! exercises help apply what you learn right away

Read More Show Less

Product Details

  • ISBN-13: 9780735627307
  • Publisher: Microsoft Press
  • Publication date: 6/15/2010
  • Pages: 288
  • Sales rank: 359,272
  • Product dimensions: 7.30 (w) x 9.10 (h) x 0.60 (d)

Meet the Author

Curtis D. Frye is a coauthor of Microsoft Office Excel 2003 Programming Inside Out and the author of Microsoft Office Excel 2007 Step by Step, Microsoft Excel Version 2007 Plain & Simple, Faster Smarter Home Networking, several books on Microsoft Access, and numerous online training courses.

Read More Show Less

Table of Contents

Chapter 1: Introduction: About This Book;
1.1 No Computerese!;
1.2 A Quick Overview;
1.3 A Few Assumptions;
1.4 A Final Word (or Two);
Chapter 2: What’s New in Access 2010?;
2.1 Managing Access Settings and Files in Backstage View;
2.2 Customizing the Access 2010 User Interface;
2.3 Creating Databases Using Improved Templates;
2.4 Building Databases by Re-Using Application Parts;
2.5 Creating Navigation Forms;
2.6 Formatting Database Objects Using Office Themes;
2.7 Gaining Insights into Data Using Conditional Formatting;
2.8 Defining Calculated Fields Using the Improved Expression Builder;
Chapter 3: Introducing Access 2010;
3.1 Introducing Databases;
3.2 Starting Access 2010;
3.3 Surveying the Access 2010 Window;
3.4 Opening a Database;
3.5 Viewing Multiple Database Objects;
3.6 Closing a Database and Exiting Access 2010;
3.7 Displaying and Managing Database Objects;
3.8 Using the Access 2010 Help System;
Chapter 4: Creating a Database;
4.1 Designing a Database;
4.2 Viewing a Sample Database;
4.3 Creating a New Database;
4.4 Creating Databases Using Database Templates;
4.5 Creating a New Table in Design View;
4.6 Creating a New Table by Typing;
4.7 Creating a New Table Using a Template;
4.8 Creating a New Table Using Application Parts;
4.9 Setting a Primary Key;
4.10 Getting Data from Other Access 2010 Tables;
4.11 Relationships Explained;
4.12 Creating Relationships Between Tables;
4.13 Enforcing Referential Integrity;
Chapter 5: Customizing Fields;
5.1 Working with Tables;
5.2 Assigning a Data Type;
5.3 Viewing or Changing Field Properties;
5.4 Introducing the Expression Builder;
5.5 Formatting Field Contents;
5.6 Creating Input Masks;
5.7 Assigning Required Fields and Requiring Data Entry;
5.8 Setting Default Values;
5.9 Indexing Field Values;
5.10 Validating Data Entry;
5.11 Creating a Lookup Field;
5.12 Creating an Append-Only Memo Field;
5.13 Creating an Attachment Field;
Chapter 6: Customizing Tables;
6.1 Finding and Replacing Text;
6.2 Entering Data Using AutoCorrect;
6.3 Adding and Editing Text;
6.4 Manipulating Columns;
6.5 Modifying Columns and Rows;
6.6 Viewing a Subworksheet;
6.7 Filtering Table Records;
Chapter 7: Creating Forms;
7.1 Creating a Simple Form;
7.2 Creating a Form Using the Form Wizard;
7.3 Creating a Form in Design View;
7.4 Creating a Multiple Items Form;
7.5 Modifying an Existing Form;
7.6 Adding and Deleting Form Controls;
7.7 Adding a Date Picker Control;
7.8 Creating a Subform;
7.9 Displaying a Form and Its Datasheet Simultaneously;
Chapter 8: Creating Queries;
8.1 Introducing Query Types;
8.2 Creating a Query Using the Query Wizard;
8.3 Editing a Query in Design View;
8.4 Using Criteria to Focus Query Results;
8.5 Introducing Operators;
8.6 Using Queries to Calculate Values;
8.7 Creating a Parameter Query;
8.8 Finding Duplicate Records;
8.9 Finding Unmatched Records;
8.10 Writing Query Results to a New Table;
8.11 Creating an Update Query;
8.12 Creating a Crosstab Query;
8.13 Finding the Largest and Smallest Values in a Field by Using a Query;
Chapter 9: Creating Reports;
9.1 Creating a Report Using the Report Wizard;
9.2 Creating a Summary Report;
9.3 Creating a Report in Design View;
9.4 Modifying an Existing Report;
9.5 Adding and Deleting Report Controls;
9.6 Calculating Values in a Report;
9.7 Introducing Report Sections;
9.8 Grouping Report Records;
9.9 Creating a Subform or Subreport;
9.10 Creating Mailing Labels;
Chapter 10: Beautifying Forms and Reports;
10.1 Formatting Text;
10.2 Introducing Office Themes;
10.3 Applying Office Themes;
10.4 Setting Control Appearance;
10.5 Adding Lines, Shapes, and Borders;
10.6 Showing Gridlines in a Report;
10.7 Coloring Alternate Rows in a Form or Report;
10.8 Adding a Totals Row to a Worksheet;
10.9 Adding a Picture;
10.10 Applying Conditional Formatting;
10.11 Changing the Source of an Image;
10.12 Setting Image Alignment and Backing Color;
10.13 Tiling a Picture;
10.14 Setting Image Height and Width;
Chapter 11: Creating Charts in Access 2010;
11.1 Creating a Chart;
11.2 Formatting Chart Elements;
11.3 Customizing Chart Axes;
11.4 Add Information to a Chart;
11.5 Changing a Chart’s Type;
Chapter 12: Interacting with Other Programs;
12.1 Introducing Linking and Embedding;
12.2 Inserting a New Object;
12.3 Manipulating Objects;
12.4 Inserting Excel 2010 Charts and Worksheets;
12.5 Importing Data from Another Access 2010 Database;
12.6 Linking to a Table in Another Access 2010 Database;
12.7 Working with Hyperlinks;
12.8 Importing Data from an Excel 2010 File;
12.9 Importing Data from a Text File;
12.10 Importing Data from an XML File;
12.11 Exporting Data to a Text File;
12.12 Exporting Data to Another Access 2010 File;
12.13 Exporting Data to an XML File;
12.14 Saving Database Objects As Web Files;
12.15 Analyzing Data with Excel 2010;
12.16 Publishing Data to Word 2010;
12.17 Collecting Data from E-mail Messages;
Chapter 13: Administering a Database;
13.1 Introducing Database Security;
13.2 Encrypting a Database;
13.3 Locking Database Records;
13.4 Creating a Navigation Form;
13.5 Documenting a Database;
13.6 Setting Startup Options;
Chapter 14: Customizing Access 2010;
14.1 Adding Commands to the Quick Access Toolbar;
14.2 Modifying the Ribbon User Interface;
14.3 Changing AutoCorrect Options;
Chapter 15: Presenting Table and Query Data Dynamically;
15.1 Introducing PivotTables and PivotCharts;
15.2 Creating a PivotTable;
15.3 Adding and Removing PivotTable Fields;
15.4 Pivoting a PivotTable;
15.5 Filtering PivotTable Data;
15.6 Formatting a PivotTable;
15.7 Creating a PivotChart;
About the Author;

Read More Show Less

Customer Reviews

Average Rating 3
( 3 )
Rating Distribution

5 Star

(0)

4 Star

(2)

3 Star

(0)

2 Star

(0)

1 Star

(1)

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 all of 3 Customer Reviews
  • Anonymous

    Posted January 3, 2012

    Good for the visual learner

    I found this book very useful. I am about 2/3 of the way through. I decided to start from the beginning and work my way through rather than looking for specific topics. The language is very user-friendly (thesaurus not required) and the visuals were extremely helpful. This book is better suited for someone who already has familiarity with Microsoft Access. For a novice or beginner, I recommend purchasing this book in conjunction with another title.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted December 6, 2011

    Bad purchase

    It touches many subjects but does not give you enough information about any one of them to help.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted September 15, 2011

    No text was provided for this review.

Sort by: Showing all of 3 Customer Reviews

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