Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Important    Access Services 2010 and Access Services 2013 are being removed from the next release of SharePoint. We recommend you do not create new web apps, and migrate your existing apps to an alternative platform, such as Microsoft Power Apps.

You can share Access data with Dataverse, which is a cloud database upon which you can build Power Platform apps, Automate workflows, Virtual Agents, and more for the web, phone, or tablet. For more information, see Get started: Migrate Access data to Dataverse.

Access has a web app called “Asset tracking” that helps you track your inventory of business assets. You can download and create the app (it's free) in about a minute and then customize it to fit your needs. This web app requires Access 2013 or higher in order to make design changes.

Important:  Before you can create an asset tracking web app, you need an on-premises SharePoint site where you can host the app.

  1. Start Access, and click the Asset tracking icon.
    Asset tracking template on the Access start page
    On the Asset tracking setup screen, you'll see a preview of what the app will look like.
    Preview of the Asset tracking app

  2. In the App Name box, type a name for your new web app.

  3. In the Web Location box, enter the URL for the SharePoint site where you'll create your web app, then click Create.

    Tip:  If you copy and paste the URL from your site open in your web browser, omit “_layouts” and everything after it. For example, enter: https://contoso.sharepoint.com/sites/sales/
    If you have trouble, see Find a web location for your Access web app.

    After Access creates the app at the web location you specified, the web app should appear in a minute or less.

Your new web app opens in Design view in Access. The web app is shown as a page with a tab containing its name. Since we started with the asset tracking app template, you’ll see three pre-built tables listed just below this tab: Assets, Categories, and Employees. You can start using the app right away, or you can customize it by adding and modifying tables, and adding new or modifying existing views for each of its tables.

Add Tables page in the new app's Design view

One way to add a new table to your web app is by looking for a table template in the What would you like to track? search box. Once you choose a table template, Access builds one or more tables based on the template with fields that have names, data types, and relationships with other fields and tables that make sense for what the table will contain.

Let's say you want to keep track of equipment your company owns, such as tools. Type "equipment" in the search box, and a table template named Items shows up a few positions down in the list. Click Items, and a new table named Items appears in the left pane with the original three tables – Assets, Categories, and Employees. And there's a new table, Contacts, that was created when you added the Items table that's connected to the Items table.

Click Items in the left pane, and you'll see three views (think of forms), each of which is a different way to look at and enter data for the table. Moving left to right, you'll see the List view, the Datasheet view, and the By Category view. When you create a new table, it always has at least a List and a Datasheet view. The Assets table has a custom "By Category" view because that view was built into the Items table template that the table was based on.

Now that you've had a good look at the app's design in Access, you're ready to start using it.

  1. On the Home tab, click Launch App.

Launch App

This starts the app in your default web browser.

  1. On the app page, start entering information. Press the Tab key to move between the boxes like you would on a typical data entry form.

  2. When you're finished entering the information for your first record, click the Save button on the action bar.

    The action bar has five buttons for working with records (Add, Delete, Edit, Save, and Cancel).

    Save button on the action bar

  3. After you've saved the record, the Add, Delete, and Edit buttons on the action bar will be available so you can add a new record, or edit or delete the current record.

To learn more about creating, customizing, and working with Access web apps, see the following articles and videos:

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×