Track inventory with the asset tracking web app (2024)

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.
   
   On the Asset tracking setup screen, you'll see a preview of what the app will look like.
   

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.

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.

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).

   

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:

• Video: Create an Access app

• Create an Access app

• Create an Access app from a template

• Modify an Access app

• Basic tasks for an Access app