Question

Difference between datasheet view and design view in three points

Answer 1

DATASHEET VIEW

The view which is enter ,delete or modify the data ina table is called DATASHEET VIEW.In this view clicking the view button switches you to design view.This shows the actual data and we can also change the data in it,but not the design of the table

DESIGN VIEW

1. The view which is utilized to design the structure of a table is known as DESIGN VIEW.In this view clicking the view button switches you to datasheet view.It shows the field and thee datatypes along with their priorities ,but not the data and we can also make changes to the design of the table

Answer 2

Design View allow you to change or create the form tables and misc database objects, its also allowed to configure the fields.

On other hand datasheet view shows data, allow modifications in data but cannot allow modification in format