K201 Study Guide Exam with All
Actual Answers 2026 Updated.
For a new record, the State field already contains the value IN for Indiana. How? - Answer
The use of "IN" in the Default Value field property
The StartDate field prohibits entry of a date greater than today's date. Which field property was
used? - Answer Validation Rule
The values that the Zip Code field will contain looks like this: 47405-1276. What is the best field
size? - Answer 10
The ZipCode field contains data such as 47405. Select the best data type. - Answer Short Text
You have a field called Notes that will store lengthy comments (over 255 characters). Which
data type would be best for this? - Answer Long Text
Automatically adds data in a new record. - Answer Default?
The longest value that the Department field will contain is "Human Resources". What is the best
field size? - Answer 15
This indicates a zero length string. It is also called a blank. - Answer ""
The query critera, *MP3 used on a Long Text field would return records that contain the phrase
- Answer Portable MP3
In your Premiere database, what would you type in the criteria row of a query to locate
members born on May 13th of any year? - Answer 5/13/*
TransactionDate - Answer Where
Each Information System is comprised of five components. Match the component with the
, In order for data to be considered timely it must be delivered in real time. - Answer FALSE
Good data are always worth the cost, no matter how expensive. - Answer FALSE
A student team, which is assigned a term project, meets and divides the work into sections and
then team members work independently on their individual pieces. An hour before the project
is due the team members meet again to assemble their independent pieces into a whole. Which
of the following is lacking in this activity? - Answer Collaboration
Which of the following is a primary purpose of collaboration? - Answer Becoming Informed
Project leaders have to make decisions on the allocation and utilization of materials and labor.
Such decisions are called ________ decisions. - Answer Managerial Decisions
An organization uses a formula to compute the reorder quantity of an item in inventory. This is
an example of a(n) ________ decision process. - Answer Structured Decision Process
The need for collaboration is greatest for ________ decisions. - Answer Strategic
In the textbook, it defines the collaboration as a group of people working together to achieve a
common goal via the process of _____ and ______. - Answer Feedback and Iteration
Which of the following is the criteria for successful collaboration? - Answer All of the above
During which of the following stages do teams document project results and information for
future teams? - Answer Finalizing
Project data are data that are ________. - Answer part of the collaboration's work product
Asynchronous communication occurs when team members ________. - Answer When
members don't meet at the same time
Porter's five forces model is used to assess ________. - Answer Industry Structure
Actual Answers 2026 Updated.
For a new record, the State field already contains the value IN for Indiana. How? - Answer
The use of "IN" in the Default Value field property
The StartDate field prohibits entry of a date greater than today's date. Which field property was
used? - Answer Validation Rule
The values that the Zip Code field will contain looks like this: 47405-1276. What is the best field
size? - Answer 10
The ZipCode field contains data such as 47405. Select the best data type. - Answer Short Text
You have a field called Notes that will store lengthy comments (over 255 characters). Which
data type would be best for this? - Answer Long Text
Automatically adds data in a new record. - Answer Default?
The longest value that the Department field will contain is "Human Resources". What is the best
field size? - Answer 15
This indicates a zero length string. It is also called a blank. - Answer ""
The query critera, *MP3 used on a Long Text field would return records that contain the phrase
- Answer Portable MP3
In your Premiere database, what would you type in the criteria row of a query to locate
members born on May 13th of any year? - Answer 5/13/*
TransactionDate - Answer Where
Each Information System is comprised of five components. Match the component with the
, In order for data to be considered timely it must be delivered in real time. - Answer FALSE
Good data are always worth the cost, no matter how expensive. - Answer FALSE
A student team, which is assigned a term project, meets and divides the work into sections and
then team members work independently on their individual pieces. An hour before the project
is due the team members meet again to assemble their independent pieces into a whole. Which
of the following is lacking in this activity? - Answer Collaboration
Which of the following is a primary purpose of collaboration? - Answer Becoming Informed
Project leaders have to make decisions on the allocation and utilization of materials and labor.
Such decisions are called ________ decisions. - Answer Managerial Decisions
An organization uses a formula to compute the reorder quantity of an item in inventory. This is
an example of a(n) ________ decision process. - Answer Structured Decision Process
The need for collaboration is greatest for ________ decisions. - Answer Strategic
In the textbook, it defines the collaboration as a group of people working together to achieve a
common goal via the process of _____ and ______. - Answer Feedback and Iteration
Which of the following is the criteria for successful collaboration? - Answer All of the above
During which of the following stages do teams document project results and information for
future teams? - Answer Finalizing
Project data are data that are ________. - Answer part of the collaboration's work product
Asynchronous communication occurs when team members ________. - Answer When
members don't meet at the same time
Porter's five forces model is used to assess ________. - Answer Industry Structure
