Exam (elaborations)
MISY 5325 Final Exam Questions With Verified Answers
- Course
- Institution
MISY 5325 Final Exam Questions With Verified Answers...
[Show more]
Content preview
MISY 532 5 Final Exam Q uestions W ith Verified A nswers 1. To combine criteria with ———— place the criteria on the same row. - ANSWER AND 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 di splay 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 12. To create an update query, create a new query and then click the ———- button on the DESIGN tab. - ANSWER Update 13. To define an additional field in Datasheet view, tap or click the ———- column heading. - ANSWER Click to Add 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. - ANSWER Click to Add 15. To delete a database object, press and hold or right-click the object in th e Navigation Pane and then tap or click ———- on the shortcut menu. - ANSWER Delete 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. - ANSWER Answer: Design 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. - ANSWER Delete Field 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 the shortcut menu. T/F - ANSWER Fals e 19. To delete a record, tap or click the record selector for the record, and then press the key(s). - ANSWER DELETE 20. To display the Total row in a datasheet, click the Sum button on the rib bon. Torf - ANSWER False 21. To enter a number in a criterion, type the number without any dollar s igns orThe benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Newsolution. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
74735 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now