0
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
Term1/28
Definition1/28
🥳
Great job!
You studied all the cards in this guide.
Rate this guide:
☆☆☆☆☆
Rate this Study Guide:
☆☆☆☆☆Cards in this guide (28)
What is the purpose of a report
To display data returned from a query in a specific way.
What do parameters allow you to do
parameters let you run more specific and complex queries
What is typically unique in each database table
ID number
Which of the following considerations should you identify when building a database
i should recognize what i want to do with the data
Adding to a query specifies conditions that must be met for the values of the records to be returned by the query.
search parameters
Let you show only certain records on a table when you sort them.
filters
What is an important step to take before entering your first data into your database
planning
Information is stored in what type of object in a database
table
A restaurant owner wants to use a database to help his business. What would be a good thing for him to do first
ask himself what his purposes will be for using a database
Saul is looking at the records in his annual plantings table in his database and wants to group the records according to variety. What tool can he use
sort
A certain database has numerous tables but they do not share any fields in common. This database will not be as powerful as others because it is not .
relational
Search can be added to queries to obtain more specific results.
parameters
Hiro was using the database to prepare information for a presentation to potential investors. Which tool is he likely to use
reports
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
A(n) evaluates a specified data set and returns certain fields from that data set as instructed
Query (apex)
When queries are saved and run again at a later date one advantage is that the query uses the most
Current (apex)
Related study guides
☆☆☆☆☆
No Reviews☆☆☆☆☆
No Reviews☆☆☆☆☆
No Reviews☆☆☆☆☆
No Reviews☆☆☆☆☆
No Reviews
Copyright ©2024 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.