Which of the following statement is wrong about Design view?
AWe can modify the design of an existing database object
BWe can modify the underlying data
CWe cannot modify the underlying database object
DNone of these
Answer:
B. We can modify the underlying data
Read Explanation:
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 a 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.