- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
Build new Access cloud web apps and migrate desktop databases to the cloudThis 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 appsDesign and integrate all the features of Access web appsMake your desktop databases compatible with web app table structuresImplement and test business rules by using the Macro Programming ToolsUnderstand how your app design translates to objects in the cloud-based Azure SQL DatabaseUse Microsoft SQL Server Management Studio (SSMS) to connect with and manage web appsImprove reporting with PowerPivot, Visual Studio 2013, and SSRSExtend Access web apps with Apps for Office featuresCapitalize on Office 365 SP1 improvements in change deployment, intellectual property protection, and integrationGet all code samples, including complete apps, at: http://aka.ms/AccessApps/filesAbout This BookFor 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
Contents
Introduction iChapter 1 Finding your way around Office 365 1Office 365 subscriptions 2Office products in a browser 5Getting started with Office 365 5Team site, personal site, and public site 7Installing Office Professional 10OneDrive and OneDrive For Business 2013 13Creating a web app using a template 19Opening a web app with Access 23Saving a web app as a package 24Uploading a web app package 26Editing a web app package 30Displaying a web app in a browser 32Sharing a web app with external users 32Creating sites and subsites 36Creating site collections (Enterprise subscription) 39Applying a theme 45Document storage and libraries 47Microsoft Azure SQL Database, Office 365, and Access 51App Catalog 53Summary 55Chapter 2 Finding your way around Access 2013 57A new way of building applications 57Create a custom web app 61Importing data from Access 62Using the navigation pane 64Working with tables, lookups, and relationships 65Displaying data in a browser 68Working with different views 71Controls available in a view 73Autocomplete control 74Related items control 75Subview control 76Action bar 77List control 77Hyperlink control 78Multiline Text Box control 79Web Browser control 79Overview of macro programming and data macros 80Upgrading and deploying a web app 82Side-loading a web app 96Designing and commissioning with existing data 96Summary 98Chapter 3 Converting a desktop database to a web app 99Tables and primary key fields 99Relationships and lookups 102Table and field properties 108Boolean data 112Value-based lookups 112Multi-value data 113Importing different data types 113Long Text (memo data) 115Calculated fields 115Image data type 115Attachments and OLE objects 115Reporting 116References 119Quick conversion to external writer 120Attachment and OLE data 121Uploading multiple files 122Extracting attachment files 123Uploading image files 125Summary 132Chapter 4 Creating a blank web app and using templates 133Creating a blank web app 133Adding template tables 134Creating a new table 136Editing the design of a table 137Creating lookups and relationships 139Adding indexing 142Adding validation rules 143Adding calculated fields 145Summary 146Chapter 5 Displaying data in views 149Customizing the table selector 150Customizing the view selector 151Creating a pop-up window interface 152Datasheet view 156Views and record sources 164Duplicating views 167List Details view 169Summary view 173Standalone view 177Related items control 180Subview control 182View controls 186Combo box control 187Combo box synchronization 188Autocomplete control 190Web browser control 191Adding color to controls 192Summary 193Chapter 6 Creating data sources by using queries 195Creating basic queries 196Adding criteria to queries 198Adding calculations to queries 200Adding parameters to queries 202Totals and queries 208Top value queries 209Unique values in queries 212Summary 214Chapter 7 Programming a web app by using macros 215Macro-programming capabilities 216Macro editor and standalone user-interface macros 219User-interface events for views and controls 222User-interface macros 227Named data macros and stored procedures 228Data macros and triggers 239Data macro tracing 247On Start macro 249Transactions and recursion 250Indirect recursion 250Direct recursion 251Presenting a view for printing 253Creating a cross-tabulation of data 262Side-loading a web app 267On Deploy Macro 274Using an alias with a macro action 287Summary 288Chapter 8 Managing security and a public-facing web app 289Creating a public website 289Creating a public-facing web app in Office 365 291Managing security in a public web app 292Summary 300Chapter 9 Looking under the hood at Microsoft Azure SQL ?Database 301SQL Server Management Studio 302ODBC drivers 303Connecting to Microsoft Azure SQL Database 303Schemas 308Security in SSMS 309Linked Microsoft SharePoint lists 309Manually creating an ODBC DSN connection 310Linking from the desktop to use an ODBC connection 317Creating DSN-less connections with program code 319Extracting information on relationships 321Displaying structural information using data access objects 323Displaying structural information using ADOX 327Displaying structural information with a query 330Validation rules 330Data macros under the hood 331Views and table-valued functions 336Summary 338Chapter 10 Other techniques for reporting 339Excel and data connections 339Excel PowerPivot 344Creating a report for SQL Server Reporting Services 351Publishing a report to SSRS 360Linking a web app to an SSRS report 363Using Visual Studio 2013 with a web app 364Summary 374Chapter 11 Using apps for Office with Access 375Apps for Access concepts 375Consuming apps for Access 377Developing apps for Access 381Summary 386Index 387
