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...
A database view is a dynamic table compared to the 'fixed' ones. A view contains a select statement, which dynamically updates the table everytime the view is looked at and the data has changed....