New book: Extend Microsoft Access Applications to the Cloud

We’re pleased to announce the availability of Extend Microsoft Access Applications to the Cloud (ISBN 9780735667686), by Andrew Couch.

Purchase from these online retailers:
Microsoft Press Store
Amazon.com
Barnes & Noble
Independent booksellers – Shop local

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 Couch guides you through the entire web app lifecycle, from design through deployment and upgrades. After introducing Office 365 and the web app development environment, he reviews key issues associated with moving data into a web app or creating cloud apps with new data. Next, he drills down into app construction, from table design to integration. You’ll learn how to extend Access with Azure SQL, PowerPivot, Visual Studio 2013, SSRS, and Apps for Office and master important new enhancements in Office 365 SP1. A start-to-finish case study covers every step of creating and securing a public-facing Access web app on your Office 365 website.

Microsoft Access MVP Andrew Couch shows how to:

· Leverage key Microsoft Office 365 features in your Access web apps

· Design and integrate all your Access web app’s features

· Make your desktop database compatible with web app table structures

· Start new web apps fast with templates

· Use views and controls to display and interact with web app data

· Quickly create web app interfaces with the table selector and popup views

· Define data sources with queries and work with calculations and parameters

· Design, test, and troubleshoot Data Macros

· Implement business rules using the Macro Programming Tools

· Understand how your app design translates to objects in the cloud-based Microsoft Azure SQL Database

· Use SQL Server Management Studio (SSMS) to connect with and manage web apps

· Improve reporting with PowerPivot, Visual Studio 2013, and SSRS

· Extend web apps with Apps for Office features

· Leverage Office 365 SP1 improvements in change deployment, intellectual property protection, and integration

About the author
Andrew Couch has worked with Microsoft Access since 1992 as a developer, trainer, and consultant. A founder of the UK Access User Group, he has been a Microsoft Access MVP for the past 7 years. His Microsoft Press books include Microsoft Access 2013 Plain & Simple and Microsoft Access 2010 VBA Programming INSIDE OUT. He also writes technical articles about Access at www.upsizing.co.uk/TechLibrary.aspx.