MISY 5325 FINAL EXAM COMPLETE
70 QUESTIONS AND VERIFIED
ANSWERS
\.1. To combine criteria with ———— place the criteria on the same row. -
ANSWERS✔-AND
\.2. To compact and repair a database, tap or click ———— button in the Info
gallery in the Backstage view. - ANSWERS✔-Compact & Repair
\.3. To create a crosstab, click the———— button on the CREATE tab. -
ANSWERS✔-crosstab, Query Wizard
\.4. To create a lookup field, select ————- from the menu of available data
types. - ANSWERS✔-Lookup Wizard
\.5. To create a multivalued field, create a ———— field being sure to check the
Allow Multiple Values check box. - ANSWERS✔-lookup
\.6. To create a multivalued field, create a(n) ———field being sure to check the
Allow Multiple Values check box. - ANSWERS✔-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. -
ANSWERS✔-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 - ANSWERS✔-
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. - ANSWERS✔-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. -
ANSWERS✔-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. - ANSWERS✔-T
\.12. To create an update query, create a new query and then click the ———-
button on the DESIGN tab. - ANSWERS✔-Update
\.13. To define an additional field in Datasheet view, tap or click the ———-
column heading. - ANSWERS✔-Click to Add
70 QUESTIONS AND VERIFIED
ANSWERS
\.1. To combine criteria with ———— place the criteria on the same row. -
ANSWERS✔-AND
\.2. To compact and repair a database, tap or click ———— button in the Info
gallery in the Backstage view. - ANSWERS✔-Compact & Repair
\.3. To create a crosstab, click the———— button on the CREATE tab. -
ANSWERS✔-crosstab, Query Wizard
\.4. To create a lookup field, select ————- from the menu of available data
types. - ANSWERS✔-Lookup Wizard
\.5. To create a multivalued field, create a ———— field being sure to check the
Allow Multiple Values check box. - ANSWERS✔-lookup
\.6. To create a multivalued field, create a(n) ———field being sure to check the
Allow Multiple Values check box. - ANSWERS✔-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. -
ANSWERS✔-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 - ANSWERS✔-
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. - ANSWERS✔-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. -
ANSWERS✔-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. - ANSWERS✔-T
\.12. To create an update query, create a new query and then click the ———-
button on the DESIGN tab. - ANSWERS✔-Update
\.13. To define an additional field in Datasheet view, tap or click the ———-
column heading. - ANSWERS✔-Click to Add
