Add a Datasheet view in an Access app

The Datasheet view in Access web apps works well when you want to see or work with data in rows and columns, similar to a spreadsheet format.

table data displayed in the datasheet view

Note: This article doesn't apply to Access desktop databases. For information concerning forms and navigation in desktop databases, see create an Access form.

When you create a new table in an Access web app, Access automatically creates a Datasheet view which you can customize. You can also add additional Datasheet views. Here’s how:

  1. Click the Add New View button (the plus sign) on the right side of the View Selector.

  2. In the Add New View box, type a name for the view, and in the View Type list, pick Datasheet.

    adding another datasheet view to a table

If you’d like to rename, copy, change or delete a datasheet view, click the Settings/Actions button to see a list of options available. To modify the datasheet layout, click Edit on this list.

edit datasheet properties for an app

You can customize the view by adding existing fields or even modify existing controls by:

Learn more about customizing a view by creating a user interface macro.

To view or use the datasheet on the web, click Launch App, and open the new Datasheet view in the browser.

Saves your app and launches it in the browser view.

See how you can use other views to filter and find relevant data in an Access web app.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!