Unknown/uncontrolled data applications Bad/broken end-user applications Inefficient business processes Backlog of IT requests No data access control/backup Difficult application sharing Lack of upgrade path Access 2013 Platform Overview Desktop Access Apps Used by millions today Data stored in a local file Access 2013 Web Apps Brings Access databases into a new web-connected era Requires Access software to view Data stored in SQL for Office and edit data 365 or on-premise server Rich functionality with VBA Accessible everywhere through Fully supported in 2013 any browser Easy sharing and no code S Apps for SharePoint Fully functioning apps that run on the web within SharePoint Hosted on SharePoint sites in the cloud Access apps are SharePoint Apps “Add-ins” of functionality for some Office programs Placed within the document or in the task pane Access apps can contain Apps for Office Related session DEV-B226 – Rich extensions to SharePoint Apps for Office Apps using Microsoft Access Access Services 2013 The easiest way for a nondeveloper to build and publish apps for SharePoint “Napa” Office 365 Development Tools Visual Studio 2013 A lightweight, in-browser development experience A great end-to-end development experience for highest customization Low up-front investment Easy to evolve and iterate Easy adoption Hard to collaborate Difficult to analyze Multiple versions of the truth Keeping data clean is a chore One version of the truth Easy to collaborate Powerful analysis Keeps data clean High up-front investment Hard to evolve and iterate Hard to adopt Access Services Tables & Data 2012+ Azure Access 2013 Web Apps 1. SQL Database 2. 3. SharePoint Web App Model View and Edit Data Database Design Advanced Reporting & Integration Access Services SQL Azure • • • • • Desktop Access Reports Excel Power View Crystal Reports Custom Websites (.NET, PHP, etc.) 2. Choose view 4. Add and edit items 1. Choose table 3. Search and filter Autocomplete Control Datasheet Drill-Through Popups Summary View Related Items Control Action Bar Open your app in Access to make design modifications Home  Create  Advanced Query Blank View List View Datasheet View Macro Data Macro On Start Macro On Deploy Macro Expand Navigation Pane to view app objects 3 ways to get started with data Start from scratch with a Blank Table Get a head start with Table Templates Use an existing data source Link to Blog article Authorize in Access Connect anywhere Analyze and Report Allow other programs to connect to the SQL Server database that powers your Access app. You’ll find all the necessary credentials in one place. Enter the SQL Server connection information from Access into your analysis program, and you’ll find all your database’s queries and tables available. SQL Server is an industry standard, so you have a choice of tools, from Excel to Crystal Reports. Take advantage of the powerful charting and analysis tools that Excel already provides, or analyze your data in a program of your choice. Link to session recording on this new feature With Access web apps, the end-user gets the experience they want and IT gets the control that they want. Having a friend buy your coffee? Yea, it’s kind of like that. 3 Steps to New Gear! With Application Insights MSDN Subscribers get up to $150/mo in Azure credits. Stop by the Developer Platform and Tools booth and visit the MSDN Subscriptions station to activate your benefits and receive a gift! 1. http://aka.ms/msdn_teched http://visualstudio.com 2. http://aka.ms/aivsix 3. Microsoft Engineering Stories http://www.visualstudio.com Visual Studio Industry Partner Program Visual Studio | Integrate