Microsoft Access 2013 Plain & Simple

Overview

Learn the simplest ways to get things done with Microsoft Access 2013

Get the full-color, visual guide that makes learning Microsoft Access 2013 plain and simple! Follow the book?s easy steps and screenshots and clear, concise language to learn the simplest ways to build a...

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

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (18) from $3.59   
  • New (13) from $11.35   
  • Used (5) from $3.59   
Microsoft Access 2013 Plain & Simple

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • 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

Learn the simplest ways to get things done with Microsoft Access 2013

Get the full-color, visual guide that makes learning Microsoft Access 2013 plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to build a database and sort information.

Here’s WHAT you’ll learn:

  • Build and manage your own database
  • Apply professional designs across your databases
  • Create presentations and publish reports online
  • Secure your database with passwords and encryption
  • Exchange data with other databases and documents
  • Interact with your data easier using macros


Here’s HOW you’ll learn it:
  • Jump in wherever you need answers
  • Follow easy STEPS and SCREENSHOTS to see exactly what to do
  • Get handy TIPS for new techniques and shortcuts
  • Use TRY THIS! exercises to apply what you learn right away

Read More Show Less

Product Details

  • ISBN-13: 9780735669444
  • Publisher: Microsoft Press
  • Publication date: 4/2/2013
  • Series: Plain & Simple Series
  • Pages: 272
  • Sales rank: 576,499
  • Product dimensions: 9.00 (w) x 7.30 (h) x 0.70 (d)

Meet the Author

Andrew Couch is a Microsoft MVP for Access and an experienced instructor who has taught introductory and advanced Access courses as well as VBA programming courses. He is the author of Microsoft Access 2010 VBA Programming Inside Out.

Read More Show Less

Table of Contents

