BCIS-Unit 5/Quiz 1- Database Basics

Which of the following list is in ASCENDING order? -Wright, Shea, Hornor, Gibbs -Hornor, Gibbs, Shea, Wright -Hornor, Shea, Gibbs, Wright -Gibbs, Hornor, Shea, Wright

-Gibbs, Hornor, Shea, Wright

Which of the following list is in DESCENDING order? -Wright, Shea, Hornor, Gibbs -Hornor, Gibbs, Shea, Wright -Hornor, Shea, Gibbs, Wright -Gibbs, Hornor, Shea, Wright

-Wright, Shea, Hornor, Gibbs

Which 2 of the following can a database do? -create a bar graph -conduct a search -update information in more than one place at the same time -calculate formulas

-conduct a search -update information in more than one place at the same time

Which 3 of the following can a database FINALLY do? -conduct a search -update information in more than one place at the same time -find the average of 4 numbers -validate the data entered and check for incosistencies

-conduct a search -update information in more than one place at the same time -validate the data entered and check for inconsistencies

Which of the following makes it easier for any type of person doing data entery to enter information into a database? -record -table -database in design view -data entry form

-data entry form

Data entry is the process of getting information into a ________________. -record -table -database -spreadsheet

-database

If a person wants to organize information about any subject they should use___________________________. -record -table -database -spreadsheet

-database

Mrs. Wright has a collection of teddy bears and their worth. She would like to organize the information about her teddy bears incase she might want to sell them one day. What should Mrs. Wright use? -spreadsheet -word processor -database -web page

-database

Terry has created a database of dog food sold at her pet store. The manufacturers have recalled several brands of dog food, but NOT all of the ones that she has in her store. What should Terry do to take these recalled items out of her database? -update records -delete fields -create a new database -delete records

-delete records

If you wanted to organize your information with the item that cost the most at the top of the table, you would sort in _________________ order. -alphabetical -ascending -descending -cronological

-descending

Kerry wants to add the birthdays of all the girl scouts in her troop to the database. How can Kerry do this? -insert a new record -delete a field -insert a new field -sort the database

-insert a new field

Paul is creating a database to keep track of car part sales. He wants to be abe to look up a description of the part and the barcode number. He also wants to be able to sort by mechanic and price. What fields should he have in his database? -mechanic and price -mechanic, price, description and barcode number -mechanic, price and description -mechanic, price, description, number in stock

-mechanic, price, description and barcode number

When creating any type of document, what is the first step you must always do? -write down the information -create the document -plan out what you want it to look like -give the document a title

-plan out what you want it to look like

One set of data or complete entry is called a ___________. -database -record -category -new field

-record

Which 2 of the following can a database ALSO do? -sort and manipulate the data -write a business letter -create data entry forms -create a flyer

-sort and manipulate the data -create data entry forms

Kerry wants to arrange her records in ascending order by the number of cookies sold. How would she do this? -update the data -locate a record -sort the data -delete a record

-sort the data

Paul wants to calculate how much he made in tips being a waiter for a year. What should he use to do this? -database -spreadsheet -word processor -data entry form

-spreadsheet

A _____________ is a set of rows and columns that is used for organizing data. -record -table -spreadsheet

-table

Kerry keeps a database to track of the number of cookies for all the girl scouts in her troop. Three of the girls sold 4 more boxes of cookies each. What does Kerry need to do? -delete the record and insert a new record -delete the address field -clear the address field -update the record

-update the record