Thursday, January 13, 2022

Basic tasks for an Access app [MS]

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.

Access apps are built to be used in a browser for easier sharing and collaboration. To create and use an Access app you'll need Access 2013 or higher and an Microsoft 365 for business site or a SharePoint Server 2013 or higher site. Here's more on creating an Access app. Let's take a quick look at ways you create an app, add data to it, and some possible next steps in customizing and using your app.

If you're more interested in working with an Access desktop database, see Basic tasks for Access desktop databases.

Create an app from a template

It's faster to start with one of the app templates that come with Access.

  1. On the Access startup screen, scroll down to see the featured templates. The most popular apps, such as Asset tracking, Contacts, and Issue tracking, are listed first. The ones with a globe icon will create Access apps:

    templates view

    Templates with the word "desktop" in the title will create traditional Access desktop databases.

  2. Click a template and enter a name in the App Name box.

  3. Select a web location for the app and click Create.

Learn more about starting your database from an Access app template. For more details about finding the web location to use in the App Name box, see find a web location for your Access web app. If you'd rather design an app on your own, continue to the next section.

Create a custom Access app

If none of the templates fit your needs, you can create an app from scratch.

  1. Open Access and click Custom web app.

    Templates view on startup screen in Access

  2. Enter a name and the Web location for your app (or pick a location from the Locations list) and click Create.

For more details, see creating a custom web app.

Regardless of whether you started with a template or a blank app you can always customize an Access app.

Top of Page

Import or link to data

After you've created your app, you'll want to add data. You can import data from other sources. Here are some instructions to get you started:

  1. Open your app in Access (or from the browser, click Settings > Customize in Access), then click Home > Table.

  2. On the Add Tables page, pick your source from Create a table from an existing data source, and follow the steps in the Get External Data wizard.

    Existing data source options on the Add Tables page.

For more information about importing data, see Import data from an Access database into an Access web app.

To create relationships for the new table, you would add lookup fields.

Next steps

The rest of the app design process varies depending on what you want to do next with your app, but here are some articles that can help you learn more:

Top of Page

No comments:

Post a Comment

Search This Blog

Change font size in Outlook on the web [MS]

Change font size in Outlook on the web Office 365 Small Business Outlook on...