Question

Difference between design view and datasheet view

Answer 1

 Datasheet view in the database is used for the data depiction in such a way that it can allows the user to edit the data but  user would not be able to change the database format except for a little bit of change.

While in case of Design view user can create as well as change the table and other database things. It also allows to field configuration.In this view data of the database can not be changed.

Answer 2

Datasheet View is a representation of the data in a database. Using this view, it is possible to edit the data in the database. However, only minor changes can be made to the actual database format. One such change that can be made to the format is adjusting the column width of a table.

Design View helps with modifying the database format. Changes can be made to forms, tables, or other database objects. Fields can also be configured to set appropriate keys and restrictions on type of data entered in them. However, the actual data in the database cannot be manipulated using this view.

Both views have a View button associated with them to swap from one view to the other.