Q61. What is a ‘Primary Key’ in a database table?
a) A unique identifier for each record
b) A type of field used for dates
c) A format for displaying text
d) A function for sorting data
Show Answer
Correct Answer: a) A unique identifier for each record
Explanation: A Primary Key is a unique identifier for each record in a table, ensuring that no two records have the same key.
Q62. What action should you take if you need to search for a specific record in a table?
a) Use the Find function
b) Use the Sort function
c) Use the Design View
d) Use the Print Preview
Show Answer
Correct Answer: a) Use the Find function
Explanation: The Find function allows you to search for specific records within a table based on search criteria.
Q63. Which of the following is NOT typically a benefit of using forms in a database?
a) Simplifies data entry
b) Automates report generation
c) Provides a user-friendly interface
d) Ensures data validation
Show Answer
Correct Answer: b) Automates report generation
Explanation: Forms are used for data entry and validation, not for automating report generation, which is typically handled by the Report Wizard.
Q64. How can you ensure that data in a table remains consistent and accurate?
a) Implement validation rules and constraints
b) Regularly update records
c) Use the Find and Replace function
d) Frequently print the table
Show Answer
Correct Answer: a) Implement validation rules and constraints
Explanation: Validation rules and constraints ensure that the data entered into the table adheres to specified standards and rules.
Q65. Which view would you use to change the appearance of a report’s layout?
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 the appearance and layout of a report before printing.
Q66. What is the function of a ‘Report Wizard’?
a) To guide users in creating and formatting reports
b) To define field types
c) To enter data
d) To run queries
Show Answer
Correct Answer: a) To guide users in creating and formatting reports
Explanation: The Report Wizard provides a step-by-step guide to creating and formatting reports based on database data.
Q67. To make the design of a form more user-friendly, what should you consider?
a) Adding clear labels and instructions
b) Creating complex queries
c) Designing new tables
d) Printing the form
Show Answer
Correct Answer: a) Adding clear labels and instructions
Explanation: Adding clear labels and instructions improves the usability of a form, making data entry easier for users.
Q68. What is an ‘Input Mask’ in the context of a database field?
a) A format that restricts the type of data entered into a field
b) A tool for designing forms
c) A method for creating queries
d) A feature for printing reports
Show Answer
Correct Answer: a) A format that restricts the type of data entered into a field
Explanation: An Input Mask defines a specific format for data entry, ensuring that data is entered consistently.
Q69. When you need to adjust the size of columns in a table, what should you do?
a) Drag the column borders
b) Use the Sort function
c) Open the table in Design View
d) Use the Find function
Show Answer
Correct Answer: a) Drag the column borders
Explanation: Adjusting the size of columns is typically done by dragging the column borders in the table view.
Q70. What feature would you use to generate a report that summarizes data from a query?
a) Report Wizard
b) Query Wizard
c) Form Wizard
d) Table Design View
Show Answer
Correct Answer: a) Report Wizard
Explanation: The Report Wizard helps you generate a report summarizing data from a query.