Question

Which one is not true about datasheet view?

• A. Datasheet view is available only for certain database objects , such as tables ,queries ,and forms.
• B. Datasheet view displays the underlying data for a database object in a tabular format.
• C. Datasheet view is used to add data to a database.
• D. Datasheet view is not modify the data in a database , or to delete data from a database.

Answer 1

Answer:

D. Datasheet view is not modify the data in a database , or to delete data from a database.

Database object views

• Access helps us to view data in different formats. Following are the common database object views:

Design view 

• In Design view , we can only modify the design of an existing database object.
• We cannot modify the underlying data.

Datasheet view

• Datasheet view is available only for certain database objects , such as tables ,queries ,and forms.
• Datasheet view displays the underlying data for a database object in a tabular format.
• Datasheet view is used to add data to a database, to modify the data in a database , or to delete data from a database.

SQL view

• In SQL view , we can view queries in the basic form of SQL syntax
• SQL view is used to modify queries
• SQL view is not useful to modify the underlying data

Form view

• Form view helps to display the designed form.
• Form view is useful to display and accept data.
• Form view helps to modify the underlying data in table
• We cannot change the design of a form in Form view.

Print view

• When you view a database object in Print Preview, You can preview the printed report by using the actual data.
• Print Preview is useful when you use Access reports.

Page view

• You can use page view to view the contents of data access page.
• Data access pages have the same functionality in page view that they have in Internet Explorer 5.0 and later
• The record navigation control displays the record source , the current record number , and the total number of records.