Microsoft Access What are Access Web Apps for

Microsoft Access • What are Access Web Apps for Office • What are “Apps for Office” • Access “Apps for Office” • Value of “Apps for Office” Technical Details • How it all works • Creating an “App for Office” with Visual Studio 2013 • APIs, Publishing, Resources

S Apps for Share. Point • • Apps for Office • • Fully functioning apps that run on the web within Share. Point Hosted on Share. Point sites in the cloud Access web apps are Share. Point Apps “Add-ins” of functionality for some Office programs (Word, Excel, Outlook, …) Placed within the document or in the task pane Can use web connectivity

Supported app types Application Supported types Excel 2013 • Task pane • Content Excel Web App • Content Word 2013 • Task pane Outlook 2013 • Mail Outlook Web App • Mail Project Professional 2013 • Task pane

http: //aka. ms/officedevtoolsforvs 2013

http: //schemas. microsoft. com/office/appforoffice/1. 1 http: //www. w 3. org/2001/XMLSchema-instance http: //go. microsoft. com/fwlink/? Link. ID=257495 https: //accessbingmap. firstpartyapps. edog. oaspapps. com/accessbingmap/Bing. Maps. html

var sample. Data. Table = new Office. Table. Data(); sample. Data. Table. headers = [["From Address", "To Address", "Distance Field"]]; sample. Data. Table. rows = [ ["White House", "Seattle", "2716. 2"], ["Houston", "Dallas", "293. 3"], ["400 Broad St. , Seattle, WA", "1 Microsoft Way, Redmond WA", "13. 3"]]; Office. context. document. bindings. add. From. Prompt. Async(Office. Binding. Type. Table, { id: Binding. Name, sample. Data: sample. Data. Table }, Binding. Handler); function Binding. Handler(binding. Callback) { if (binding. Callback. status == Office. Async. Result. Status. Succeeded) { //Binding has been created successfully } }

Office. select("bindings#" + Binding. Name). get. Data. Async({ coercion. Type: Office. Coercion. Type. Table, rows: "this. Row" }, Get. Data. Handler); function Get. Data. Handler(callback) { if (callback. status == Office. Async. Result. Status. Succeeded) { var From. Address = callback. value. rows[0][0]; var } }

function Set. Distance(Miles. Traveled) { Office. select("bindings#" + Binding. Name). set. Data. Async([[Miles. Traveled]], { rows: "this. Row", columns: [Post. Field] }, Set. Data. Handler); } function Set. Data. Handler(callback) { //Set Data Callback }

Explore Play Follow Get Answers Give Feedback

Patterns and practices 30+ Visual Studio projects Common scenarios Contribute

OFC-B 254 Integrating Yammer and Microsoft Share. Point Using. NET DEV-B 230 Most Commonly Asked for On-Premises Customizations Reimagined as Applications for Share. Point DEV-B 319 Get Started Developing Applications for Microsoft Office and Share. Point Server 2013 DEV-B 231 Office Power Hour: New Developer APIs and Features for Applications for Office DEV-B 227 Anyone Can Build a Share. Point Application with Microsoft Access OFC-B 274 Implementing Microsoft Share. Point 2013 Hybrid for Search, Business Connectivity Services, Microsoft One. Drive for Business and Yammer

DEV-B 232 Creating Cloud Hosted Line-of-Business Applications with Apps for Office, Microsoft Office 365, Microsoft Azure, and Windows Phone 8 OFC-B 311 A Practical Use of External Data Sources DEV-B 357 Developing Office 365 Cloud Business Applications DEV-B 387 Deep Dive into Mail Compose Applications APIs DEV-B 386 Setting Up Your On-Premises Environment for App Development DEV-B 228 Build Connected Productivity Apps for Share. Point and Office DEV-B 390 Share. Point Power Hour: New Developer APIs and Features for Apps for Share. Point DEV-B 389 Who Are You and What Do You Want? Working with OAuth in Microsoft Share. Point 2013

DEV-B 227 Anyone Can Build a Share. Point Application with Microsoft Access DEV-B 231 Office Power Hour: New Developer APIs and Features for Applications for Office OFC-H 203 Creating a Share. Point Application with Microsoft Access Services

EXM 04 Exam Prep: 70 -331 and 70 -332

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

Contact: Gary Devendorf Access PM Gary. Devendorf@Microsoft. com