Book description
Learn how to create an Access web app, and move your database into the cloud. This practical book shows you how to design an Access web app for Microsoft Office 365, and convert existing Access desktop databases to a web app as well. You’ll quickly learn your way around the web app design environment, including how to capitalize on its strengths and avoid the pitfalls. You don’t need any special web skills to get started.
Discover how to:
Make your desktop database compatible with web app table structures
Create tables, views, and queries
Customize the table selector and work with popup views to provide a navigation interface
Implement business rules using the Macro Programming Tools
Develop using Office 365 and SharePoint 2013
Use SQL Azure to investigate how your web app is structured
Design, test, and troubleshoot Data Macros
Understand how security links between a web app and Office 365
Deploy a public facing web app on your Office 365 public website
Table of contents
- Title Page
- Copyright Page
- Dedication Page
- Contents at a glance
- Contents
-
Introduction
- Product updates and Office 365
- Choosing Access to develop in the cloud
- Web app software life cycle
- Reference material
- Who should read this book
- Organization of this book
- Conventions and features in this book
- System requirements
- Downloads: Companion content
- Acknowledgments
- Errata, updates, & book support
- Free ebooks from Microsoft Press
- We want to hear from you
- Stay in touch
-
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
- 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
- Chapter 4. Creating a blank web app and using templates
-
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
-
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
- Presenting a view for printing
- Creating a cross-tabulation of data
- Side-loading a web app
- On Deploy Macro
- Using an alias with a macro action
- Summary
- Chapter 8. Managing security and a public-facing web app
-
Chapter 9. Looking under the hood at Microsoft Azure SQL Database
- SQL Server Management Studio
- ODBC drivers
- Connecting to Microsoft Azure SQL Database
- Schemas
- Security in SSMS
- Linked Microsoft SharePoint lists
- Manually creating an ODBC DSN connection
- Linking from the desktop to use an ODBC connection
- Creating DSN-less connections with program code
- Extracting information on relationships
- Validation rules
- Data macros under the hood
- Views and table-valued functions
- Summary
- Chapter 10. Other techniques for reporting
- Chapter 11. Using apps for Office with Access
- Index
- Back Cover
- Code Snippets
Product information
- Title: Extend Microsoft Access Applications to the Cloud
- Author(s):
- Release date: February 2015
- Publisher(s): Microsoft Press
- ISBN: 9780133966244
You might also like
book
Alison Balter’s Mastering Microsoft® Office Access 2007 Development
Microsoft Office 2007 is a major upgrade from the last version of Office; Access will also …
book
Microsoft® Access® 2010 In Depth
Access 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their …
book
Access™ 2007 VBA Bible: For Data-Centric Microsoft® Office Applications
Learn how to tap the full potential of Access 2007 Transfer Access data seamlessly between Microsoft …
book
Microsoft® Excel® 2010 Formulas & Functions Inside Out
Conquer Microsoft Excel formulas and functions—from the inside out! You’re beyond the basics, so dive right …