Video: Create an Access web app

Try it!

Important    Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

View and sort data online, using any device, in an Access web app—even if you don’t have Access. The fastest way to get started is to use a template.

Create an Access web app from a template

When you select a template, Access assembles an app that contains the tables you probably would have added yourself if you had started from scratch.

Note: To create an Access web app, you need Office 365 with SharePoint Online, on-premises SharePoint Server 2013, or SharePoint Server 2016 with Access Services and SQL Server 2012 (or higher).

Tip: If you need to close a database, select File > Close.

  1. Open Access, and select a web app template. (Web app templates have a picture of a globe in the background.)Access web app template buttonTip: If you don’t see the template you want, under the Search for online templates box, select Databases. Then, to find database templates on, enter one or more keywords in the search box.
  2. Enter a name for your new app.
  3. From the list, select its location. (Or enter a SharePoint URL or an Office 365 URL.)
  4. Then, select Create.New Access web app creation screen

Create an Access web app from scratch

Creating an Access web app from scratch is very similar to creating one from templates. The biggest difference is that you create the tables in your web app.

  1. Open Access, and select Custom web app.Access custom web app icon
  2. Enter a name for your new web app, and select its location. Then, select Create.
  3. Add structured or blank tables to the web app, or create tables from existing data sources. Search for a table template based on the type of information you want to track, create a table from the existing source data, or add a blank table to customize yourself.Add tables to an Access web app

Want more?

Excel training

Outlook training


When several people need to use a database at the same time, build an Access web app, which is a web database that runs on most browsers. To create an Access web app, you need a SharePoint 2016 or SharePoint 2013 server, or you need Office 365. To USE an Access web app, you just need to be connected to the Internet or your corporate network.

The easiest way to build an Access web app is to use a template. You can select one when you first start Access or when you select File > New.

The set of Access templates include DESKTOP DATABASE templates and WEB APP templates. You can tell the difference because a web app template is marked with the globe icon.

Select the template you want, … enter a name, … and then select a server from the list HERE, or enter a server name HERE.

Access downloads and opens the template. To start working, select Launch App.

This starts the database in your browser, and now you can start entering your data.

But remember, unlike in an Access desktop database, in an Access web app you must remember to select Save to save your data.

The other thing to remember about Access web apps is you use them in your browser, but you create and change them in Access.

To do this, select Customise in Access, … select Open, … and the file opens in Access. Notice that the ribbon is smaller than what you see in an Access desktop database. These are the tools you need to work on web apps.

Let’s open this view for editing—this is called Design View—and make a quick change.

Press the Control key, … select the labels, … change their colour, … and align them to the right. Select Save to publish your changes to your server.

Now select Home, and then select Launch App.

There you go. We’ve created a database in just minutes and we don’t need to change anything unless we want to. And because it’s an Access web app, your team members can now open and use this database in their web browsers.

This information was compiled using information courtesy of © Microsoft 2020. All rights reserved.

Leave a Reply

%d bloggers like this: