You are previewing Extend Microsoft Access Applications to the Cloud.
O'Reilly logo
Extend Microsoft Access Applications to the Cloud

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

    1. Title Page
    2. Copyright Page
    3. Dedication Page
    4. Contents at a glance
    5. Contents
    6. Introduction
      1. Product updates and Office 365
      2. Choosing Access to develop in the cloud
      3. Web app software life cycle
      4. Reference material
      5. Who should read this book
      6. Organization of this book
      7. Conventions and features in this book
      8. System requirements
      9. Downloads: Companion content
        1. Installing the companion content
        2. Using the companion content
      10. Acknowledgments
      11. Errata, updates, & book support
      12. Free ebooks from Microsoft Press
      13. We want to hear from you
      14. Stay in touch
    7. Chapter 1. Finding your way around Office 365
      1. Office 365 subscriptions
      2. Office products in a browser
      3. Getting started with Office 365
      4. Team site, personal site, and public site
      5. Installing Office Professional
      6. OneDrive and OneDrive For Business 2013
      7. Creating a web app using a template
      8. Opening a web app with Access
      9. Saving a web app as a package
      10. Uploading a web app package
      11. Editing a web app package
      12. Displaying a web app in a browser
      13. Sharing a web app with external users
      14. Creating sites and subsites
      15. Creating site collections (Enterprise subscription)
      16. Applying a theme
      17. Document storage and libraries
      18. Microsoft Azure SQL Database, Office 365, and Access
      19. App Catalog
      20. Summary
    8. Chapter 2. Finding your way around Access 2013
      1. A new way of building applications
      2. Create a custom web app
      3. Importing data from Access
      4. Using the navigation pane
      5. Working with tables, lookups, and relationships
      6. Displaying data in a browser
      7. Working with different views
      8. Controls available in a view
        1. Autocomplete control
        2. Related items control
        3. Subview control
        4. Action bar
        5. List control
        6. Hyperlink control
        7. Multiline Text Box control
        8. Web Browser control
      9. Overview of macro programming and data macros
      10. Upgrading and deploying a web app
      11. Side-loading a web app
      12. Designing and commissioning with existing data
      13. Summary
    9. Chapter 3. Converting a desktop database to a web app
      1. Tables and primary key fields
      2. Relationships and lookups
      3. Table and field properties
      4. Boolean data
      5. Value-based lookups
      6. Multi-value data
      7. Importing different data types
        1. Long Text (memo data)
        2. Calculated fields
        3. Image data type
        4. Attachments and OLE objects
      8. Reporting
        1. References
        2. Quick conversion to external writer
      9. Attachment and OLE data
        1. Uploading multiple files
        2. Extracting attachment files
        3. Uploading image files
      10. Summary
    10. Chapter 4. Creating a blank web app and using templates
      1. Creating a blank web app
      2. Adding template tables
      3. Creating a new table
      4. Editing the design of a table
      5. Creating lookups and relationships
      6. Adding indexing
      7. Adding validation rules
      8. Adding calculated fields
      9. Summary
    11. Chapter 5. Displaying data in views
      1. Customizing the table selector
      2. Customizing the view selector
      3. Creating a pop-up window interface
      4. Datasheet view
      5. Views and record sources
      6. Duplicating views
      7. List Details view
      8. Summary view
      9. Standalone view
      10. Related items control
      11. Subview control
      12. View controls
      13. Combo box control
      14. Combo box synchronization
      15. Autocomplete control
      16. Web browser control
      17. Adding color to controls
      18. Summary
    12. Chapter 6. Creating data sources by using queries
      1. Creating basic queries
      2. Adding criteria to queries
      3. Adding calculations to queries
      4. Adding parameters to queries
      5. Totals and queries
      6. Top value queries
      7. Unique values in queries
      8. Summary
    13. Chapter 7. Programming a web app by using macros
      1. Macro-programming capabilities
      2. Macro editor and standalone user-interface macros
      3. User-interface events for views and controls
      4. User-interface macros
      5. Named data macros and stored procedures
      6. Data macros and triggers
      7. Data macro tracing
      8. On Start macro
      9. Transactions and recursion
        1. Indirect recursion
        2. Direct recursion
      10. Presenting a view for printing
      11. Creating a cross-tabulation of data
      12. Side-loading a web app
      13. On Deploy Macro
      14. Using an alias with a macro action
      15. Summary
    14. Chapter 8. Managing security and a public-facing web app
      1. Creating a public website
      2. Creating a public-facing web app in Office 365
      3. Managing security in a public web app
      4. Summary
    15. Chapter 9. Looking under the hood at Microsoft Azure SQL Database
      1. SQL Server Management Studio
      2. ODBC drivers
      3. Connecting to Microsoft Azure SQL Database
      4. Schemas
      5. Security in SSMS
      6. Linked Microsoft SharePoint lists
      7. Manually creating an ODBC DSN connection
      8. Linking from the desktop to use an ODBC connection
      9. Creating DSN-less connections with program code
      10. Extracting information on relationships
        1. Displaying structural information using data access objects
        2. Displaying structural information using ADOX
        3. Displaying structural information with a query
      11. Validation rules
      12. Data macros under the hood
      13. Views and table-valued functions
      14. Summary
    16. Chapter 10. Other techniques for reporting
      1. Excel and data connections
      2. Excel PowerPivot
      3. Creating a report for SQL Server Reporting Services
      4. Publishing a report to SSRS
      5. Linking a web app to an SSRS report
      6. Using Visual Studio 2013 with a web app
      7. Summary
    17. Chapter 11. Using apps for Office with Access
      1. Apps for Access concepts
      2. Consuming apps for Access
      3. Developing apps for Access
      4. Summary
    18. Index
    19. Back Cover
    20. Code Snippets