Q91. Which field type should you use for storing detailed text or notes?
a) Memo
b) Number
c) Currency
d) Date/Time
Show Answer
Correct Answer: a) Memo
Explanation: The Memo field type is designed for storing large amounts of text or detailed notes.
Q92. What is the primary purpose of ‘Data Validation Rules’ in a table?
a) To enforce data accuracy and consistency
b) To format data for printing
c) To create relationships between tables
d) To sort data in ascending or descending order
Show Answer
Correct Answer: a) To enforce data accuracy and consistency
Explanation: Data Validation Rules are used to ensure that the data entered into a table meets specific criteria, maintaining accuracy and consistency.
Q93. How can you quickly navigate to a specific record in a table?
a) Use the navigation buttons or search feature
b) Change the field type
c) Adjust the column width
d) Export the table
Show Answer
Correct Answer: a) Use the navigation buttons or search feature
Explanation: Navigation buttons and the search feature help quickly locate a specific record in a table.
Q94. What is the role of a ‘Foreign Key’ in a database?
a) To establish relationships between tables
b) To define the primary key
c) To sort data
d) To format reports
Show Answer
Correct Answer: a) To establish relationships between tables
Explanation: A Foreign Key links records in one table to records in another, establishing relationships between tables.
Q95. What is the purpose of the ‘Design View’?
a) To define and modify the structure of tables and forms
b) To enter data into records
c) To generate reports
d) To sort and filter data
Show Answer
Correct Answer: a) To define and modify the structure of tables and forms
Explanation: Design View is used to create and modify the structure of tables and forms, including fields, data types, and properties.
Q96. What type of field is most suitable for storing a price?
a) Currency
b) Text
c) Memo
d) Date/Time
Show Answer
Correct Answer: a) Currency
Explanation: The Currency field type is ideal for storing monetary values, providing accurate calculations and formatting.
Q97. Which view should you use to see and adjust the layout of a form or report?
a) Layout View
b) Design View
c) Data View
d) Print View
Show Answer
Correct Answer: a) Layout View
Explanation: Layout View allows you to adjust and format the layout of forms and reports.
Q98. What does the ‘Save As’ feature do in a database application?
a) Creates a copy of the database object under a new name
b) Prints the current table or report
c) Deletes the current database object
d) Opens a new database
Show Answer
Correct Answer: a) Creates a copy of the database object under a new name
Explanation: The ‘Save As’ feature allows you to create a copy of a database object, such as a table or report, with a new name.
Q99. What is a ‘Table Relationship’ used for in a database?
a) To define how tables interact with each other
b) To format table data
c) To sort records
d) To generate reports
Show Answer
Correct Answer: a) To define how tables interact with each other
Explanation: Table Relationships define how data in one table relates to data in another, ensuring data integrity and enabling complex queries.
Q100. How can you quickly find specific text in a table?
a) Use the Find function
b) Use the Sort function
c) Change the field type
d) Modify the table layout
Show Answer
Correct Answer: a) Use the Find function
Explanation: The Find function allows you to search for specific text within a table efficiently.