MISY 5325 Final 1-70 | UPDATED Questions with 100%
Verified Answers
Q1: 1. To combine criteria with ———— place the criteria on the
same row.
A: AND
Q2: 2. To compact and repair a database, tap or click ————
button in the Info gallery in the Backstage view.
A: Compact & Repair
Q3: 3. To create a crosstab, click the———— button on the CREATE
tab.
A: crosstab, Query Wizard
Q4: 4. To create a lookup field, select ————- from the menu of
available data types.
A: Lookup Wizard
Q5: 5. To create a multivalued field, create a ———— field being
sure to check the Allow Multiple Values check box.
A: lookup
Q6: 6. To create a multivalued field, create a(n) ———field being
sure to check the Allow Multiple Values check box.
A: lookup
Q7: 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.
A: Query Design
Q8: 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
A: parameter square brackets [ ]
Q9: 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.
, A: More Forms
Q10: 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.
A: False
Q11: 11. To create a validation rule for the State field to restrict
entries to TN or TX, enter ————in the Validation Rule property
box.
A: T
Q12: 12. To create an update query, create a new query and then
click the ———- button on the DESIGN tab.
A: Update
Q13: 13. To define an additional field in Datasheet view, tap or click
the ———- column heading.
A: Click to Add
Q14: 14. To define an additional field in Datasheet view, tap or click
the ———— column heading, select the data type, and then
type the field name.
A: Click to Add
Q15: 15. To delete a database object, press and hold or right-click
the object in the Navigation Pane and then tap or click ———
on the shortcut menu.
A: Delete
Q16: 16. To delete a field from a table, open the table in ———- view,
click the row selector for the field to be deleted, and then
press the DELETE key.
A: Answer: Design
Q17: 17. To delete a field in a table, press and hold or right-click the
column heading for the field, and then tap or click ————-on
the shortcut menu.
A: Delete Field
Q18: 18. To delete a field, press and hold or right-click the column
heading for the field, and then tap or click Remove Field on
Verified Answers
Q1: 1. To combine criteria with ———— place the criteria on the
same row.
A: AND
Q2: 2. To compact and repair a database, tap or click ————
button in the Info gallery in the Backstage view.
A: Compact & Repair
Q3: 3. To create a crosstab, click the———— button on the CREATE
tab.
A: crosstab, Query Wizard
Q4: 4. To create a lookup field, select ————- from the menu of
available data types.
A: Lookup Wizard
Q5: 5. To create a multivalued field, create a ———— field being
sure to check the Allow Multiple Values check box.
A: lookup
Q6: 6. To create a multivalued field, create a(n) ———field being
sure to check the Allow Multiple Values check box.
A: lookup
Q7: 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.
A: Query Design
Q8: 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
A: parameter square brackets [ ]
Q9: 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.
, A: More Forms
Q10: 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.
A: False
Q11: 11. To create a validation rule for the State field to restrict
entries to TN or TX, enter ————in the Validation Rule property
box.
A: T
Q12: 12. To create an update query, create a new query and then
click the ———- button on the DESIGN tab.
A: Update
Q13: 13. To define an additional field in Datasheet view, tap or click
the ———- column heading.
A: Click to Add
Q14: 14. To define an additional field in Datasheet view, tap or click
the ———— column heading, select the data type, and then
type the field name.
A: Click to Add
Q15: 15. To delete a database object, press and hold or right-click
the object in the Navigation Pane and then tap or click ———
on the shortcut menu.
A: Delete
Q16: 16. To delete a field from a table, open the table in ———- view,
click the row selector for the field to be deleted, and then
press the DELETE key.
A: Answer: Design
Q17: 17. To delete a field in a table, press and hold or right-click the
column heading for the field, and then tap or click ————-on
the shortcut menu.
A: Delete Field
Q18: 18. To delete a field, press and hold or right-click the column
heading for the field, and then tap or click Remove Field on
