Microsoft Access 2013

ISBN-10: 0735671230
ISBN-13: 9780735671232
Edition: 2014
Authors: Jeff Conrad
List price: $30.99
eBook available
This item qualifies for FREE shipping

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

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  More...

eBooks Starting from $39.99
Buy
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Italian Grammar Online content $4.95 $1.99
Add to cart
Study Briefs
Portuguese Grammar Online content $4.95 $1.99
Add to cart
Study Briefs
Spanish Grammar Online content $4.95 $1.99
Add to cart
Study Briefs
German Grammar Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

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

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 queriesAutomate your application with macrosDesign reports to calculate and highlight critical data

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

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×