BIS245 Week 1 Quiz 2017

Question

Question 1.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) A filter is best described as (Points : 5)

a subset of records from an object based on specified criteria.

a sorted list of records in an object.

a record list from a table.

another name for a query.

Question 4.4. (TCO 1) The view in Access which looks similar to an Excel spreadsheet is (Points : 5)

Datasheet.

Design.

Form.

Report.

Question 5.5. (TCO 1) Field names can be created or modified in which view? (Points : 5)

Datasheet

Design

Form

Report

Question 6.6. (TCO 2) To add, delete, and edit fields in a table, use which of the following? (Points : 5)

Datasheet view of a table

Design view of a table

Design view of a query

Report view

Question 7.7. (TCO 2) When building a database, you should first (Points : 5)

create and input the design of the table and reports at the same time.

determine the input and then design the tables.

determine the output and then design the tables.

input the data and then design the reports.

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

you have a large amount of data.

you need to group, sort, and total data based on various parameters.

you need multiple related tables to store data.

you require a series of What-if scenarios on your data.