answersLogoWhite

0

Database Programming

User Avatar

Aryanna Cummings

Lvl 10
2y ago
No Reviews
Leave the first rating

Rate this Study Guide:

Cards in this guide (21)
What is typically unique in each database table

ID number

Shana is keeping track of the expenses as deductions for her business when she files paperwork at the end of the year. What is Shana working on

income tax preparation

Jerome needs to track what materials the business has in stock and compare current amounts with the amounts at the beginning of the month. What is he working with

inventory

Olivia needs to provide a visual summary of expenses to management. She chooses a system that shows different levels for the expenses based on filled in sections. What did she create

bar graph

Jerry is entering information from the documents that show what customers bought and what they owe. What document is he working with

invoice

Defining table creates links between tables that identify a correspondence of fields from one table to another.

relationships

Which of the following would be a good example of data where complex sorting would be helpful

states and cities of hometowns of members of an organizations

Adding to a query specifies conditions that must be met for the values of the records to be returned by the query.

search parameters

Which of the following type of software is the most powerful for managing complex sets of data

database software

A business owner wishes to know which clients are the highest paying clients of his business. What tool is he likely to use to find this information

sorting

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

Which calculations come last in the order of operations

addition and subtraction

If a database required regular additions of new records what would likely be a good tool to use

Forms

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

What is typically unique in each database table

You need to add cells C3 and C7 and multiply C3 by C6. Based on the order of operations what would you do

David needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. Which function would he use when he wants the spreadsheet to decide a deduction based on

Shana is keeping track of the expenses as deductions for her business when she files paperwork at the end of the year. What is Shana working on

➡️
See all cards
No Reviews

What is typically unique in each database table

David needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. Which function would he use when he wants the spreadsheet to decide a deduction based on

Shana is keeping track of the expenses as deductions for her business when she files paperwork at the end of the year. What is Shana working on

Jerome needs to track what materials the business has in stock and compare current amounts with the amounts at the beginning of the month. What is he working with

➡️
See all cards
No Reviews

What is typically unique in each database table

David needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. Which function would he use when he wants the spreadsheet to decide a deduction based on

Shana is keeping track of the expenses as deductions for her business when she files paperwork at the end of the year. What is Shana working on

Jerome needs to track what materials the business has in stock and compare current amounts with the amounts at the beginning of the month. What is he working with

➡️
See all cards
No Reviews

What is typically unique in each database table

You need to add cells C3 and C7 and multiply C3 by C6. Based on the order of operations what would you do

David needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. Which function would he use when he wants the spreadsheet to decide a deduction based on

Locking a cell so that others cannot alter its contents is known as .

➡️
See all cards
No Reviews

What is typically unique in each database table

David needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. Which function would he use when he wants the spreadsheet to decide a deduction based on

Shana is keeping track of the expenses as deductions for her business when she files paperwork at the end of the year. What is Shana working on

Jerome needs to track what materials the business has in stock and compare current amounts with the amounts at the beginning of the month. What is he working with

➡️
See all cards
No Reviews