Misy 5325 Midterm Comprehensive Questions And Solutions

MISY 5325 MIDTERM COMPREHENSIVE
QUESTIONS AND SOLUTIONS

◉ 2. To compact and repair a database, tap or click ————
button in the Info gallery in the Backstage view.
Answer: Compact & Repair


◉ 3. To create a crosstab, click the———— button on the CREATE
tab.
Answer: crosstab, Query Wizard


◉ 4. To create a lookup field, select ————- from the menu of
available data types.
Answer: Lookup Wizard


◉ 5. To create a multivalued field, create a ———— field being
sure to check the Allow Multiple Values check box.
Answer: lookup


◉ 6. To create a multivalued field, create a(n) ———field being
sure to check the Allow Multiple Values check box.
Answer: lookup

, ◉ 7. To create a new query in Design view, click CREATE on the
ribbon to display the CREATE tab and then click the ———-
button to create a new query.
Answer: Query Design


◉ 8. create a parameter query, enter a parameter rather than a
specific value as a criterion in the design grid. The parameter
must be enclosed in
Answer: parameter square brackets [ ]


◉ 9. To create a split form, select the table in the Navigation Pane,
click CREATE on the ribbon, click the ———— button on the
CREATE tab to display a menu, and then click Split Form on the
menu.
Answer: More Forms


◉ 10. To create a top-values query, use the Top Values box on the
DESIGN tab to change the number of records to be included from
All to the desired number.
Answer: False


◉ 11. To create a validation rule for the State field to restrict
entries to TN or TX, enter ————in the Validation Rule property
box.
Answer: T