5. Choose the correct option.
a. Which one is not a data type available in Microsoft Access 2007?
i. Text
ii. Memo iii. Number
iv. Numeric
b. Which one of these is used to enter data in an Access table?
i. Datasheet view ii. Design view it. Form
iv. Both i and in
c. Which one of these identifies records uniquely?
i. Primary key ii. Attribute iii. Tuple
iv. Entity
d. What do we use to move from one column to another in Datasheet view and Design view?
i. TAB key
ii. Right arrow key iii. Mouse click iv. All of these
e. Where are new records added to a table in Datasheet view?
i. At the end of the table
ii. At the beginning of the table
iii. Anywhere in the table
iv. In ascending order of primary key
f. Which command undoes sorting in an Access table?
i. Remove All Sorts ii. Clear All Sorts iii. Delete All Sorts iv. Eliminate All Sorts
g. How will you show the Totals row of an Access table?
i. Double-click the column header
ii. On the Home tab, click Totals in the Records group.
Answers
Answer:
Choose the correct option.
a. Which one is not a data type available in Microsoft Access 2007?
i. Text
ii. Memo iii. Number
iv. Numeric
b. Which one of these is used to enter data in an Access table?
i. Datasheet view ii. Design view it. Form
iv. Both i and in
c. Which one of these identifies records uniquely?
i. Primary key ii. Attribute iii. Tuple
iv. Entity
d. What do we use to move from one column to another in Datasheet view and Design view?
i. TAB key
ii. Right arrow key iii. Mouse click iv. All of these
e. Where are new records added to a table in Datasheet view?
i. At the end of the table
ii. At the beginning of the table
iii. Anywhere in the table
iv. In ascending order of primary key
f. Which command undoes sorting in an Access table?
i. Remove All Sorts ii. Clear All Sorts iii. Delete All Sorts iv. Eliminate All Sorts
g. How will you show the Totals row of an Access table?
i. Double-click the column header
ii. On the Home tab, click Totals in the
Answer:
this are your exam questions right