Q81. Which feature would you use to make a table’s data easier to analyze visually?
a) Conditional Formatting
b) Query Wizard
c) Report Layout
d) Data Entry Form
Show Answer
Correct Answer: a) Conditional Formatting
Explanation: Conditional Formatting allows you to apply formatting rules to table data, making it easier to analyze visually by highlighting important information.
Q82. How can you ensure that a table’s field only accepts dates?
a) Set the field type to Date/Time
b) Apply a validation rule
c) Use a specific Input Mask
d) Design a custom form
Show Answer
Correct Answer: a) Set the field type to Date/Time
Explanation: Setting the field type to Date/Time ensures that only date values can be entered into the field.
Q83. What action is typically used to remove a table from view without deleting it?
a) Close the table
b) Use the Hide option
c) Use the Delete command
d) Export the table
Show Answer
Correct Answer: a) Close the table
Explanation: Closing the table removes it from view but does not delete the table or its data.
Q84. What is the primary function of the ‘Layout View’?
a) To adjust the layout and design of a form or report
b) To enter and edit data
c) To create new queries
d) To design table structures
Show Answer
Correct Answer: a) To adjust the layout and design of a form or report
Explanation: Layout View is used to adjust and fine-tune the layout and design of forms and reports for better presentation.
Q85. What is a common use of the ‘Query Wizard’?
a) To help in creating queries without writing SQL code
b) To format data for printing
c) To enter data into forms
d) To design table relationships
Show Answer
Correct Answer: a) To help in creating queries without writing SQL code
Explanation: The Query Wizard guides users through the process of creating queries, making it easier without needing to write SQL code manually.
Q86. What does the ‘Data View’ allow you to do?
a) View and interact with data in a table
b) Design new forms
c) Generate and format reports
d) Create and modify queries
Show Answer
Correct Answer: a) View and interact with data in a table
Explanation: Data View displays the data in a table, allowing users to view and interact with the records.
Q87. Which action is required to change the name of an existing field in a table?
a) Open the table in Design View and edit the field name
b) Use the Find and Replace function
c) Export the table and rename the field
d) Use the Query Wizard
Show Answer
Correct Answer: a) Open the table in Design View and edit the field name
Explanation: To change the name of an existing field, you need to open the table in Design View and modify the field name.
Q88. What type of query would you use to calculate the sum of a numeric field?
a) Aggregate Query
b) Parameter Query
c) Update Query
d) Select Query
Show Answer
Correct Answer: a) Aggregate Query
Explanation: An Aggregate Query is used to perform calculations such as sum, average, or count on numeric fields.
Q89. What feature in a database ensures that no two records have the same value in a field designated as a Primary Key?
0a) Uniqueness constraint
b) Data Validation rule
c) Input Mask
d) Field Format
Show Answer
Correct Answer: a) Uniqueness constraint
Explanation: A uniqueness constraint on a Primary Key field ensures that every value in that field is unique across all records.
Q90. What does the ‘Print’ option do in a database application?
a) Produces a hard copy of the table, form, or report
b) Exports data to a file
c) Creates a backup of the database
d) Opens the database for editing
Show Answer
Correct Answer: a) Produces a hard copy of the table, form, or report
Explanation: The Print option generates a hard copy of the current table, form, or report.