Q11. What does the ‘Form Wizard’ allow you to do?
a) Create and design forms
b) Generate queries
c) Define table relationships
d) Export data
Show Answer
Correct Answer: a) Create and design forms
Explanation: The Form Wizard assists in creating and designing forms for data entry and management.
Q12. What is the primary function of a ‘form’ in a database?
a) To display data in a printable format
b) To allow users to enter and edit data
c) To create complex queries
d) To generate reports
Show Answer
Correct Answer: b) To allow users to enter and edit data
Explanation: Forms are used for entering, editing, and viewing data in a user-friendly manner.
Q13. Which field type would be most appropriate for storing dates?
a) Text
b) Number
c) Date/Time
d) Currency
Show Answer
Correct Answer: c) Date/Time
Explanation: The Date/Time field type is specifically designed to store date and time values.
Q14. What action should you take to view a table’s design after creating it?
a) Open the table in Design View
b) Use the Query Wizard
c) Print the table
d) Export the table
Show Answer
Correct Answer: a) Open the table in Design View
Explanation: Design View allows you to see and modify the structure of a table, including field names and types.
Q15. Which of the following is NOT a common field type in databases?
a) Text
b) Boolean
c) Blob
d) Address
Show Answer
Correct Answer: d) Address
Explanation: Address is not a standard field type; it would typically be stored in a Text field or a series of Text fields.
Q16. When you enter data into a table, what must you ensure about the data types?
a) They match the data format specified for each field
b) They are all in uppercase
c) They are all numbers
d) They are all in lowercase
Show Answer
Correct Answer: a) They match the data format specified for each field
Explanation: Data must conform to the specified field types to ensure accurate data storage and retrieval.
Q17. To close a table after viewing or editing it, what should you typically do?
a) Click the Close button on the table window
b) Save the table and then exit
c) Delete the table
d) Export the table
Show Answer
Correct Answer: a) Click the Close button on the table window
Explanation: Clicking the Close button on the table window will close the table and return you to the database interface.
Q18. What is the purpose of ‘previewing’ a table?
a) To check the layout and contents before printing
b) To design the table structure
c) To create a new table
d) To sort the data
Show Answer
Correct Answer: a) To check the layout and contents before printing
Explanation: Previewing allows you to view the table as it will appear when printed, helping to check for formatting issues.
Q19. In a database, what is the purpose of the ‘sorting’ function?
a) To arrange data in a specific order
b) To search for specific records
c) To create new tables
d) To delete records
Show Answer
Correct Answer: a) To arrange data in a specific order
Explanation: Sorting organizes data based on specified criteria, such as alphabetically or numerically.
Q20. What does ‘data entry’ refer to in the context of databases?
a) The process of adding new records to a table
b) The process of deleting old records
c) The process of designing tables
d) The process of creating queries
Show Answer
Correct Answer: a) The process of adding new records to a table
Explanation: Data entry involves inputting new information into the database tables.