Extend Microsoft Access applications to the Cloud

635 Pages·2015·40.48 MB·English

by  Couch

Extend Microsoft Access Applications
to the Cloud
Andrew Couch
PUBLISHED BY
Microsoft Press
A division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399
Copyright © 2015 by Andrew Couch. All rights reserved.
No part of the contents of this book may be reproduced or transmitted in any
form or by any means without the written permission of the publisher.
Library of Congress Control Number: 2014946864
ISBN: 978-0-7356-6768-6
Printed and bound in the United States of America.
First Printing
Microsoft Press books are available through booksellers and distributors
worldwide. If you need support related to this book, email Microsoft Press Book
Support at [email protected]. Please tell us what you think of this book
at http://aka.ms/tellpress.
This book is provided “as-is” and expresses the author’s views and opinions.
The views, opinions and information expressed in this book, including URL and
other Internet website references, may change without notice.
Some examples depicted herein are provided for illustration only and are
fictitious. No real association or connection is intended or should be inferred.
Microsoft and the trademarks listed at http://www.microsoft.com on the
“Trademarks” webpage are trademarks of the Microsoft group of companies. All
other marks are property of their respective owners.
Acquisitions and Developmental Editor: Devon Musgrave
Project Editor: Rosemary Caperton
Editorial Production: Waypoint Press (www.waypointpress.com)
Technical Reviewer: Jeff Conrad
Copyeditor: Roger LeBlanc
Indexer: Cristina Yeager
Cover: Twist Creative • Seattle and Joel Panchot
For Charlotte and Michael. Thanks for all the fun and the way you
have enriched our lives.
—ANDREW COUCH
Contents at a glance
CHAPTER 1 Finding your way around Office 365
CHAPTER 2 Finding your way around Access 2013
CHAPTER 3 Converting a desktop database to a web app
CHAPTER 4 Creating a blank web app and using templates
CHAPTER 5 Displaying data in views
CHAPTER 6 Creating data sources by using queries
CHAPTER 7 Programming a web app by using macros
CHAPTER 8 Managing security and a public-facing web app
CHAPTER 9 Looking under the hood at Microsoft Azure SQL Database
CHAPTER 10 Other techniques for reporting
CHAPTER 11 Using apps for Office with Access
Contents
Introduction
Chapter 1 Finding your way around Office 365
Office 365 subscriptions
Office products in a browser
Getting started with Office 365
Team site, personal site, and public site
Installing Office Professional
OneDrive and OneDrive For Business 2013
Creating a web app using a template
Opening a web app with Access
Saving a web app as a package
Uploading a web app package
Editing a web app package
Displaying a web app in a browser
Sharing a web app with external users
Creating sites and subsites
Creating site collections (Enterprise subscription)
Applying a theme
Document storage and libraries
Microsoft Azure SQL Database, Office 365, and Access
App Catalog
Summary
Chapter 2 Finding your way around Access 2013
A new way of building applications
Create a custom web app
Importing data from Access
Using the navigation pane
Working with tables, lookups, and relationships
Displaying data in a browser
Working with different views
Controls available in a view
Autocomplete control
Related items control
Subview control
Action bar
List control
Hyperlink control
Multiline Text Box control
Web Browser control
Overview of macro programming and data macros
Upgrading and deploying a web app
Side-loading a web app
Designing and commissioning with existing data
Summary
Chapter 3 Converting a desktop database to a web app
Tables and primary key fields
Relationships and lookups
Table and field properties
Boolean data
Value-based lookups
Multi-value data
Importing different data types
Long Text (memo data)
Calculated fields
Image data type
Attachments and OLE objects
Reporting
References
Quick conversion to external writer
Attachment and OLE data
Uploading multiple files
Extracting attachment files
Uploading image files
Summary
Chapter 4 Creating a blank web app and using templates
Creating a blank web app
Adding template tables
Creating a new table
Editing the design of a table
Creating lookups and relationships
Adding indexing
Adding validation rules
Adding calculated fields
Summary
Chapter 5 Displaying data in views
Customizing the table selector
Customizing the view selector
Creating a pop-up window interface
Datasheet view
Views and record sources
Duplicating views
List Details view
Summary view
Standalone view
Related items control
Subview control
View controls
Combo box control
Combo box synchronization
Autocomplete control
Web browser control
Adding color to controls
Summary
Chapter 6 Creating data sources by using queries
Creating basic queries
Adding criteria to queries
Adding calculations to queries
Adding parameters to queries
Totals and queries
Top value queries
Unique values in queries
Summary
Chapter 7 Programming a web app by using macros
Macro-programming capabilities
Macro editor and standalone user-interface macros
User-interface events for views and controls
User-interface macros
Named data macros and stored procedures
Data macros and triggers
Data macro tracing
On Start macro
Transactions and recursion
Indirect recursion
Direct recursion
Presenting a view for printing
Creating a cross-tabulation of data
Side-loading a web app