A primary key is

A primary key is
  1. A primary key is
  2. What Microsoft Access feature would give a United Parcel Service (UPS) manager the ability to ask questions like “How many UPS tubes were shipped Monday?” and “What was the total revenue generated from UPS Express box large in November 2017?”

  3. Which one of the following tools is the quickest way to create a tabular report in MS Access based on the selected table or query?

  4. Most of the printed documents generated by managers using Access will come from

  5. A Report section that is used to summarize grouped field data is

  6. A table is also recognized as a(n)

  7. SQL is a fourth-generation language that is

  8. Which of the following should be considered when designing a database?

  9. The following data type would appear as a checkbox in a table.

  10. Which of the following does NOT describe a caption property?

  11. Which of the following does NOT describe the following description of a one-to-one relationship?

  12. To edit a form, use

  13. The following are form creation tools except

  14. Queries are objects in a database based on one or more underlying

  15. The benefit of a relationship is to

  16. A deletion anomaly is

  17. Which of the following statements best describes data mining?

  18. A navigation form is a

  19. An encrypted file is

  20. A digital signature

  21. After creating an ACCDE file, you

  22. The term cascading refers to

  23. Describe three-tier architecture. Explain the functions performed by each tier.

  24. Explain the purpose of a conceptual database model, and describe the most common method of creating one.

  25. Explain the terms entity and attribute. Describe an example of an entity and then list two attributes. Using your examples, explain the data types that would be used to capture the attributes.

  26. If you were given an ERD that contained a M:N relationship between orders and products, what would you need to do in order to create the tables and relationship in Access?