Transcript Improvements to Access 2013 - Buckeye SharePoint Users Group

Creating No-Code Solutions
using Access Web Apps
(in SharePoint with SQL Azure )
SharePoint Saturday, Columbus, August 2015
Andy Tabisz, WorkSmart Database Masters
Grand Rapids, MI
[email protected]
m: 616.258.1408
SharePoint Saturday
Columbus 2015
Twitter: @BuckeyeSPUG
#SPSCBUS
http://www.clker.com/cliparts/p/f/5/k/n/b/superhero-outline-bw

Main Hall, near registration

Lunch 12:45pm – 1:30pm

Vendor Presentations 1:00pm – 1:30pm

Snacks 2:30pm – 3:10pm

Raffles 4:30pm – 5:00pm

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
http://www.clker.com/cliparts/p/f/5/k/n/b/superhero-outline-bw
SharePint
Elevator Brewery and Draught
161 N. High St, Columbus, OH 43215
www.ElevatorBrewing.com
6:00pm…..
Andy Tabisz?

Programming in Access since 1994 (v 2.0)

Microsoft MVP (for Access)

Lead Developer of Membrosia Membership Software 1997-2005

Owner, WorkSmart 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, SharePoint, Software Integration, Training

Co-owner, WaterfallCalc.com (mortgage banking software)

Active in the user group community and frequent presenter


President, Access-Web-Apps Users Group (AccessUserGroups.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… WaterfallCalc.com
What are Web Apps
Desktop Access Apps
Used by millions today
Default data stored in a local file
Requires Access software to view
and edit data
Rich functionality with VBA
Fully supported in 2013
Access 2013 Web Apps
Brings Access databases into the
web-connected era
Data stored in SQL Azure using
Office 365
Accessible everywhere through
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 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
Becomes powerful SQL Triggers
Data Macro
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!
WaterfallCalc.com
Questions?
Andy Tabisz, WorkSmart Database Masters
[email protected]
m: 616.258.1408
Twitter: @AccessWisdom