Your management team is deciding on a new allocation of computers. If there are more than 15 employees in an office, you will allocate 10 computers. If there are between 10 and 14 employees, you will allocate 8 computers. If there are fewer than 10 employees, you will allocate 5 computers. You have a table that contains each location's employment numbers. What is the best Access function to use
for this allocation?
A) IIF function B) Payment function
C) Future Value function D) Nested IIF function
D
You might also like to view...
Answer the following statements true (T) or false (F)
1. The first element in an array called names is names[1]. 2. The last element in the array defined by float pay[12]; is pay[12]. 3. Parallel arrays are arrays with the same number of elements used to store related information. 4. In the following array: 15 8 10 11 72 10 is a subscript. 5. In the following array: 4 6 35 78 94 3 53 76 6 is an element.
What types of objects can be used to create linked tables in Access? What are the consequences of poor file management in regards to linked tables?
What will be an ideal response?
Kathy wants to display the row labels in a single column. Which PivotTable layout should Kathy use?
What will be an ideal response?
A column in a table that describes a characteristic about a record is called a(n) ____________________.
Fill in the blank(s) with the appropriate word(s).