BIS 245 Quiz Solution

bis_245.docx

Home >Computer Science homework help >BIS 245 Quiz Solution

1. (TCO 1) A collection of customer information and purchase transactions that might be stored in both Access and Excel would be called a Database.

Record Table Database

Question 2. 2. (TCO 1) You should use Access over Excel when you have a large amount of data.

you have a large amount of data.

you need to create complex charts.

you have only one worksheet to handle all of your data.

you have extensive subtotals and totals in your worksheet.

Question 3. 3. (TCO 1) Examining the image below, which statement best describes what we see?

Six records have been filtered from a query called Employees. Six records have been filtered on the Title field containing Sales Representative from the Employees table. A table called Employees has been created from six filtered records. A query called Employees has been created from a filtered table.

Question 4. 4. (TCO 1) Access should be used instead of Excel when

a no relational view of the data is needed. you need to run various comparisons of statistical and comparative data. you need to sort, group, and total data in various views. you only need a smaller, manageable amount of data.

Question 5. 5. (TCO 1) On which tab is the Sort & Filter group found? (Points : 5)

File Home Create External Data

Question 6. 6. (TCO 2) In using a web search engine, typing the web site address in the proper place in the Brower and then hitting enter is called (Points : 5)

server setup. presentation task. client browsing. systems application.

Question 7. 7. (TCO 2) Types of relationships between tables do NOT include (Points : 5)

one-to-one many-to-many primary-to-foreign many-to-one

Question 8. 8. (TCO 1) To display a subset of records based on certain criteria, use which of the following? (Points : 5)

Filter Form Report Table