Microsoft Office Access 2007 Plain & Simple

( 3 )
Other sellers (Paperback)
  • All (24) from $1.99   
  • Used (24) from $1.99   
Sending request ...


Here’s WHAT You’ll Learn

  • Easily navigate the new user interface
  • Design and build your own database
  • Build forms that help you collect information
  • Create charts and reports
  • Exchange data with other databases and documents
  • Help prevent unauthorized data access

Here’s HOW You’ll Learn It

  • Jump in wherever 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 you apply what you learn right away
Read More Show Less

Product Details

  • ISBN-13: 9780735622920
  • Publisher: Microsoft Press
  • Publication date: 2/14/2007
  • Series: Plain & Simple Series
  • Edition description: REV
  • Pages: 288
  • Sales rank: 1,512,991
  • Product dimensions: 7.30 (w) x 9.00 (h) x 0.50 (d)

Meet the Author

Curtis Frye is the author of numerous books on Excel and other Office products, most recently Microsoft Excel 2010 Step by Step. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.

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 2007;
2.1 Familiarizing Yourself with the New User Interface;
2.2 Formatting Database Objects Using New AutoFormats;
2.3 Creating New Types of Fields;
2.4 Collecting Data from E-mail Messages;
Chapter 3: Introducing Access 2007;
3.1 Introducing Databases;
3.2 Starting Access;
3.3 Surveying the Access Window;
3.4 Opening a Database;
3.5 Viewing Multiple Database Objects;
3.6 Closing a Database and Exiting Access;
3.7 Displaying and Managing Database Objects;
3.8 Using the Access Help System;
Chapter 4: Getting to Know Access Databases;
4.1 Viewing a Sample Database;
4.2 Working with Database Objects;
4.3 Examining a Table;
4.4 Examining a Form;
4.5 Examining a Query;
4.6 Examining a Report;
4.7 Using the Database Templates;
4.8 Frequently Used Object Views;
Chapter 5: Creating a Database;
5.1 Designing a Database;
5.2 Creating a New Database;
5.3 Creating a New Table in Design View;
5.4 Creating a New Table by Typing;
5.5 Adding Existing Fields to a Table;
5.6 Setting a Primary Key;
5.7 Getting Data from Other Access Tables;
5.8 Relationships Explained;
5.9 Creating Relationships between Tables;
5.10 Enforcing Referential Integrity;
Chapter 6: Customizing Fields;
6.1 Working with Tables;
6.2 Assigning a Data Type;
6.3 Viewing or Changing Field Properties;
6.4 Introducing the Expression Builder;
6.5 Formatting Field Contents;
6.6 Creating Input Masks;
6.7 Assigning Required Fields and Requiring Data Entry;
6.8 Setting Default Values;
6.9 Indexing Field Values;
6.10 Validating Data Entry;
6.11 Creating a Lookup Field;
6.12 Creating an Append-Only Memo Field;
6.13 Creating an Attachment Field;
Chapter 7: Customizing Tables;
7.1 Finding and Replacing Text;
7.2 Entering Data Using AutoCorrect;
7.3 Adding and Editing Text;
7.4 Manipulating Columns;
7.5 Modifying Columns and Rows;
7.6 Viewing a Subdatasheet;
7.7 Filtering Table Records;
Chapter 8: Creating Forms;
8.1 Creating a Simple Form;
8.2 Creating a Form Using the Form Wizard;
8.3 Creating a Form in Design View;
8.4 Creating a Multiple Items Form;
8.5 Modifying an Existing Form;
8.6 Adding and Deleting Form Controls;
8.7 Adding a Date Picker Control;
8.8 Creating a Subform;
8.9 Displaying a Form and Its Datasheet Simultaneously;
Chapter 9: Creating Queries;
9.1 Introducing Query Types;
9.2 Creating a Query Using the Query Wizard;
9.3 Editing a Query in Design View;
9.4 Using Criteria to Focus Query Results;
9.5 Introducing Operators;
9.6 Using Queries to Calculate Values;
9.7 Finding Duplicate Records;
9.8 Finding Unmatched Records;
9.9 Writing Query Results to a New Table;
9.10 Creating an Update Query;
9.11 Creating a Crosstab Query;
9.12 Finding the Largest and Smallest Values in a Field by Using a Query;
Chapter 10: Creating Reports;
10.1 Creating a Report Using the Report Wizard;
10.2 Creating a Summary Report;
10.3 Creating a Report in Design View;
10.4 Modifying an Existing Report;
10.5 Adding and Deleting Report Controls;
10.6 Calculating Values in a Report;
10.7 Introducing Report Sections;
10.8 Grouping Report Records;
10.9 Creating a Subreport;
10.10 Creating Mailing Labels;
Chapter 11: Beautifying Forms and Reports;
11.1 Formatting Text;
11.2 Applying AutoFormats;
11.3 Setting Control Appearance;
11.4 Adding Lines, Shapes, and Borders;
11.5 Editing Lines and Borders;
11.6 Showing Gridlines in a Report;
11.7 Coloring Alternate Rows in a Form or Report;
11.8 Adding a Totals Row to a Datasheet;
11.9 Adding a Picture;
11.10 Applying Conditional Formatting;
11.11 Changing the Source of an Image;
11.12 Setting Image Alignment and Backing Color;
11.13 Tiling a Picture;
11.14 Setting Image Height and Width;
Chapter 12: Creating Charts in Access;
12.1 Creating a Chart;
12.2 Formatting Chart Elements;
12.3 Customizing Chart Axes;
12.4 Add Information to a Chart;
12.5 Changing a Chart’s Type;
Chapter 13: Interacting with Other Programs;
13.1 Introducing Linking and Embedding;
13.2 Inserting a New Object;
13.3 Manipulating Objects;
13.4 Inserting Excel Charts and Worksheets;
13.5 Importing Data from Another Access Database;
13.6 Linking to a Table in Another Access Database;
13.7 Working with Hyperlinks;
13.8 Importing Data from an Excel File;
13.9 Importing Data from a Text File;
13.10 Importing Data from an XML File;
13.11 Exporting Data to a Text File;
13.12 Exporting Data to Another Access File;
13.13 Exporting Data to an XML File;
13.14 Saving Database Objects as Web Files;
13.15 Analyzing Data with Microsoft Excel;
13.16 Publishing Data to Microsoft Word;
13.17 Collecting Data from E-mail Messages;
Chapter 14: Administering a Database;
14.1 Introducing Database Security;
14.2 Encrypting a Database;
14.3 Locking Database Records;
14.4 Creating a Switchboard;
14.5 Documenting a Database;
14.6 Setting Startup Options;
Chapter 15: Customizing Access;
15.1 Adding Buttons to the Quick Access Toolbar;
15.2 Building a Macro;
15.3 Running a Macro;
15.4 Defining Macro Groups;
15.5 Adding and Deleting Macro Actions;
15.6 Launching a Macro from a Button;
15.7 Displaying a Message Box;
15.8 Running a Macro When a Form Opens;
15.9 Changing AutoCorrect Options;
Chapter 16: Presenting Table and Query Data Dynamically;
16.1 Introducing PivotTables and PivotCharts;
16.2 Creating a PivotTable;
16.3 Adding and Removing PivotTable Fields;
16.4 Pivoting a PivotTable;
16.5 Filtering PivotTable Data;
16.6 Formatting a PivotTable;
16.7 Creating a PivotChart;
About the Author;
Choose the Right Book for You;
Published and Upcoming Titles;

Read More Show Less

Customer Reviews

Average Rating 2.5
( 3 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & 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 & 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 & 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 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


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & 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 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 March 9, 2009

    Plain & Simple - Microsoft Office Access 2007.

    Very good book for beginners who basically never worked with Access. It gets you started on creating Access objects (tables, forms, reports, etc.). Does not go into depth on any one subject. Fairly easy to follow. Needless to say, you should have the software to work with. The publisher/author references objects that come with MS Access 2007 application. If the reader has their own data to create and work with, it may help the reader to more fully understand the relationships of the objects to each other.

    1 out of 1 people found this review helpful.

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

    Posted April 24, 2009

    No text was provided for this review.

  • Anonymous

    Posted May 28, 2010

    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)