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_____ (Points : 5)       Field

      Record

      Table

      Database

Question 2. 2. (TCO 1) You should use Access over Excel when: (Points : 5)

      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?

(Points : 5)

      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 (Points : 5)

      a nonrelational 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

bis_245.docx

11 years ago

Report issue