2.02 understanding Access table data type and properties

Edit Answers
123456789101112131415161718
Across
  1. 1. Nick wants to immediately open an employees' email from his database . What data type should be used for the email address?
  2. 4. Which type of field enables a user to select from a list of values when updating the contents of a field?
  3. 8. Nick wants to design a database and wants Access to automatically assign an ID number to each record. What data type should he use?
  4. 10. Keisha created a database of her music. She wants to locate only the songs by Beyoncé. What tool should she use in order to view this information without saving?
  5. 11. Curt needs to format the numbers in his database to two decimal places. Which data type would he use?
  6. 15. What is the purpose of a primary key in a database?
  7. 16. jenny is entering data to the medication field in the patient database and needs to constantly view patient ID number to input medication information. What should she do?
  8. 18. Nick needs to specify two characters for the student ID field. What area of design view would he access to specify this?
Down
  1. 2. Amanda wants to ensure there are only two characters for state abbreviation. What should she do?
  2. 3. Eddie works for ABC Finance. He needs to view which employee(s) has the lowest sales for the month. Which command should he use?
  3. 5. Which type of relationship has one record being related to many others in another data base.
  4. 6. Jenny is formatting the database to show past due bill amounts . Which data type would she use?
  5. 7. Jenny is setting the addresses for each patient. Which data type should she use?
  6. 9. Erin needs to prepare a custom table for her recipe collection. She has to include the ingredient portions. Which is the correct tool to use?
  7. 12. Eddie works for ABC Finance. He needs to view which employee(s) has the highest sales for the month. Which command should he use?
  8. 13. In a table, which is a way of exclusively identifying each record in the database?
  9. 14. When a database is created, what is defined when names and data types are assigned to all data fields in a table?
  10. 17. What is the process of transferring data from an Access database for use in another application called?