BIS245 WEEK 1: QUIZ practice weekly questions and answers

BIS245 WEEK 1: QUIZ practice weekly questions and answers (CO 1) A database management system (DBMS) is a collection of programs that store data. manage data. use collections of data. All of the above (CO 1) Which statement is NOT true? A relationship is a connection between two tables using a common field. A primary key is used to identify common fields in a table. Multiple users on different computers can work on a database simultaneously. available for use. (CO 1) A filter is best described as 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. (CO 1) To locate the tool to compact an Access database, click on the file tab, options, current database, and select compact and repair database tools. home tab, advanced, and select compact and repair database tools. database tools tab, and select compact and repair database tools. (CO 1) Field names in a table can be created or modified in which view? Datasheet Design Form Report (CO 2) To add, delete, and edit a record, use datasheet view of a table. design view of a table. report view. (CO 2) When building a database, you should first 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. (CO 1) Excel should be used instead of Access when you have a small amount of data. your data needs to be regrouped in various views. your data requires a relational database.