Couch - Extend Microsoft Access applications to the Cloud
Here you can read online Couch - Extend Microsoft Access applications to the Cloud full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2015, publisher: Pearson Education;Microsoft Press, genre: Home and family. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
- Book:Extend Microsoft Access applications to the Cloud
- Author:
- Publisher:Pearson Education;Microsoft Press
- Genre:
- Year:2015
- Rating:4 / 5
- Favourites:Add to favourites
- Your mark:
Extend Microsoft Access applications to the Cloud: summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "Extend Microsoft Access applications to the Cloud" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
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. Youll 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
Couch: author's other books
Who wrote Extend Microsoft Access applications to the Cloud? Find out the surname, the name of the author of the book and a list of all author's works by series.
Extend Microsoft Access applications to the Cloud — read online for free the complete book (whole text) full work
Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Extend Microsoft Access applications to the Cloud" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.
Font size:
Interval:
Bookmark:
Andrew Couch
PUBLISHED BY
Microsoft Press
A division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399
Copyright 2015 by Andrew Couch. All rights reserved.
No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.
Library of Congress Control Number: 2014946864
ISBN: 978-0-7356-6768-6
Printed and bound in the United States of America.
First Printing
Microsoft Press books are available through booksellers and distributors worldwide. If you need support related to this book, email Microsoft Press Book Support at .
This book is provided as-is and expresses the authors views and opinions. The views, opinions and information expressed in this book, including URL and other Internet website references, may change without notice.
Some examples depicted herein are provided for illustration only and are fictitious. No real association or connection is intended or should be inferred.
Microsoft and the trademarks listed at http://www.microsoft.com on the Trademarks webpage are trademarks of the Microsoft group of companies. All other marks are property of their respective owners.
Acquisitions and Developmental Editor: Devon Musgrave
Project Editor: Rosemary Caperton
Editorial Production: Waypoint Press (www.waypointpress.com)
Technical Reviewer: Jeff Conrad
Copyeditor: Roger LeBlanc
Indexer: Cristina Yeager
Cover: Twist Creative Seattle and Joel Panchot
For Charlotte and Michael. Thanks for all the fun and the way you have enriched our lives.
ANDREW COUCH
What do you think of this book? We want to hear from you!
Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources for you. To participate in a brief online survey, please visit:
microsoft.com/learning/booksurvey
If you are already experienced in working with Microsoft Access desktop databases, now is the time to suspend all your existing knowledge and prepare for something completely new. Even though you will find a familiar development interface, it looks a bit different. And even though the user interface is similar to past versions of Access, you will need to become familiar with a lot of new concepts.
If you have never used Access, you should realize that the product can be used to construct both desktop database solutions (which is not covered in this book) and the new web app database solutions. You can use these new web app solutions to quickly and productively deliver solutions in a browser window.
The new Access web apps fit into a strategic initiative to move the world of Microsoft Office into the cloud. Although each Office product offers its own isolated web experience, they all seem to be moving in a similar direction, and they have been consolidated onto the single common platform, Microsoft Office 365. You also can host these technologies with your own on-premise Microsoft SharePoint 2013 Server with Access Servicesin which case, you should read the references to Office 365 within this book as meaning your own SharePoint 2013 Server instance. This book is written from the perspective of Office 365, so you might find that some of the terminology varies from what you see when using your own on-premise solution.
Historically, there was a time when communicating between Access, Excel, and Word on the desktop was quite difficult. Then, in Office 95 and later when a number of issues were resolved in Office 97, we had seamless integration between the Office products. The process of integration required the adoption of a common programming language called Visual Basic for Applications (VBA). In the new web browserbased interface, VBA is not supported. We hope that Microsoft will improve integration though web services or other technologies, and the addition of new Apps for Office features is a step toward offering better integration between the Office products and other technologies.
Microsoft has tried twice in the past to leverage Access into a web browser; both times the technologies did not have great longevity. The first attempt, called Data Access Pages, delivered individual web pages and never got a great deal of support from the Access community. The second attempt, called Access 2010 Web Databases, took the cloud ideas further and had a lot of great features, but it suffered from too much reliance on storing data within SharePoints internal structures and a publication model that was lengthy and prone to problems; both these issues have been addressed in the new web app technology.
Access 2013 demonstrates how the Access product is being transformed to deliver exceptional productivity in creating a web browserbased experience.
Office 365 gives Microsoft a platform on which to offer a more frequent mechanism for delivering updates and enhancements to the Office products. These updates, which are scheduled on a monthly basis, are automatically applied. In general, updates to the desktop products will continue to be available on a basis similar to the existing service packs.
However, because Access web apps have such tight integration with the cloud, the Access development team can deploy more significant updates on a shorter, more regular basis as service updates. Some of these updates are visible through the desktop experience of designing a web app.
As an example of the benefits of this approach, in July 2013 new updates were made to Access Services within Office 365 that provide a great new synchronization feature between combo box controls and include more diligent checking for inconsistent objects when creating packages.
In the first quarter of 2014, Microsoft released the first service pack for Office 2013 on Office 365. This service pack includes three significant enhancements to web-app development. This book reflects these changes:
The first change was to provide a mechanism for developers to deploy changes to web apps without needing to apply those changes directly into the live system. Changes now can be made in a test environment and then subsequently deployed to a production environment.
The second change is also related to deploying changesit introduces the idea of locking an application to protect a developers intellectual property rights and limit permission to modify the web app. This feature is aimed at software houses that plan to make applications available in the Office Store and need to provide an upgrade path while locking down the source code for the application.
The third change is of great significance. For some time, Office products such as Excel have benefited from the ability to augment an application with an App for Officefor example, enabling map data to be seamlessly displayed in a spreadsheet. This feature now has been extended to support Access. This opens up opportunities to download a component from the Office Store, as well as to create your own components that, for example, can read and write data through to external company data sources. A long time ago, Access developers benefited from the introduction of OLE Automation, which allowed for interoperability between the Office products. You can view this new integration feature as offering a similar capability in the new development environment.
Font size:
Interval:
Bookmark:
Similar books «Extend Microsoft Access applications to the Cloud»
Look at similar books to Extend Microsoft Access applications to the Cloud. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.
Discussion, reviews of the book Extend Microsoft Access applications to the Cloud and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.