Microsoft Access 2013

Name: Microsoft Access 2013
Price: 9.12 USD
Availability: InStock
ISBN: 9780735671232

ISBN-10: 0735671230

ISBN-13: 9780735671232

Edition: 2014

Authors: Jeff Conrad

List price: $30.99

30 day, 100% satisfaction guarantee!

Marketplace

1 new & used from $9.12

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

NOTE: This book is based on Office Customer Preview; its content and publication date will be updated for final Office 2013 software.You’re beyond the basics, so dive right in and really put Access 2013 to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting techniques, and workarounds. It’s all muscle and no fluff. Discover how the experts build and share data-centric apps that empower their organizations—and challenge yourself to new levels of mastery.Master essential data management and design techniquesBuild a browser-based database app using the new application modelCreate custom forms to capture and display dataModify data with action…

Book details

List price: $30.99
Copyright year: 2014
Publisher: Microsoft Press
Publication date: 7/15/2013
Binding: Paperback
Pages: 848
Size: 7.50" wide x 9.00" long x 2.00" tall
Weight: 2.948
Language: English

Jeff Conrad, best known as the "Access Junkie," is a Software Design Engineer in Test for the Access team at Microsoft. Jeff is the author of Microsoft Access 2010 Inside Out and co-author of Microsoft Office Access 2007 Inside Out. He was also a Microsoft MVP from 2005 through 2007 before joining the Access test team. Jeff maintains a website with a wealth of information and resource links for those needing guidance with Access. Visit http://www.AccessJunkie.com .



Introduction



Working with Access Services web apps



What is Access?


What is a database?


Relational databases


The architecture of Access


Database capabilities


Access as an RDBMS


Data definition and storage


Data manipulation


Data control


Access as an application development system


Deciding to move to database software


Extending the power of Access to the web



Exploring the Access 2013 web app interface


Working with web apps


Opening Access for the first time


Getting started with Access 2013


Opening a web app template


Exploring the Microsoft Office Backstage view


Taking Advantage of the Quick Access Toolbar


Understanding the Office Fluent ribbon


Working with the Navigation pane


Searching for web app objects


Working in the web app design environment


Add Tables screen


Table Selector


App Home View


View Selector


View preview window


Viewing your web app in a web browser


Saving a web app as an app package


Installing app packages


Uploading an app package to a SharePoint corporate catalog


Installing app packages from a SharePoint corporate catalog


Installing apps from the SharePoint Store


Installing apps directly into a SharePoint site


Creating a blank Access web app


Downloading a web app into Access



Designing tables in a web app


Creating a new blank web app


Creating tables using table templates


Starting with a blank table


Defining fields in web apps


Understanding field data types in web apps


Setting field properties


Completing the fields in the Vendors table


Creating calculated fields


Defining field validation rules for web apps


Defining a table validation rule for web apps


Defining a primary key for web apps


Adding indexes


Single-field indexes


Multiple-field indexes


Creating value list lookup fields in web apps


Working with data in preview datasheets


Creating relationships using lookup fields


Defining a restrict delete relationship


Defining a cascade delete relationship


Importing and linking data into web apps


Considerations for importing lookups


Importing Access desktop database tables


Importing a spreadsheet


Importing SQL tables


Importing a text file


Importing a list from a SharePoint site


Linking a SharePoint list into a web app



Creating data macros in web apps


Uses of data macros


Touring the Logic Designer


Working with table events


Using On Insert events


Using On Update events


Using On Delete events


Deleting table events


Working with named data macros


Creating named data macros


Using parameters


Saving named data macros


Calling named data macros


Renaming and deleting named data macros


Working with return variables


Studying other named data macros


Debugging data macros with the Trace table


Understanding recursion in data macros


Sharing data macro logic



Working with queries in web apps


Selecting data from a single table


Specifying fields


Viewing query results


Entering selection criteria


Using expressions


Using the Expression Builder


Sorting data


Working in query preview Datasheet view


Moving around and using keyboard shortcuts


Changing data


Sorting data


Filtering Data


Selecting data from multiple tables


Creating inner joins


Creating outer joins


Summarizing information with totals queries


Totals within groups


Selecting records to form groups


Building a query on a query


Using query parameters


Selecting specific groups


Working with unique values


Using the Top Values query property



Working with views and the web browser experience


Uses of views


Understanding the App Home View


Working with the Table Selector


Working with the View Selector


Starting with quick-created views


Working within the web design surface


Exploring Action Bar buttons


Defining view properties


Sizing and moving controls


Defining control properties


Understanding related items controls


Customizing Datasheet views


Working with views in a web browser


Navigating to records using the List Control


Filtering in views


Understanding view and edit mode


Using special controls for data entry


Using Datasheet views



Advanced view design


Creating Summary views


Creating Blank views


Defining subviews


Using web browser controls


Creating stand-alone views


Understanding name fixup


Adding fields


Renaming fields


Renaming objects


Deleting objects


Applying themes to web app views


Exploring sample views in the BOSS app


Extending your web app with desktop database reports


Managing external connections


Setting SharePoint site permissions



Automating a web app using macros


The macro design surface-an overview


Working with the Logic Designer


Saving your macro


Working with view and control events


Defining macros for view events


Defining macros for control events


Controlling record navigation with macros


Creating an On Start macro


Opening views with OpenPopup actions


Using Where clause syntax


Referencing other view control values


Passing parameters to views


Exploring the audit invoices macros


Using the SetProperty action with view controls


Calling named data macros and using return variables


Navigating to different views using ChangeView actions


Exploring other named data macro parameter examples



Creating tables in a desktop database



Exploring the Access 2013 desktop database interface


Getting started with desktop databases


Opening an existing desktop database


Exploring the Microsoft Office Backstage view


Modifying global settings via the Access Options dialog box


Taking advantage of the Quick Access Toolbar


Understanding content security


Enabling a database that is not trusted


Understanding the Trust Center


Enabling content by defining trusted locations


Understanding the Office Fluent Ribbon


Home tab


Create tab


External Data tab


Database Tools tab


Understanding the Navigation pane


Exploring Navigation pane object views


Working with custom categories and groups


Exploring the Navigation Options dialog box


Sorting and selecting views in the Navigation pane


Searching for database objects


Using the single-document vs. the multiple-document interface



Designing tables in a desktop database


Creating a new desktop database


Using a database template to create a desktop database


Creating a new empty database


Creating your first simple table by entering data


Creating a table using Application Parts


Creating a table using Data Type Parts


Creating a table in Design view


Defining fields


Understanding field data types


Setting field properties


Completing the fields in the Companies table


Defining simple field validation rules


Defining input masks


Defining a primary key


Defining a table validation rule


Understanding other table properties


Defining relationships


Defining your first relationship


Creating a relationship on multiple fields


Adding indexes


Single-field indexes


Multiple-field indexes


Setting table design options


Database limitations



Modifying your table design


Before You Get Started


Deleting tables


Renaming tables


Changing field names


Moving fields


Inserting fields


Copying fields


Deleting fields


Changing data attributes


Changing data types


Changing data lengths


Dealing with conversion errors


Changing other field properties


Reversing changes


Taking a look at Lookup properties


Working with Multi-Value Lookup Fields


Compacting your database



Installing your software


Installing the Office system


Choosing options when you have no previous version of the Office system


Choosing options to upgrade a previous version of the Office system


Converting from a previous version of Access


Conversion issues


Installing the Office 64-bit version


Installing the sample files


Index