Applies ToAccess for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013

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.

When you create an Access app from a template, or just by importing tables, the app’s ready to use right away. But that doesn’t mean it’s perfect for the job you’re trying to do. You’ll probably want to make some changes to your app such as adding more controls or moving controls to different positions.

Note: This article doesn't apply to Access desktop databases. For more information about creating forms in desktop databases, see create an Access form.

While you’re using the app in the browser, make some notes about the changes you’d like to see on which views, then:

  1. Click Settings > Customize in Access in the upper right corner of your browser window.

    Note:  If you don’t see Customize in Access, you either don’t have permission to customize the app, or the app has been locked.

    Customize in Access command on the Settings gear menu

  2. Click Open when prompted by the browser.

    If you have Access installed, it’ll open and display the design environment.

  3. On the left side of the screen, click the table caption name in the Table Selector whose view you want to change, and then click the view that needs changing.

  4. Click the Edit button in the middle of the view.

    The Edit button on a view in an Access app.

Now you can start changing the design of the view. Some of the things you can do here:

Once you’re done making changes, click Save and then Home > Launch App to see your design changes in your browser.

App-level changes

  • Rename a view's caption, duplicate, or delete a view by clicking its name in the View Selector, then clicking the Settings/Actions button that appears:

The View Settings/Actions button

  • Add a new view by clicking the Add button (+) to the right of the View Selector.

The Add New View button in an Access app.

Creating a table from an existing data source.

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.