Module 1

Question 1

Access

Answer 1

A database program you use to enter, organize, display, and retrieve related information.

Question 2

Field

Answer 2

A single characteristic or attribute of a person, place, object, event, or idea.

Question 3

table

Answer 3

A collection of fields that describes a person, place, object, event, or idea.

Question 4

field value

Answer 4

The specific value, or content, of a field in a record.

Question 5

record

Answer 5

A complete set of field values for a specific person, place, object, event, or idea.

Question 6

database

Answer 6

A collection of related tables stored in the same file.

Question 7

relational database

Answer 7

A collection of related tables stored in the same file.

Question 8

record selector

Answer 8

In a datasheet, the small square at the beginning of a row (also called the row selector) that you click to select the entire row.

Question 9

column selector

Answer 9

In a datasheet, the column heading (also called the field selector) that you click to select the entire column.

Question 10

row selector

Answer 10

In a datasheet, the small square at the beginning of a row (also called the record selector) that you click to select the entire row.

Question 11

pencil symbol

Answer 11

The symbol that appears in a row selector to indicate that the record is being edited.

Question 12

star symbol

Answer 12

The symbol that appears in a row selector to indicate that the row is the next one available for a new record.

Question 13

Current Record box

Answer 13

The box that appears at the bottom of a datasheet or form and that indicates the current record and total number of records displayed.

Question 14

datasheet selector

Answer 14

A box in the upper-left corner of a datasheet that lets you select the entire datasheet.

Question 15

navigation buttons

Answer 15

A set of buttons found at the bottom of a table datasheet or form that you use to move through the records in the table.

Question 16

Layout view

Answer 16

The Access view in which you can make design changes to a form or report while it is displaying data so that you can immediately see the effects of changing the design.

Question 17

Print Preview

Answer 17

The view of a report, form, or datasheet that shows you what the object will look like when printed.

Question 18

All Access Objects

Answer 18

The default category in the Navigation Pane; it lists all the objects in the database grouped by type (tables, queries, forms, reports, and so on).

Question 19

Compacting

Answer 19

A process that rearranges the data and objects in a database to decrease its file size, thereby making more space available and enhancing the performance of the database.

Question 20

Backing up

Answer 20

Making a copy of a database file to protect your database against loss or damage.

Question 21

Microsoft Access 2016

Answer 21

A database program you use to enter, organize, display, and retrieve related information.

Question 22

common field

Answer 22

A field that appears in more than one table, allowing you to connect the records in the separate tables.

Question 23

primary key

Answer 23

A field, or a collection of fields, whose values uniquely identify each record in a database table.

Question 24

foreign key

Answer 24

A primary key field from one table that you include as a field in a second table to form a relationship between the two tables.

Question 25

database management system (DBMS)

Answer 25

A software program that lets you create databases and then manipulate data in them.

Question 26

relational database management system

Answer 26

A software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field.

Question 27

Backstage view

Answer 27

The File tab of the ribbon, which provides access to file-level options and program settings.

Question 28

template

Answer 28

A predefined database that includes professionally designed tables, forms, reports, and other objects.

Question 29

contextual tab

Answer 29

A tab that appears and provides options for working with a specific object that is selected.

Question 30

data type

Answer 30

The field property that determines what field values you can enter for the field and what other properties the field will have.

Question 31

AutoNumber

Answer 31

An Access data type that automatically assigns a unique number to a record.

Question 32

Short Text

Answer 32

An Access data type that allows field values containing letters, digits, and other characters.

Question 33

field selector

Answer 33

In a datasheet, the column heading (also called the column selector)that you click to select the entire column.