Q51. Which of the following actions can be performed using the ‘Form Wizard’?
a) Create forms for data entry and editing
b) Design and modify tables
c) Generate and format reports
d) Execute complex queries
Show Answer
Correct Answer: a) Create forms for data entry and editing
Explanation: The Form Wizard is used to create forms that simplify data entry and editing tasks.
Q52. To enter a new record into a table, which interface element is commonly used?
a) Data Entry Form
b) Report Layout
c) Table Design
d) Query Results
Show Answer
Correct Answer: a) Data Entry Form
Explanation: Data Entry Forms are designed to facilitate the input of new records into a database table.
Q53. What is the typical result of using the ‘Sort’ function on a table?
a) Arranging records in a specific order
b) Filtering records based on criteria
c) Deleting duplicate records
d) Merging tables
Show Answer
Correct Answer: a) Arranging records in a specific order
Explanation: The Sort function organizes records in ascending or descending order based on selected field values.
Q54. How does the ‘Find and Replace’ function benefit data management?
a) It helps locate and update specific text within the database
b) It creates new records
c) It generates data backups
d) It formats fields for printing
Show Answer
Correct Answer: a) It helps locate and update specific text within the database
Explanation: The Find and Replace function is used to search for and update specific text within database fields.
Q55. Which view allows you to see how data will appear on a printed report?
a) Print Preview
b) Design View
c) Data View
d) Layout View
Show Answer
Correct Answer: a) Print Preview
Explanation: Print Preview displays how the data will appear on the printed report, including formatting and layout adjustments.
Q56. What is the purpose of using a ‘Form’ in a database?
a) To enter and modify data
b) To design new tables
c) To generate summary reports
d) To execute queries
Show Answer
Correct Answer: a) To enter and modify data
Explanation: Forms are used for entering and modifying data in a database in a user-friendly manner.
Q57. What type of field would you use to store a person’s name?
a) Text
b) Number
c) Date/Time
d) Boolean
Show Answer
Correct Answer: a) Text
Explanation: The Text field type is appropriate for storing names, as it can handle letters and symbols.
Q58. When defining a new table, which element specifies how data should be entered and stored?
a) Field Type
b) Table Name
c) Report Layout
d) Query Criteria
Show Answer
Correct Answer: a) Field Type
Explanation: Field Type defines the kind of data that can be entered into each field, ensuring appropriate data storage.
Q59. How can you access the structure of a table to make modifications?
a) Open the table in Design View
b) Use the Query Wizard
c) Access Print Preview
d) Use the Data Entry Form
Show Answer
Correct Answer: a) Open the table in Design View
Explanation: Design View allows you to modify the structure of a table, including fields and their properties.
Q60. Which feature would you use to create a summary of data from a table?
a) Report Wizard
b) Data Entry Form
c) Table Design View
d) Query Wizard
Show Answer
Correct Answer: a) Report Wizard
Explanation: The Report Wizard helps in creating summaries and formatted outputs of data from a table.