ebook img

Extend Microsoft Access Applications to the Cloud PDF

635 Pages·2016·40.47 MB·English
Save to my drive
Quick download
Download
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.

Preview Extend Microsoft Access Applications to the Cloud

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

Description:
Microsoft Press, 2015. — 432 p. — ISBN-10: 0735667683, ISBN-13: 978-0735667686.Build new Access cloud web apps and migrate desktop databases to the cloud.This is your complete, practical guide to creating Microsoft Access web apps and migrating existing databases to the cloud. Access MVP Andrew
See more

The list of books you might like

Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.