Best Answer

A data sheet view shows the data in the database. It allows you to enter and edit the data, but you cannot change the format of the database.

Design view allows you to create or change the table, form or any other database object.

User Avatar

Wiki User

โˆ™ 2010-12-12 12:55:50
This answer is:
User Avatar
User Avatar


Lvl 1
โˆ™ 2020-06-10 06:41:41
User Avatar


Lvl 1
โˆ™ 2020-09-21 08:30:16
Study guides

A survey question that asks you to write a brief explanation is called

Auto correlation and cross correlation

If a married man cheats does that mean there are problems in his marriage

The nature-nurture question asks whether

See all cards
585 Reviews
More answers
User Avatar


Lvl 1
โˆ™ 2020-06-10 06:40:51


This answer is:
User Avatar
User Avatar


Lvl 1
โˆ™ 2020-06-10 06:41:14

Add your answer:

Earn +20 pts
Q: What is the difference between design view from datasheet view?
Write your answer...
Still have questions?
magnify glass
Related questions

What is the difference between design view and data sheet view?

Design view shows the field and their types and other properties, but not the data. You can make changes to the design of the table there. Datasheet view shows you the actual data and you can change the data in it, but not the design of the table.

Can you make changes to a table in either Datasheet or Design view?

Yes! But it is more convenient to make your changes in Design view because if you make your changes in Datasheet view it does not make any changes in other objects. It is just in the table.

What is a replica of a table or query's Datasheet view that maintains some form properties although the form is limited in design and control options?

Datasheet Form

Can you enter data in design view in ms access?

No. Design view is for creating the table and manipulating the fields and the structure of the fields and the table. It is not for entering data. To do that you can go to datasheet view or use a form.

You may view an Access table or a query in Design view or in this other view which displays records with rows and columns of information similar to an Excel spreadsheet.?

Datasheet view.

What is the form of database?

datasheet view

View where a table is represented as rows and columns?

Datasheet view

When entering deleting or editing table data?

in design view The above is wrong: The table must be in Datasheet view. page 588 of Office 2010 Exploring series Gaurer.

The field properties area is displayed in datasheet view true or false?

The Field Properties area is displayed in Datasheet view. true or false

When you create a blank database the table that Access creates for you contains one field named .?

If you create it in Design View, no field name is given. If you create it in Datasheet View it is called Field1.

Does a query displays records in a Datasheet View?


What view shows the table data in a row and column format?

Datasheet view.

People also asked

What is the difference between design view and data sheet view?

View results

How is an action query is different from select query?

View results

What is the difference between shaping and operant conditioning?

View results