Creating NoCode Solutions using Access Web Apps in

Creating No-Code Solutions using Access Web Apps (in Share. Point with SQL Azure ) Share. Point Saturday, Columbus, August 2015 Andy Tabisz, Work. Smart Database Masters Grand Rapids, MI andy@Work. Smart. DB. com m: 616. 258. 1408

Steering Committee Volunteers Share. Point Saturday Columbus 2015 Twitter: @Buckeye. SPUG #SPSCBUS Speakers http: //www. clker. com/cliparts/p/f/5/k/n/b/superhero-outline-bw-

Steering Committee Volunteers Speakers Main Hall, near registration Lunch 12: 45 pm – 1: 30 pm Vendor Presentations 1: 00 pm – 1: 30 pm Snacks 2: 30 pm – 3: 10 pm Raffles 4: 30 pm – 5: 00 pm Turn in your Sponsor BINGO card Must be present to win http: //www. clker. com/cliparts/p/f/5/k/n/b/superhero-outline-bw-

Steering Committee Volunteers Speakers http: //www. clker. com/cliparts/p/f/5/k/n/b/superhero-outline-bw-

Steering Committee Volunteers Share. Pint Elevator Brewery and Draught 161 N. High St, Columbus, OH 43215 www. Elevator. Brewing. com 6: 00 pm…. . Speakers

Andy Tabisz? Programming in Access since 1994 (v 2. 0) Microsoft MVP (for Access) Lead Developer of Membrosia Membership Software 1997 -2005 Owner, Work. Smart Database Masters 2008 8 consultants: Grand Rapids, Detroit, Arizona, California, Florida Access Desktop, Web App Development, ASP. NET and Alpha Anywhere (mobile apps) Excel/VBA, Share. Point, Software Integration, Training Co-owner, Waterfall. Calc. com (mortgage banking software) Active in the user group community and frequent presenter President, Access-Web-Apps Users Group (Access. User. Groups. org) President, Michigan Access Users Group (MAUG) Speaker at over a dozen SQL & SP Saturdays and Access UG Meetings …Super Hero

Cody is not amused.

Agenda What Are Access 2013 Web Apps? Create an App in 90 Seconds… or Less The List View Datasheet View Touring the UI What does “No-Code Solutions” really mean? Reports / Hybrid Solutions Extending your app to Mobile devices A real, live, working app… Waterfall. Calc. com

What are Web Apps Desktop Access Apps Access 2013 Web Apps Used by millions today Default data stored in a local file Brings Access databases into the Requires Access software to view web-connected era and edit data Data stored in SQL Azure using Office 365 Rich functionality with VBA Accessible everywhere through Fully supported in 2013 any browser Easy sharing and No VBA Coding

Demo – App in 90 seconds…

Polished, Professional User Interface 2. Choose view 4. Add and edit items 1. Choose table 3. Search and filter

Polished, Professional User Interface Autocomplete Control Datasheet Summary View Action Bar

Creating your first web app Can create an empty app from Site Contents Access Build tables from Scratch Table templates Import existing data Upload existing apps from an app file (or corporate catalog or MS store) One paid Office 365 account can share app with 500 guests

Demo – Customizing an app

Start customization from browser Customize your app in Access to make design modifications

Creating design elements Home Create Advanced Query Becomes SQL Views Blank View List View Datasheet View Macro Data Macro Becomes powerful SQL Triggers On Start Macro

No-Code Solutions Macro Demonstration Understanding No the UI VBA Drag/Drop Search Groups Commands

What Else Should You Know? Where are the Reports? Hybrid Solutions Adding Office Web Apps / Apps for Office Add-Ins Extending Access to Mobile Android App: Access Days Cruise

Demo – A real, live, working App! Waterfall. Calc. com

Questions? Andy Tabisz, Work. Smart Database Masters andy@Work. Smart. DB. com m: 616. 258. 1408 Twitter: @Access. Wisdom