5 / 5 pts
(CO 1) A primary key is
a field or set of fields that uniquely identifies a record.
a key that uniquely identifies columns in a table.
... [Show More]
Question 2
5 / 5 pts
(CO 1) 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?”
Question 3
0 / 5 pts
(CO 1) 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?
Question 4
5 / 5 pts
(CO 1) Most of the printed documents generated by managers using Access will come from
Question 5
3 / 5 pts
(CO 1) A Report section that is used to summarize grouped field data is
Question 6
5 / 5 pts
(CO 2) A table is also recognized as a(n)
Question 7
1 / 5 pts
(CO 2) SQL is a fourth-generation language that is
Question 8
5 / 5 pts
(CO 3) Which of the following should be considered when designing a database?
Question 9
5 / 5 pts
(CO 3) The following data type would appear as a checkbox in a table.
Question 10
5 / 5 pts
(CO 3) Which of the following does NOT describe a caption property?
Question 11
5 / 5 pts
(CO 4) Which of the following does NOT describe the following description of a one-to-one relationship?
FE_IMG55.jpg
Description:
Image Description: There are two tables. Table number 1 is named Employees and has a primary key of EmpID with fields: LastName, FirstName, and Salary. Table number 2 is named NewEmployees and has a primary key of EmpID with fields of LastName, FirstName, and Hiring Expenses. The two tables are related with a line. The line has no symbols.
Question 12
5 / 5 pts
(CO 5) To edit a form, use
Question 13
(CO 5) The following are form creation tools except
Question 14
5 / 5 pts
(CO 6) Queries are objects in a database based on one or more underlying
Question 15
2 / 5 pts
(CO 6) The benefit of a relationship is to
determine which fields to include in each table.
Question 16
5 / 5 pts
(CO 9) A deletion anomaly is
Question 17
2 / 5 pts
(CO 2) Which of the following statements best describes data mining?
Question 18
5 / 5 pts
(CO 8) A navigation form is a
screen that is used to hide objects from users.
design tool to analyze and optimize a database.
Question 19
0 / 5 pts
(CO 9) An encrypted file is
Question 20
5 / 5 pts
(CO 9) A digital signature
Question 21
5 / 5 pts
(CO 10) After creating an ACCDE file, you
can convert it back to its source format.
Question 22
5 / 5 pts
Question 23
40 / 40 pts
(CO 1) Describe three-tier architecture. Explain the functions performed by each tier.
Three-
Presentation tier:.
Logic tier:
Data tier:
A computing architecture consists of the following.
Question 24
14 / 40 pts
(CO 2) Explain the purpose of a conceptual database model, and describe the most common method of creating one.
.
Question 25
40 / 40 pts
(CO 4) 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.
:
Entity:
.
Attribute:
Question 26
40 / 40 pts
(CO 4) 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?
TABLES AND THEIR COLUMN NAMES
Order :: OrderID , OrderDate, OrderTotalprice, OrderShipped
OrderLine :: OrderID , ProductID, OrderLineUnitsPrice , price
PRODUCTS :: ProductID , ProductName, NumberOfUnits, UnitPrice [Show Less]