Modify an Access app

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.

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.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×