Microsoft Access 2013 Inside Out

Overview

Conquer Microsoft Access 2013?from the inside out!

You?re beyond the basics, so dive right into Access 2013?and use your skills to create sophisticated database apps! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It?s all muscle and no ...

See more details below
Paperback
$35.64
BN.com price
(Save 28%)$49.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (16) from $23.99   
  • New (12) from $29.45   
  • Used (4) from $23.99   
Microsoft Access 2013 Inside Out

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

Overview

Conquer Microsoft Access 2013—from the inside out!

You’re beyond the basics, so dive right into Access 2013—and use your skills to create sophisticated database apps! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts tackle Access 2013—and challenge yourself to new levels of mastery.

  • Build an Access Services web app with Microsoft SharePoint Server
  • Automate your Access web app with data macros
  • Create tables in your Access web app using built-in templates
  • Aggregate and display your web app data using totals queries
  • Use the Autocomplete control to quickly search for related data
  • Create a Summary view to consolidate and group information
  • Display related data on your views with the Related Items control
  • Package your web app for use by others in your organization
  • Plus—download chapters on building desktop databases

For Intermediate and Advanced Users and Database Designers

Read More Show Less

Product Details

  • ISBN-13: 9780735671232
  • Publisher: Microsoft Press
  • Publication date: 7/26/2013
  • Series: Inside Out Series
  • Pages: 848
  • Sales rank: 255,356
  • Product dimensions: 7.40 (w) x 9.00 (h) x 1.90 (d)

Meet the Author

Jeff Conrad is a Software Design Engineer with the Access development team at Microsoft. He maintains a website with a wealth of information and resource links for those needing guidance with Access. Jeff is the author of Microsoft Access 2010 Inside Out.

Read More Show Less

Table of Contents

Introduction;
Who this book is for;
How this book is organized;
Features and conventions used in this book;
Your companion ebook;
About the companion content;
Acknowledgments;
Support and feedback;
Working with Access Services web apps;
Chapter 1: What is Access?;
1.1 What is a database?;
1.2 Access as an RDBMS;
1.3 Access as an application development system;
1.4 Deciding to move to database software;
1.5 Extending the power of Access to the web;
Chapter 2: Exploring the Access 2013 web app interface;
2.1 Working with web apps;
2.2 Opening Access for the first time;
2.3 Getting started with Access 2013;
2.4 Understanding the Office Fluent ribbon;
2.5 Working with the Navigation pane;
2.6 Searching for web app objects;
2.7 Working in the web app design environment;
2.8 Viewing your web app in a web browser;
2.9 Saving a web app as an app package;
2.10 Installing app packages;
Chapter 3: Designing tables in a web app;
3.1 Creating a new blank web app;
3.2 Creating tables using table templates;
3.3 Starting with a blank table;
3.4 Defining a table validation rule for web apps;
3.5 Defining a primary key for web apps;
3.6 Adding indexes;
3.7 Creating value list lookup fields in web apps;
3.8 Working with data in preview datasheets;
3.9 Creating relationships using lookup fields;
3.10 Importing and linking data into web apps;
Chapter 4: Creating data macros in web apps;
4.1 Uses of data macros;
4.2 Touring the Logic Designer;
4.3 Working with table events;
4.4 Working with named data macros;
4.5 Studying other named data macros;
4.6 Debugging data macros with the Trace table;
4.7 Understanding recursion in data macros;
4.8 Sharing data macro logic;
Chapter 5: Working with queries in web apps;
5.1 Selecting data from a single table;
5.2 Working in query preview Datasheet view;
5.3 Selecting data from multiple tables;
5.4 Summarizing information with totals queries;
5.5 Building a query on a query;
5.6 Using query parameters;
5.7 Selecting specific groups;
5.8 Working with unique values;
5.9 Using the Top Values query property;
Chapter 6: Working with views and the web browser experience;
6.1 Uses of views;
6.2 Understanding the App Home View;
6.3 Starting with quick-created views;
6.4 Working with views in a web browser;
Chapter 7: Advanced view design;
7.1 Creating Summary views;
7.2 Creating Blank views;
7.3 Defining subviews;
7.4 Using web browser controls;
7.5 Creating stand-alone views;
7.6 Understanding name fixup;
7.7 Applying themes to web app views;
7.8 Exploring sample views in the BOSS app;
7.9 Extending your web app with desktop database reports;
7.10 Managing external connections;
7.11 Setting SharePoint site permissions;
Chapter 8: Automating a web app using macros;
8.1 The macro design surface—an overview;
8.2 Working with view and control events;
8.3 Controlling record navigation with macros;
8.4 Creating an On Start macro;
8.5 Opening views with OpenPopup actions;
8.6 Exploring the audit invoices macros;
8.7 Exploring other named data macro parameter examples;
Creating tables in a desktop database;
Chapter 9: Exploring the Access 2013 desktop database interface;
9.1 Getting started with desktop databases;
9.2 Understanding content security;
9.3 Understanding the Office Fluent Ribbon;
9.4 Understanding the Navigation pane;
9.5 Using the single-document vs. the multiple-document interface;
Chapter 10: Designing tables in a desktop database;
10.1 Creating a new desktop database;
10.2 Creating your first simple table by entering data;
10.3 Creating a table using Application Parts;
10.4 Creating a table using Data Type Parts;
10.5 Creating a table in Design view;
10.6 Defining fields;
10.7 Defining a primary key;
10.8 Defining a table validation rule;
10.9 Understanding other table properties;
10.10 Defining relationships;
10.11 Adding indexes;
10.12 Setting table design options;
10.13 Database limitations;
Chapter 11: Modifying your table design;
11.1 Before You Get Started;
11.2 Deleting tables;
11.3 Renaming tables;
11.4 Changing field names;
11.5 Moving fields;
11.6 Inserting fields;
11.7 Copying fields;
11.8 Deleting fields;
11.9 Changing data attributes;
11.10 Reversing changes;
11.11 Taking a look at Lookup properties;
11.12 Working with Multi-Value Lookup Fields;
11.13 Compacting your database;
Installing your software;
Installing the Office system;
Converting from a previous version of Access;
Installing the Office 64-bit version;
Installing the sample files;
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)