BIS245 Week 1 Quiz 2017/BIS245 Week 1 Quiz 2017

QuestionQuestion 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)fieldrecordtabledatabaseQuestion 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)DatasheetDesignFormReportQuestion 6.6. (TCO 2) To add, delete, and edit fields in a table, use which of the following? (Points : 5)Datasheet view of a tableDesign view of a tableDesign view of a queryReport viewQuestion 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.