Q41. Which field type is best for storing numeric values?
a) Number
b) Text
c) Date/Time
d) Memo
Show Answer
Correct Answer: a) Number
Explanation: The Number field type is specifically designed to store numeric values for calculations or measurements.
Q42. To view a table’s data in a grid format, which view would you use?
a) Data View
b) Design View
c) Print View
d) Layout View
Show Answer
Correct Answer: a) Data View
Explanation: Data View displays the table’s data in a grid format, allowing users to view and interact with the records.
Q43. What is the purpose of ‘Data Validation’ in a database?
a) To ensure that data entered meets specific criteria
b) To sort data in tables
c) To create forms and reports
d) To modify table structures
Show Answer
Correct Answer: a) To ensure that data entered meets specific criteria
Explanation: Data Validation helps to ensure that data entered into a table meets predefined criteria or rules.
Q44. How can you create a report from an existing query?
a) Use the Report Wizard
b) Use the Query Wizard
c) Use the Form Wizard
d) Use the Table Design View
Show Answer
Correct Answer: a) Use the Report Wizard
Explanation: The Report Wizard allows you to create reports based on the results of existing queries.
Q45. What does ‘Formatting a form’ typically involve?
a) Adjusting the layout and appearance of form controls
b) Designing the table schema
c) Creating complex queries
d) Generating reports
Show Answer
Correct Answer: a) Adjusting the layout and appearance of form controls
Explanation: Formatting a form involves adjusting its layout, style, and appearance to improve usability and presentation.
Q46. What is the primary function of a ‘field’ in a database table?
a) To store individual pieces of data
b) To define the table structure
c) To create new tables
d) To run queries
Show Answer
Correct Answer: a) To store individual pieces of data
Explanation: Each field in a table stores a specific piece of data corresponding to a particular attribute.
Q47. When creating a new table, what is the significance of defining field types?
a) It determines the kind of data that can be stored in each field
b) It affects how data is displayed in reports
c) It defines the layout of forms
d) It controls the sorting of data
Show Answer
Correct Answer: a) It determines the kind of data that can be stored in each field
Explanation: Defining field types specifies the kind of data that can be entered into each field, ensuring data consistency and integrity.
Q48. What is the benefit of using ‘Print Preview’ before printing a table?
a) It allows you to check the table’s formatting and layout
b) It creates a backup of the table
c) It saves the table in a different format
d) It updates the table’s data
Show Answer
Correct Answer: a) It allows you to check the table’s formatting and layout
Explanation: Print Preview helps you review and adjust the table’s formatting and layout to ensure it prints correctly.
Q49. What feature would you use to automate the creation of repetitive queries?
a) Query Wizard
b) Report Wizard
c) Form Wizard
d) Table Design View
Show Answer
Correct Answer: a) Query Wizard
Explanation: The Query Wizard simplifies the process of creating repetitive queries by guiding users through a series of steps.
Q50. How can you ensure consistency in data entry within a database?
a) Use input masks and validation rules
b) Regularly update records
c) Create multiple tables
d) Frequently print reports
Show Answer
Correct Answer: a) Use input masks and validation rules
Explanation: Input masks and validation rules help enforce consistent data entry formats and prevent incorrect data from being entered.