Skip to content

Microsoft Access 2013

Spend $50 to get a free DVD!

ISBN-10: 0735671230

ISBN-13: 9780735671232

Edition: 2014

Authors: Jeff Conrad

List price: $30.99
Blue ribbon 30 day, 100% satisfaction guarantee!
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!


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…    
Customers also bought

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 .

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