Book description
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
Table of contents
- Microsoft Access 2013 Inside Out
- Dedication
- Introduction
-
I. Working with Access Services web apps
- 1. What is Access?
-
2. Exploring the Access 2013 web app interface
- Working with web apps
- Opening Access for the first time
- Getting started with Access 2013
- Understanding the Office Fluent ribbon
- Working with the Navigation pane
- Searching for web app objects
- Working in the web app design environment
- Viewing your web app in a web browser
- Saving a web app as an app package
- Installing app packages
-
3. Designing tables in a web app
- Creating a new blank web app
- Creating tables using table templates
- Starting with a blank table
- Defining a table validation rule for web apps
- Defining a primary key for web apps
- Adding indexes
- Creating value list lookup fields in web apps
- Working with data in preview datasheets
- Creating relationships using lookup fields
- Importing and linking data into web apps
-
4. Creating data macros in web apps
- Uses of data macros
- Touring the Logic Designer
-
Working with table events
-
Using On Insert events
- Including comments
- Grouping macros
- Raising errors in data macros to cancel events
- Testing your data macro
- Using If blocks to create conditional expressions
- Using LookupRecord data blocks to find records
- Using local variables
- Collapsing and expanding actions
- Moving actions
- Studying other On Insert events
- Using On Update events
- Using On Delete events
- Deleting table events
-
Using On Insert events
- Working with named data macros
- Studying other named data macros
- Debugging data macros with the Trace table
- Understanding recursion in data macros
- Sharing data macro logic
- 5. Working with queries in web apps
-
6. Working with views and the web browser experience
- Uses of views
- Understanding the App Home View
- Starting with quick-created views
- Working with views in a web browser
-
7. Advanced view design
- Creating Summary views
- Creating Blank views
- Defining subviews
- Using web browser controls
- Creating stand-alone views
- Understanding name fixup
- 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
- 8. Automating a web app using macros
-
II. Creating tables in a desktop database
- 9. Exploring the Access 2013 desktop database interface
-
10. Designing tables in a desktop database
- Creating a new desktop 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
- Defining a primary key
- Defining a table validation rule
- Understanding other table properties
- Defining relationships
- Adding indexes
- Setting table design options
- Database limitations
- 11. Modifying your table design
- A. Installing your software
- B. About the author
- Index
- About the Author
- Copyright
Product information
- Title: Microsoft Access 2013 Inside Out
- Author(s):
- Release date: July 2013
- Publisher(s): Microsoft Press
- ISBN: 9780735672291
You might also like
book
Microsoft Access 2013 Plain & Simple
Learn the simplest ways to get things done with Microsoft Access 2013 Get the full-color, visual …
book
Microsoft Office® Access 2007 Inside Out
You’re beyond the basics, so dive right in and really put your database skills to work! …
book
Microsoft Outlook 2013 Inside Out
Conquer Microsoft Outlook—from the inside out! Dive into Outlook 2013—and really take control of your communications …
video
Using Microsoft Access 2010
Using Microsoft Access 2010brings you over 80 media elements detailing everything from how to manipulate data …