Q21. Which tool helps in generating reports from tables or queries?
a) Report Wizard
b) Query Wizard
c) Table Design View
d) Form Wizard
Show Answer
Correct Answer: a) Report Wizard
Explanation: The Report Wizard assists in generating and formatting reports based on tables or queries.
Q22. How can you change the height of rows and columns in a table?
a) Use the Table Design View
b) Drag the row and column borders
c) Use the Format option in the toolbar
d) Adjust settings in the Query Wizard
Show Answer
Correct Answer: b) Drag the row and column borders
Explanation: You can manually adjust the height of rows and columns by dragging their borders in the table view.
Q23. When using the Queries Wizard, what is one of the key tasks you can perform?
a) Design table schemas
b) Create and execute queries
c) Print database reports
d) Modify table structures
Show Answer
Correct Answer: b) Create and execute queries
Explanation: The Queries Wizard simplifies the process of creating and executing queries to retrieve or manipulate data.
Q24. What is the role of a ‘report’ in a database?
a) To generate summaries and formatted outputs of data
b) To create new tables
c) To enter data into forms
d) To define field types
Show Answer
Correct Answer: a) To generate summaries and formatted outputs of data
Explanation: Reports are used to present data summaries and formatted outputs for analysis and printing.
Q25. Which feature allows you to modify the layout and appearance of a report?
a) Report Wizard
b) Table Design View
c) Query Wizard
d) Form Wizard
Show Answer
Correct Answer: a) Report Wizard
Explanation: The Report Wizard provides tools to adjust the layout and appearance of reports, including formatting options.
Q26. To open an existing table, what should you typically do?
a) Double-click the table in the database window
b) Use the Export function
c) Use the Print command
d) Use the Query Wizard
Show Answer
Correct Answer: a) Double-click the table in the database window
Explanation: Double-clicking the table in the database window opens it for viewing or editing.
Q27. What type of field would be best for storing a phone number?
a) Text
b) Number
c) Date/Time
d) Currency
Show Answer
Correct Answer: a) Text
Explanation: A Text field is best for storing phone numbers, as they are not used for calculations or date-related functions.
Q28. What does ‘modifying a report’ typically involve?
a) Changing the report’s layout, formatting, and data fields
b) Creating new tables
c) Deleting old records
d) Running new queries
Show Answer
Correct Answer: a) Changing the report’s layout, formatting, and data fields
Explanation: Modifying a report involves adjusting its layout, formatting, and the data fields it includes.
Q29. What is the purpose of using the ‘Find and Replace’ feature in a database?
a) To locate specific text and replace it with new text
b) To format text fields
c) To delete records
d) To create new queries
Show Answer
Correct Answer: a) To locate specific text and replace it with new text
Explanation: The Find and Replace feature is used to search for specific text within a table and replace it with new text.
Q30. Which view would you use to see how a table looks before printing?
a) Print Preview
b) Design View
c) Data View
d) Layout View
Show Answer
Correct Answer: a) Print Preview
Explanation: Print Preview allows you to see how the table will look when printed, including formatting and layout.