Extend Microsoft Access Applications to the Cloud

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 life cycle, from design through deployment and upgrades. After introducing Microsoft 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 Microsoft Azure SQL, PowerPivot, Visual Studio 2013, SQL Server Reporting Services (SSRS), and Apps for Office, and master important new enhancements in Office 365 SP1.

Learn best practices and techniques to:

• Capitalize on key Office 365 features in your Access web apps
• Design and integrate all the features of Access web apps
• Make your desktop databases compatible with web app table structures
• Implement and test business rules by using the Macro Programming Tools
• Understand how your app design translates to objects in the cloud-based Azure SQL Database
• Use Microsoft SQL Server Management Studio (SSMS) to connect with and manage web apps
• Improve reporting with PowerPivot, Visual Studio 2013, and SSRS
• Extend Access web apps with Apps for Office features
• Capitalize on Office 365 SP1 improvements in change deployment, intellectual property protection, and integration

Get all code samples, including complete apps, at: http://aka.ms/AccessApps/files

About This Book

• For experienced Access developers who want a deep understanding of web app design and implementation
• For new web app developers who want to develop Access web apps with Office 365

Table of Contents

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