To display data returned from a query in a specific way.
🔄 Click to see term
Term1/17
The purpose of report text
🔄 Click to see definition
Definition1/17
purpose report text
🔄 Click to see term
Term1/17
What do parameters allow you to do
🔄 Click to see definition
Definition1/17
parameters let you run more specific and complex queries
🔄 Click to see term
Term1/17
Which of the following considerations should you identify when building a database
🔄 Click to see definition
Definition1/17
i should recognize what i want to do with the data
🔄 Click to see term
Term1/17
Kieran wants to search a database quickly for information on the last time a patient came to his medical facility. This information is contained in one table. Which feature would make the most sense f
🔄 Click to see definition
Definition1/17
sort
🔄 Click to see term
Term1/17
Jerry keeps a spreadsheet of all the tools he owns. He wants to figure out how many nails and screws he has so he knows how many more he needs to buy to have 500 total. If the number of nails and scre
🔄 Click to see definition
Definition1/17
the formula is =500-sum(B2:B3)
🔄 Click to see term
Term1/17
Penelope wants to search a transaction database to find all customers who spent more than 500 in one day so that these people can receive a coupon. What is the best way for Penelope to find this infor
🔄 Click to see definition
Definition1/17
she could add search parameters to only find records that have
transaction totals higher than $500
🔄 Click to see term
Term1/17
Leigh has information on how many customers purchase bagels at her coffee shop. With the bagel sales numbers from the past four months she wants to predict the bagel sales numbers for the next month.
🔄 Click to see definition
Definition1/17
predict trend
🔄 Click to see term
Term1/17
What mathematical process is the following formula performing C2D3
🔄 Click to see definition
Definition1/17
multiplication
🔄 Click to see term
Term1/17
In which of the following scenarios would you need to use a nested IF statement
🔄 Click to see definition
Definition1/17
to calculate a person's tax rate based on earnings
🔄 Click to see term
Term1/17
Why does each record need a unique ID number
🔄 Click to see definition
Definition1/17
a unique ID number is essential if you want to build to proper
relationships between tables
🔄 Click to see term
Term1/17
Elliot keeps spreadsheets of the expenses required to keep his stationary store in business. One keeps track of the monthly rent electric bill water bill and Internet bill. Which cells would it make s
🔄 Click to see definition
Definition1/17
rent and internet bill
🔄 Click to see term
Term1/17
Which calculations come last in the order of operations
🔄 Click to see definition
Definition1/17
addition and subtraction
🔄 Click to see term
Term1/17
Which spreadsheet type will determine how well a business has done over the past year
🔄 Click to see definition
Definition1/17
profit-and-loss statement
🔄 Click to see term
Term1/17
Why would you want to create a bar graph from a budget spreadsheet
🔄 Click to see definition
Definition1/17
to see where most of your money is going
🔄 Click to see term
Term1/17
A saves your query and formats it in a professional-looking way.
🔄 Click to see definition
Definition1/17
report
🔄 Click to see term
Term1/17
How does information technology bring employees closer to upper management
🔄 Click to see definition
Definition1/17
employees can with upper management directly through email
🔄 Click to see term
🥳
Great job!
You studied all the cards in this guide.
Rate this guide:
☆★☆★☆★☆★☆★
Start overPrint
Full screen
Rate this Study Guide:
☆★☆★☆★☆★☆★
Cards in this guide (17)
What is the purpose of a report
To display data returned from a query in a specific way.
The purpose of report text
purpose report text
What do parameters allow you to do
parameters let you run more specific and complex queries
Which of the following considerations should you identify when building a database
i should recognize what i want to do with the data
Kieran wants to search a database quickly for information on the last time a patient came to his medical facility. This information is contained in one table. Which feature would make the most sense f
sort
Jerry keeps a spreadsheet of all the tools he owns. He wants to figure out how many nails and screws he has so he knows how many more he needs to buy to have 500 total. If the number of nails and scre
the formula is =500-sum(B2:B3)
Penelope wants to search a transaction database to find all customers who spent more than 500 in one day so that these people can receive a coupon. What is the best way for Penelope to find this infor
she could add search parameters to only find records that have
transaction totals higher than $500
Leigh has information on how many customers purchase bagels at her coffee shop. With the bagel sales numbers from the past four months she wants to predict the bagel sales numbers for the next month.
predict trend
What mathematical process is the following formula performing C2D3
multiplication
In which of the following scenarios would you need to use a nested IF statement
to calculate a person's tax rate based on earnings
Why does each record need a unique ID number
a unique ID number is essential if you want to build to proper
relationships between tables
Elliot keeps spreadsheets of the expenses required to keep his stationary store in business. One keeps track of the monthly rent electric bill water bill and Internet bill. Which cells would it make s
rent and internet bill
Which calculations come last in the order of operations
addition and subtraction
Which spreadsheet type will determine how well a business has done over the past year
profit-and-loss statement
Why would you want to create a bar graph from a budget spreadsheet
to see where most of your money is going
A saves your query and formats it in a professional-looking way.
report
How does information technology bring employees closer to upper management
employees can with upper management directly through email