CIT105-ACCESS Quiz 1

Another term used for the column selector feature is ____. A. row selector B. record selector C. name selector D. field selector

Clicking on the Close option from the Backstage view in Access 2016 performs which of the following tasks? A. closes the current database B. closes the current database and exits Access 2016 C. closes only the current database object D. copies the current database and exits Access 2016

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

Each column in an Access table datasheet represents a ____. A. query B. record C. field D. primary key

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

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

Files created with Access 2016 may be used with which previous version of Access? A. Access 2010 B. Access 2000 C. Access 2005 D. Access 2003

How many characters may a field name in Access contain including numbers, letters, spaces, and special characters? A. 255 B. 36 C. 64 D. 146

In a relational DBMS, a user may create a database structure that contains which of the following? A. data, fields, and table relationships B. numbers, tables, and fields C. symbols, numbers, and tables D. fields, tables, and table relationships

The specific content of a field is referred to as the ____. A. field content B. field value C. table value D. column value

To save a table in Access with a name that relates to the database (a name other than the Access default name), it is necessary to complete which process? A. save the table object B. save the database C. save the record D. save the field

What function does compacting an Access database perform other than reducing the file size? A. sorting the database B. querying the database C. saving the database D. repairing the database

What is the purpose of the primary key? A. to uniquely identify each record in a table B. to uniquely identify each table in a database C. to create a relationship between two tables in a database D. to create a relationship for queries in a database

When copying and pasting records from one table to another, the records must first be copied to the ____. A. database B. query C. storage device D. clipboard

When using a mouse while in an Access 2016 work session, access a shortcut menu for an object by performing this task. A. scroll the vertical scroll bar B. scroll the horizontal scroll bar C. cllick on the Navigation Pane D. right click

When working with Access in ____ Mode, the user may tap the buttons on the Ribbon and also tap to use other features of Access 2016. A. Write B. Touch C. Tap D. Tablet

Which Access 2016 view contains commands used to manage Access files and options? A. Datasheet view B. Design view C. Backstage view D. Form view

Which Access 2016 view shows the contents of a table as a datasheet? A. Design view B. Datasheet view C. Form view D. Table view

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question? A. form B. table C. query D. report

Which Access database object(s) might be used to enter, edit, and view records in a database? A. macros B. forms C. reports D. templates

Which Access feature provides information about Access commands and features and instructions about how to use them? A. Query Wizard B. Access Help C. Form Wizard D. Report Wizard

Which button is used to open and close the Navigation Pane? A. Navigation Bar B. Record C. Shutter Bar Open/Close D. Table View

Which data type allows field values to contain letters, digits, and other characters? A. Short Text B. AutoNumber C. Currency D. Date/Time

Which of the following attributes of a table are saved only when the table object is saved? A. records B. field values C. characteristics of the fields D. data records

Which of the following is the file extension used for Access 2016 database files? A. .mdb B. .acdbs C. .accdb D. .dbacc

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column? A. wide fit B. best fit C. column adjustment fit D. trim fit

Which Ribbon group allows you to add fields to an Access table with defined data types? A. Properties B. Formatting C. Field Validation D. Add & Delete

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables? A. primary key field B. field value C. foreign key field D. common field

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data? A. Tab, Insert B. Enter, PgDn C. Insert, PgUp D. Tab, Enter

Which view is used to make design changes to a form while the form is displaying data? A. Design view B. Table view C. Layout view D. Datasheet view