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 or
Los beneficios de comprar resúmenes en Stuvia estan en línea:
Garantiza la calidad de los comentarios
Compradores de Stuvia evaluaron más de 700.000 resúmenes. Así estas seguro que compras los mejores documentos!
Compra fácil y rápido
Puedes pagar rápidamente y en una vez con iDeal, tarjeta de crédito o con tu crédito de Stuvia. Sin tener que hacerte miembro.
Enfócate en lo más importante
Tus compañeros escriben los resúmenes. Por eso tienes la seguridad que tienes un resumen actual y confiable.
Así llegas a la conclusión rapidamente!
Preguntas frecuentes
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.
100% de satisfacción garantizada: ¿Cómo funciona?
Nuestra garantía de satisfacción le asegura que siempre encontrará un documento de estudio a tu medida. Tu rellenas un formulario y nuestro equipo de atención al cliente se encarga del resto.
Who am I buying this summary 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 this summary for $9.99. You're not tied to anything after your purchase.