;
Chapter 1: About this book;
1.1 What’s new in Access 2013?;
1.2 A quick overview;
1.3 A few assumptions;
1.4 About the sample database;
1.5 Adapting task procedures for touchscreens;
1.6 A final word;
Chapter 2: Creating a custom Web App;
2.1 Starting Access;
2.2 Creating a custom Web App;
2.3 Adding a table template;
2.4 Showing the navigation pane;
2.5 Adding a blank table;
2.6 Launching a Web App;
2.7 Working with the List view;
2.8 Working with the Datasheet view;
2.9 Working with a summary view;
2.10 Finding your site and navigating to the team site;
2.11 Creating a Web App using a template;
Chapter 3: Modifying a Web App;
3.1 Importing from an Access desktop database;
3.2 Changing the design of a table;
3.3 Creating a lookup/relationship;
3.4 Designing with a List Details view;
3.5 Designing with a Datasheet view;
3.6 Designing with a summary view;
3.7 Designing with a blank view;
3.8 Open, rename, duplicate, or delete a view;
3.9 Creating a query;
3.10 Modifying the Table Selector;
3.11 Working with reports;
Chapter 4: Creating a desktop database;
4.1 Creating a blank desktop database;
4.2 Creating a table in design view;
4.3 Creating a table in layout view;
4.4 Working with data parts in layout view;
4.5 Creating a table by using application parts;
4.6 Adding a primary key;
4.7 Improving performance by indexing data;
4.8 Validate that data in a field is of the correct type;
4.9 Comparing field values by using table validation;
4.10 Formatting a field;
4.11 Recording changes to text and rich text formatting;
4.12 Creating relationships by using the Lookup Wizard;
4.13 Viewing relationships;
4.14 Deleting relationships;
4.15 Adding relationships;
Chapter 5: Working with data in datasheets;
5.1 Changing Access database options;
5.2 Altering the presentation by ordering, hiding, and freezing fields;
5.3 Moving between records and using Find And Replace;
5.4 Sorting datasheet rows;
5.5 Filtering datasheet rows;
5.6 Filtering combinations of choices with Filter By Form;
5.7 Filtering combinations of choices with Advanced Filter/Sort;
5.8 Inserting and updating records;
5.9 Deleting records;
5.10 Creating summary data for records;
5.11 Displaying related information with a subdatasheet;
5.12 Adjusting column/row height and formatting;
5.13 Selecting data to copy and paste;
5.14 Displaying more information with the Zoom box;
5.15 Changing the datasheet presentation;
Chapter 6: Selecting data using queries;
6.1 Selecting all columns from a table;
6.2 Selecting individual columns from one or more tables;
6.3 Joining tables to see unmatched or missing records;
6.4 Filtering by single and multiple combinations of choices;
6.5 Adding calculations with the expression builder;
6.6 Returning the top matched records;
6.7 Eliminating duplicate values;
6.8 Creating a summary calculation;
6.9 Prompting to filter data with parameters;
6.10 Creating a crosstab query with the Query Wizard;
6.11 Simplifying a problem with a query by using other queries;
6.12 Adding two sets of query results together;
6.13 Resolving ambiguous outer joins;
6.14 Creating an additional query to resolve a problem with mixed joins;
Chapter 7: Modifying data using queries;
7.1 Creating a table by using a Make Table query;
7.2 Changing data in a table with an Update query;
7.3 Adding data to an existing table with an Append query;
7.4 Deleting data in tables with a Delete query;
7.5 Updating a column based on an expression;
7.6 Adding only new data that is not already in a table;
7.7 Resetting an AutoNumber with an Append query;
Chapter 8: Improving presentations with forms;
8.1 Creating a continuous form with the multiple items template;
8.2 Creating a datasheet form with conditional formatting;
8.3 Creating a single record form with the Form Wizard;
8.4 Creating a split form;
8.5 Working with form views;
8.6 Working with control layouts;
8.7 Creating a parent/child form with the Form Wizard;
8.8 Altering link master and link child fields;
8.9 Controlling editing and data entry in a form;
8.10 Changing the data source for a form;
8.11 Organizing your database with navigation forms;
8.12 Adding fields to a form in design view;
8.13 Adding fields to a form in layout view;
8.14 Adding a subform to an existing form;
Chapter 9: Using controls effectively;
9.1 Creating labels and text boxes;
9.2 Creating lines and rectangles;
9.3 Creating check boxes, option buttons, and toggle buttons;
9.4 Creating option groups;
9.5 Creating list boxes;
9.6 Creating combo boxes;
9.7 Creating hyperlinks;
9.8 Creating logos and titles;
9.9 Creating bound and unbound object frames;
9.10 Creating image controls;
9.11 Creating attachments;
9.12 Creating web browser controls;
9.13 Working with tab controls;
9.14 Creating command buttons;
9.15 Setting control defaults;
9.16 Applying Office themes;
Chapter 10: Preparing data to print using reports;
10.1 Creating a tabular report with multiple tables;
10.2 Altering the presentation of controls on a page;
10.3 Working with controls and sections;
10.4 Using the Can Grow and Can Shrink Properties;
10.5 Adding a running sum;
10.6 Managing data and page breaks;
10.7 Adding sorting and grouping on reports;
10.8 Avoiding blank pages;
10.9 Adding conditional formatting;
10.10 Creating a single record report with the Report Wizard;
10.11 Creating a parent/child report;
10.12 Using labels and managing columns and rows;
10.13 Working with layout view, report view, and Print Preview;
Chapter 11: Exchanging data;
11.1 Importing data and objects from Access;
11.2 Linking to data in Access;
11.3 Importing data from Excel;
11.4 Linking to data in Excel;
11.5 Refreshing linked tables when files are changed;
11.6 Importing data from text files using specifications;
11.7 Exporting data to Excel;
11.8 Working with saved imports and exports;
11.9 Exporting data as PDF documents;
Chapter 12: Introducing the power of macros;
12.1 Enabling macro commands and disabling Trusted Documents;
12.2 Linking together forms;
12.3 Linking a form to a query;
12.4 Validating data entered in controls;
12.5 Making controls change other controls;
12.6 Processing data with action queries;
12.7 Executing a saved import/export;
Chapter 13: Administrating a database;
13.1 Compacting and repairing your database;
13.2 Analyzing your database;
13.3 Protecting your data;
13.4 Viewing object dependencies;
About the Author;

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)