The new Access creates and shares custom data-centric applications online that help run your business or department; no app development knowledge needed! Access apps reliably solve collaborative data-tracking needs like contact management, customer billing, and order tracking. Experience the new intuitive design that makes navigating apps familiar and easy. Access makes sure end-users can find features and commands so you can focus on light customization to fit business needs. Data is stored in Window Azure SQL Database or SQL Server, so your data is more robustly secured and scalable than ever.
Create custom apps fast without being a developer
Welcome screen lift-off. Start creating a custom app from the Welcome screen, or get inspired by one of the new and professionally-designed app templates.
Table templates. Simply type what you need to track and Access uses table templates to deliver an app that does the job. Access handles the complexities of fields, relationships, and rules so you can concentrate on your project. You’ll have a new app with a natural UI up and running in no time.
Create and run legacy databases. Enjoy support for your existing desktop databases (ACCDB/MDB).
Experience apps that are easy to use even as they grow with your business
Gorgeous simplicity. Never again get "lost in the data." A standardized app framework makes navigating apps familiar and easy. And the apps you rely on every day remain easy to use and professional-looking even as data volume and complexity grow.
Related items control. Take a peek at additional relevant information in the database without changing screens. You always have the right context when reviewing or entering information.
Autocomplete control. Entering data accurately is a breeze with drop-down menus and recommendations that appear when you begin typing.
Drill-thru. With one click you can view a pop-up of a record and dig into the details.
Share your data and control access to it more easily
New Office App model. As an IT manager for your company, you'll love the new Office App model. Access apps are accessible on SharePoint or an on-premises server via a browser, and users don’t need Access installed to use apps you've created.
Data stored in SQL Server. Access apps are stored in Microsoft SQL Azure/Server so your data is now protected by disaster recovery and back-up and restore features. SQL Azure/Server also provides your business or department with long-term scalability of mission-critical business data.
Office 365 deployment. You can now use SharePoint user access control and centralized app management features with Access apps.
What's new in Access 2013 What’s new in Access 2013? In a word, apps. An Access web app is a new type of database that you build in Access, then use and share with others as a SharePoint app in a web browser. To build an app, you just select the type of data you want to track (contacts, tasks, projects, and so on). Access creates the database structure, complete with views that let you add and edit data. Navigation and basic commands are built-in, so you can start using your app right away.
Getting started with apps
Building an app Using your SharePoint server or Office 365 site as a host, you’ll be able to build a polished, browser-based database app. Under the hood, Access apps use SQL Server to provide the best performance and data integrity. On the startup screen, click Custom web app. NOTE: With Access 2013, you can still create traditional desktop databases from scratch. Or, try out a template to create an app, a desktop database, or an Access 2010-style web database.
Table templates Quickly add tables to your app using pre-designed table templates. If you see the multiple-table indicator next to a template, that means Access will add commonly used related tables for you so you can get started with a truly relational database.
External data Import data from Access desktop databases, Microsoft Excel files, ODBC data sources, text files, and SharePoint lists.
Opening in a browser
When you’re done designing, don’t look for a compatibility checker or a Publish button. Your app is already live—just click Launch App.
The Action Bar The built-in views each have an Action Bar with buttons for adding, editing, saving, and deleting items. You can add more buttons to this bar to run any custom macros you build, or you can remove buttons you don’t want people to use.
New deployment options