Access because that 365 access 2021 access 2019 access 2016 access 2013 accessibility 2010 accessibility 2007 More...Less

A datasheet type lets you present information from much more than one document at a time. The data is arranged in rows and also columns and multiple documents are displayed at a time. A datasheet is the visual depiction of the data had in a table, or that the results returned through a query. It screens the areas for each document from a table or query an outcome in a tabular (row and column) format, as displayed here.

You are watching: The access view that displays data in columns and rows like an excel worksheet is


Create a datasheet form

In the navigation Pane, click the table or query that contains the data that you desire to view on the form.

On the Create tab, in the Forms group, click More Forms, and also then click Datasheet.

Access create the type and display screens it in Datasheet view. Friend can instantly start transforming the data in the assorted fields and also records.

See more: What Is The Square Root Of 74 In Radical Form ? Square Root Of 74 Simplified

To learn an ext about all the ways you deserve to use and format datasheet forms, check out the short article Working through datasheets.


Need much more help?

Expand her skills
Explore Training
Get brand-new features first
Join Insiders

A subscription to do the many of her time
Try one month free

Was this information helpful?

Thank you! Any much more feedback? (The an ext you tell united state the an ext we have the right to help.) have the right to you help us improve? (The more you tell united state the more we deserve to help.)

What affected your experience?

Resolved mine issue
Clear instructions
Easy to follow
No jargon
Pictures helped
Didn't match my screen
Incorrect instructions
Too technical
Not sufficient information
Not enough pictures

Any additional feedback? (Optional)

Submit feedback

Thank girlfriend for your feedback!

What's new Store
English (United States) © 2021