MICROSOFT ACCESS EXAM REVIEW
QUESTIONS WITH CORRECT ANSWERS
Access - Correct Answer - A database program you use to enter, organize, display, and
retrieve related information.
Access window - Correct Answer - The program window that appears when you start
the Access program to create a new database or open an existing database.
Add & Delete group - Correct Answer - A group on the Fields tab in Table Datasheet
view that contains options for adding different types of fields to a table.
All Access Objects - Correct Answer - 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).
AutoNumber - Correct Answer - An Access data type that automatically assigns a
unique number to a record.
backing up - Correct Answer - Making a copy of a database file to protect your database
against loss or damage.
Click to Add column - Correct Answer - In Datasheet view for a table, the datasheet
column you can use to create a new field in the table.
column selector - Correct Answer - In a datasheet, the column heading (also called the
field selector) that you click to select the entire column.
common field - Correct Answer - A field that appears in more than one table, allowing
you to connect the records in the separate tables
compacting - Correct Answer - A process that rearranges the data and objects in a
database to decrease its file size, thereby making more space available on your disk
and letting you open and close the database more quickly.
Create tab - Correct Answer - A tab on the Ribbon that provides options for creating
various database objects, including tables, forms, and reports.
Current Record box - Correct Answer - The box that appears at the bottom of a
datasheet or form and that indicates the current record and total number of records
displayed.
, data type - Correct Answer - The field property that determines what field values you
can enter for the field and what other properties the field will have.
database - Correct Answer - A collection of related tables stored in the same file.
database management system (DBMS) - Correct Answer - A software program that lets
you create databases and then manipulate data in them.
datasheet - Correct Answer - The display of a table's contents in rows and columns,
similar to a table or spreadsheet; each row is a separate record in the table, and each
column contains the field values for one field in the table.
datasheet selector - Correct Answer - A box in the upper-left corner of a datasheet that
lets you select the entire datasheet.
Datasheet view (for a table) - Correct Answer - The Access view that shows a table's
contents as a datasheet in rows and columns.
field - Correct Answer - A single characteristic or attribute of a person, place, object,
event, or idea.
field selector - Correct Answer - In a datasheet, the column heading (also called the
column selector)that you click to select the entire column.
field value - Correct Answer - The specific value, or content, of a field in a record. (AC 4)
Fields tab - Correct Answer - tab on the Ribbon that provides options for adding,
removing, and formatting the fields in a table. (AC 2)
foreign key - Correct Answer - 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. (AC 5)
form - Correct Answer - A database object you can create and customize to maintain,
view, and print records in a database in different and useful ways. (AC 22)
Form tool - Correct Answer - An Access tool that creates a form containing all the fields
in the table or query on which the form is based. (AC 22)
Form Wizard - Correct Answer - An Access tool that asks you a series of questions, and
then creates a form based on your answers. (AC 22)
ID column - Correct Answer - The default field Access creates to serve as the primary
key field for all new tables. (AC 2)
QUESTIONS WITH CORRECT ANSWERS
Access - Correct Answer - A database program you use to enter, organize, display, and
retrieve related information.
Access window - Correct Answer - The program window that appears when you start
the Access program to create a new database or open an existing database.
Add & Delete group - Correct Answer - A group on the Fields tab in Table Datasheet
view that contains options for adding different types of fields to a table.
All Access Objects - Correct Answer - 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).
AutoNumber - Correct Answer - An Access data type that automatically assigns a
unique number to a record.
backing up - Correct Answer - Making a copy of a database file to protect your database
against loss or damage.
Click to Add column - Correct Answer - In Datasheet view for a table, the datasheet
column you can use to create a new field in the table.
column selector - Correct Answer - In a datasheet, the column heading (also called the
field selector) that you click to select the entire column.
common field - Correct Answer - A field that appears in more than one table, allowing
you to connect the records in the separate tables
compacting - Correct Answer - A process that rearranges the data and objects in a
database to decrease its file size, thereby making more space available on your disk
and letting you open and close the database more quickly.
Create tab - Correct Answer - A tab on the Ribbon that provides options for creating
various database objects, including tables, forms, and reports.
Current Record box - Correct Answer - The box that appears at the bottom of a
datasheet or form and that indicates the current record and total number of records
displayed.
, data type - Correct Answer - The field property that determines what field values you
can enter for the field and what other properties the field will have.
database - Correct Answer - A collection of related tables stored in the same file.
database management system (DBMS) - Correct Answer - A software program that lets
you create databases and then manipulate data in them.
datasheet - Correct Answer - The display of a table's contents in rows and columns,
similar to a table or spreadsheet; each row is a separate record in the table, and each
column contains the field values for one field in the table.
datasheet selector - Correct Answer - A box in the upper-left corner of a datasheet that
lets you select the entire datasheet.
Datasheet view (for a table) - Correct Answer - The Access view that shows a table's
contents as a datasheet in rows and columns.
field - Correct Answer - A single characteristic or attribute of a person, place, object,
event, or idea.
field selector - Correct Answer - In a datasheet, the column heading (also called the
column selector)that you click to select the entire column.
field value - Correct Answer - The specific value, or content, of a field in a record. (AC 4)
Fields tab - Correct Answer - tab on the Ribbon that provides options for adding,
removing, and formatting the fields in a table. (AC 2)
foreign key - Correct Answer - 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. (AC 5)
form - Correct Answer - A database object you can create and customize to maintain,
view, and print records in a database in different and useful ways. (AC 22)
Form tool - Correct Answer - An Access tool that creates a form containing all the fields
in the table or query on which the form is based. (AC 22)
Form Wizard - Correct Answer - An Access tool that asks you a series of questions, and
then creates a form based on your answers. (AC 22)
ID column - Correct Answer - The default field Access creates to serve as the primary
key field for all new tables. (AC 2)
