Access Tutorial 1

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

common field

Which Access database object(s) might be used to enter, edit, and view records in a database?

forms

Which of the following is an Access 2013 database object?

table

When using a mouse while in an Access 2013 work session, access a shortcut menu for an object by performing this task.

right click

Which Access feature provides information about Access commands and features and instructions about how to use them?

Access Help

Which Access 2013 view contains commands used to manage Access files and options?

Backstage view

Files created with Access 2013 may be used with which previous version of Access?

Access 2010

Another term used for the column selector feature is ____.

field selector

The specific content of a field is referred to as the ____.

field value

Which of the following attributes of a table are saved only when the table object is saved?

characteristics of the fields

What is the purpose of the primary key?

to uniquely identify each record in a table

Each row in an Access table datasheet displays which of the following?

a record

All data in a database is contained in which database object?

table

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS).

True

A formatted printout (or screen display) of the contents of one or more tables or queries is a(n) form.

False

Which of the following is the file extension used for Access 2013 database files?

.accdb

What function does compacting an Access database perform other than reducing the file size?

repairing the database

Data organized as a collection of tables creates this type of data system.

relational database management system

A single characteristic or attribute of a person, place, object, event, or idea is a(n) table.

False

Which of the following is an Access 2013 database object?
a. record
b. field
c. data
d. table

d. table

Field values that may be entered into a field are determined by the data type of the field.

True

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?

save the table object

Compacting a database rearranges the data and objects in a database to decrease its file size.

True

It is possible to view all Access objects in the Navigation Pane.

True

Which Ribbon group allows you to add fields to an Access table with defined data types?

Add & Delete

When copying and pasting records from one table to another, the records must first be copied to the ____.

clipboard

When creating a form in Access, the Layout view allows the user to make design changes to the form while it is displaying data.

True

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a datasheet.

True

Access report printing options may be changed using the Navigation dialog box.

False

The default primary key for an Access database is the ID field.

True

In a relational DBMS, a user may create a database structure that contains which of the following?

fields, tables, and table relationships

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?

Tab, Enter

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 ____.

programming tasks

When working with Access in ____ Mode, the user may tap the buttons on the Ribbon and also tap to use other features of Access 2013.

Touch

Which data type allows field values to contain letters, digits, and other characters?

Short Text

The default sort order for records in an Access table is based on the values in the primary key field.

True

Which Access 2013 view shows the contents of a table as a datasheet?

Datasheet view

The query results are stored in the database in which the query has been created.

False

Each record in a table is uniquely identified by a foreign key.

False

How many characters may a field name in Access contain including numbers, letters, spaces, and special characters?

64

A question asked about the data stored in a database is called a primary key.

False

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.

True

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?

best fit

Each column in an Access table datasheet represents a ____.

field