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:

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.

Click Open when prompted by the browser.

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

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.

Click the Edit button in the middle of the view.

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

Move, resize, or delete controls. (Note that deleting a control on a view doesn’t delete the underlying data—just it’s display on this view).