• Florida International University

• CGS 2100

 A database or a relational database is a collection of related tables. a. True b. False ANSWER: True  A field in a second table that is the primary key in the first table is used to form a relationship between the two tables; the field in the second table is called a(n) ______ANSWER: foreign key  A field, or collection of fields, whose values are used to uniquely identify each record in a table. ANSWER: b. primary key  A formatted printout (or screen display) of the contents of one or more tables or queries is a(n) form. __________ANSWER: False - report  A query is used to enter, edit, and view records in a database. a. True b. False ANSWER: False  A question asked about the data stored in a database is called a primary key. a. True b. False ANSWER: False  A question that is asked about the data stored in a database. ANSWER: g. query  A relationship between two tables in a database is formed using a(n) Backstage field. ________ANSWER: False - common  A single characteristic or attribute of a person, place, object, event, or idea is a(n) table. ______ANSWER: False - field  A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS). a. True b. False ANSWER: True  A status box that displays the number of the current record and the total number of records in a table. ANSWER: e. Current Record Box  A table is a predesigned database that includes professionally designed database objects. a. True b. False ANSWER: False  A table’s contents are shown in rows and columns when using the _________view. ANSWER: Datasheet  Access report printing options may be changed using the Navigation dialog box. ____ANSWER: False - Print  Access reports are based on a selected __________or _________. ANSWER: table, query  All data in a database is contained in which database object? a. query b. form c. report d. table ANSWER: d  All of the data in a relational database are contained in _____________ANSWER: tables  An Access 2013 tool that allows the user to quickly add fields and records to display in query results. ANSWER: h. Simple Query Wizard  An important reference tool available in Access 2013, which may be used to assist a user with problems that might occur, is the _______system. ANSWER: Access Help  Another term used for the column selector feature is ____. a. row selector b. record selector c. name selector d. field selector ANSWER: d  AutoNumber and Short Text are two examples of this Access feature which determines the values that may be entered in a field. ANSWER: d. data type  Based on the table descriptions, which fields might be used to create a relationship between the Vendors and Venue tables? ANSWER: The Venue Space Assigned field from the Vendors table and the TentNumber field from the Venue table could be a common field used to relate the two tables.  Clicking on the Close option from the Backstage view in Access 2013 performs which of the following tasks? a. closes the current database b. closes the current database and exits Access 2013 c. closes only the current database object d. copies the current database and exits Access 2013 ANSWER: a  Clicking or tapping this navigation button moves the insertion point to the ____________________ in a table. ANSWER: last record  Compacting a database rearranges the data and objects in a database to decrease its file size. a. True b. False ANSWER: True  Complete field names for all fields are not visible in the table. Which Access feature can Marissa use to make the entire field name visible while entering data? ANSWER: best fit column width feature  Data can be presented in customized and useful ways different from tables and queries by using a Simple __________ANSWER: form  Data organized as a collection of tables creates this type of data system. a. database b. database management system (DBMS) c. primary key system d. relational database management system. ANSWER: d  Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time. _______ANSWER: True  Each column in an Access table datasheet represents a ____. a. query b. record c. field d. primary key ANSWER: c  Each record in a table is uniquely identified by a foreign key. a. True b. False ANSWER: False  Each row in an Access table datasheet displays which of the following? a. a query b. a record c. a field d. a data type ANSWER: b  Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____. a. creating reports using Access b. related databases c. programming tasks d. queries ANSWER: c  Explain the difference between a primary key an