1. What is a combo box in MS Access?
A) An object or control that contains a drop-down list of values
B) A type of text box used for entering data
C) A form used for data entry
D) A table used for storing data
2. What is the purpose of a combo box control?
A) To provide a more compact way to present a list of choices
B) To hide the list until the user clicks the drop-down arrow
C) To allow the user to enter a value not in the list
D) All of the above
3. How can you create a combo box in MS Access?
A) Select the Combo Box Control from the Controls menu
B) Draw the combo box and use the Combo Box Wizard dialog box
C) Enter the values for the drop-down list and click Finish
D) All of the above
4. What is an advantage of using a combo box?
A) It saves space on your form by presenting choices in a compact manner.
B) It allows users to easily select options without typing.
C) It provides flexibility by allowing users to enter values not in the list.
D) All of the above.
5. How can you align a combo box with other fields on your form?
A) Select all fields and go to the Arrange tab, then click Stacked.
B) Use the Size/Space button and select To Shortest from the drop-down list.
C) Adjust the height and width of controls using Layout View.
D) Both A and B.
6. What is a calculated expression in MS Access?
A) An expression that combines multiple fields to produce a result.
B) A formula used for performing calculations on stored data.
C) An expression that retrieves data from separate fields.
D) An equation used to define grouping levels in a report.
7. What can you use a calculated expression for in MS Access?
A) Retrieving the value of a control or supplying criteria to a query.
B) Creating calculated controls and fields.
C) Defining grouping levels for reports.
D) All of the above.
8. Where can you create calculated expressions in MS Access?
A) In forms and reports
B) In queries
C) In tables
D) All of the above
9. How can you create a calculated expression in MS Access?
A) Use the Expression Builder tool in query design view.
B) Enter the expression directly into a calculated control or field.
C) Use functions, operators, and identifiers to construct the expression.
D) All of the above.
10. What is a bound form in MS Access?
A) A form connected to an underlying data source like a table or query.
B) A form used for data entry or editing in a database.
C) A form that displays multiple records at once from the data source.
D) All of the above.
11. What is an unbound form in MS Access?
A) A form not connected to any underlying record or data source.
B) A form used for navigation or interaction with the database itself.
C) A form that displays a single record at a time from the data source.
D) Both A and B.
12. What are the different types of bound forms in MS Access?
A) Single Item Form
B) Multiple Item Form
C) Split Form
D) All of the above
13. What is a Single Item Form in MS Access?
A) A form that displays one record at a time from the bound data source.
B) A form used for bulk editing or viewing multiple records at once.
C) A form divided into halves, with one half displaying single items and other half displaying lists
or datasheets.
D) None of the above.
14. How can you create a form in MS Access?
A) Use the Form Wizard and select fields from one or more tables or queries.
B) Open the Create tab and choose from the options in the Forms group.
C) Select an object in the navigation pane and click on More Forms dropdown menu.
D) All of the above.
15. What is a Split Form in MS Access?
A) A form divided into halves, either vertically or horizontally.
B) One half displays a single item or record, and the other half displays a list or datasheet view of
multiple records.
C) A form used for data entry, editing, or displaying data stored in an Access desktop database.
D) Both A and B.