Modify an Access app

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 for the job you’re trying to do. You’ll probably want to make some changes. 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.

    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

    1. Click Open when prompted by the browser.

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

    2. On the left side of the screen, click the table whose view you want to change, and then click the view that needs changing.

    3. 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:

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

  • Add controls from the ribbon: click a control in the Controls gallery and then click in the view to place it.

    The Controls gallery on the ribbon.

  • Add controls from the Field List: double-click or drag a field into the view.

  • Change the properties of a control by selecting it and clicking the Data or Formatting buttons that appear next to the control.

    A view in Edit mode, showing the Formatting settings for a text box.

  • Add a macro to a control by selecting it and clicking the Actions button that appears.

  • Add buttons to the Action Bar at the top of the view.

    Adding a new custom action to the Action Bar.

Once you’re done making changes, click Save and then Home > Launch App.

App-level changes

  • Rename, 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.

  • Import data into an app by clicking Home > Table, then clicking the type of data to import under Create a table from an existing data source.

Creating a table from an existing data source.

Applies To: Access 2013

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language