Transcript Configuring and Managing Access Services in SharePoint 2013

Low up-front investment
Easy to evolve and iterate
Easy adoption
Multiple versions of the truth
Hard to collaborate
Difficult to analyze
Keeping data clean is a chore
Access
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 2013 Web Apps
SQL
Database
SharePoint
Web Applications
2. Choose view
1. Choose table
3. Search and filter
4. Add and edit items
View and Edit Data
Database Design
Advanced Reporting & Integration
•
•
•
•
•
Desktop Access Reports
Excel
Power View
Crystal Reports
Custom Websites (.NET, PHP, etc.)
O365
Browser
Browser
Browser
runtime
Web app 1
Web app 2
design
Access
IDE
Web app 3
…
SQL Azure
SharePoint
on-premises
Browser
Browser
Browser
runtime
Web app 1
Web app 2
design
Access
IDE
Web app 3
…
SQL Server
SharePoint 2013
Web server
Web server
Application
Server
Office
Web Apps
Server
SQL Server 2012
Access databases
SQL Server
2008 R2 SP1
or 2012
SharePoint databases
SharePoint
Access
IDE
SQL server hosting
Access apps
SharePoint
SQL
Role-based
SQL Auth
SharePoint
SQL
• Microsoft SQL Server 2012 Transact-SQL ScriptDom (sqldom.msi)
• Microsoft System CLR Types for Microsoft SQL Server 2012 (SQLSysClrTypes.msi)
• Microsoft SQL Server 2012 Data-Tier Application Framework (DACFramework.msi)
• Microsoft SQL Server 2012 Local DB (SQLLocalDB.msi)
• Microsoft SQL Server 2012 Native Client (sqlncli.msi)
Web server
Web server
Application
Server
Office
Web Apps
Server
SharePoint databases
Access databases
http://www.microsoft.com/en-us/download/details.aspx?id=30445
Self-service
for IWs
Manageability
for you
Office 365 Preview Plan
Access
2013
Client
Access
2013
Database
Hosting
Home Premium
Yes
No
ProPlus
Yes
No
Small Business Premium
Yes
Yes
Home Premium
Yes
Yes
SPC026
Apps for SharePoint in 60s with Access 2013
Tuesday 10:30am
South Seas Ballroom E
SPC043
Configuring and Managing Access Services in SharePoint 2013
Wednesday
10:30am
Mandalay Bay
Ballroom G
SPC193
Access Databases: Taming the Beast
Wednesday
1:45pm
Lagoon CDIJ
SPC071
Building Apps for SharePoint with Access 2013: A deeper dive
Wednesday
1:45pm
South Seas Ballroom E
SPC099
Moving Legacy Data/Systems to SharePoint/SQL Azure with Access
2013 (Lotus Notes/MDB/Excel etc…)
Thursday 10:30am
Banyan ABCD
HOL045
Creating a SharePoint App with Access Services: Hands on Lab
All times
??
SPC010
An overview of developing SharePoint-hosted apps
Tuesday 1:45pm
South Seas CDFJI
SPC133
Introduction to the Cloud App Model for Office and SharePoint –
Part 1
Monday 2:00pm
South Seas
SPC 134
Introduction to the Cloud App Model for Office and SharePoint –
Part 2
Monday 3:45pm
South Seas
SPC029
Building auto-hosted apps for SharePoint
Tuesday 1:45pm
Banyan ABCD
SPC240
Understanding and Maintaining SharePoint Apps for IT
Professionals
Tuesday 5:00pm
Mandalay Bay Ballrom
H
SPC260
What's New in Spreadsheet Management for Office and
SharePoint
Wednesday
10:30am
Islander IED
SPC106
Getting Your Apps into the Office and SharePoint Store
Thursday 12:00pm
South Seas E
http://blogs.office.com/b/microsoft-access/
http:// www.microsoft.com/office/preview
http://msdn.microsoft.com/access
http://msdn.microsoft.com/SharePoint
MySPC
http://myspc.sharepointconference.com