商品描述
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:
Get all code samples, including complete apps, at: http://aka.ms/AccessApps/files
About This Book
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
商品描述(中文翻譯)
建立新的 Access 雲端網頁應用程式並將桌面資料庫遷移至雲端
這是您創建 Microsoft Access 網頁應用程式和將現有資料庫遷移至雲端的完整實用指南。Access MVP Andrew Couch 將引導您了解整個網頁應用程式的生命週期,從設計到部署和升級。在介紹 Microsoft Office 365 和網頁應用程式開發環境後,他將回顧與將資料移入網頁應用程式或使用新資料創建雲端應用程式相關的關鍵問題。接下來,他將深入探討應用程式的構建,從表格設計到整合。您將學習如何使用 Microsoft Azure SQL、PowerPivot、Visual Studio 2013、SQL Server Reporting Services (SSRS) 和 Apps for Office 擴展 Access,並掌握 Office 365 SP1 中的重要新增強功能。
學習最佳實踐和技術以:
- 利用 Access 網頁應用程式中的關鍵 Office 365 功能
- 設計和整合 Access 網頁應用程式的所有功能
- 使您的桌面資料庫與網頁應用程式的表格結構相容
- 使用宏程式設計工具實施和測試業務規則
- 了解您的應用程式設計如何轉換為雲端 Azure SQL 資料庫中的物件
- 使用 Microsoft SQL Server Management Studio (SSMS) 連接和管理網頁應用程式
- 使用 PowerPivot、Visual Studio 2013 和 SSRS 改善報告
- 使用 Apps for Office 功能擴展 Access 網頁應用程式
- 利用 Office 365 SP1 在變更部署、智慧財產權保護和整合方面的改進
獲取所有程式碼範例,包括完整的應用程式,請訪問:http://aka.ms/AccessApps/files
關於本書
- 適合希望深入了解網頁應用程式設計和實施的經驗豐富的 Access 開發人員
- 適合希望使用 Office 365 開發 Access 網頁應用程式的新手網頁應用程式開發人員