Microsoft Access Exam
Review Questions &
Answers
Access - ANSWERSA database program you use to enter, organize, display, and retrieve related
information.
Access window - ANSWERSThe program window that appears when you start the Access
program to create a new database or open an existing database.
Add & Delete group - ANSWERSA group on the Fields tab in Table Datasheet view that contains
options for adding different types of fields to a table.
All Access Objects - ANSWERSThe 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 - ANSWERSAn Access data type that automatically assigns a unique number to a
record.
backing up - ANSWERSMaking a copy of a database file to protect your database against loss or
damage.
Click to Add column - ANSWERSIn Datasheet view for a table, the datasheet column you can use
to create a new field in the table.
column selector - ANSWERSIn a datasheet, the column heading (also called the field selector)
that you click to select the entire column.
, common field - ANSWERSA field that appears in more than one table, allowing you to connect
the records in the separate tables
compacting - ANSWERSA 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 - ANSWERSA tab on the Ribbon that provides options for creating various database
objects, including tables, forms, and reports.
Current Record box - ANSWERSThe 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 - ANSWERSThe field property that determines what field values you can enter for the
field and what other properties the field will have.
database - ANSWERSA collection of related tables stored in the same file.
database management system (DBMS) - ANSWERSA software program that lets you create
databases and then manipulate data in them.
datasheet - ANSWERSThe 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 - ANSWERSA box in the upper-left corner of a datasheet that lets you select
the entire datasheet.
Review Questions &
Answers
Access - ANSWERSA database program you use to enter, organize, display, and retrieve related
information.
Access window - ANSWERSThe program window that appears when you start the Access
program to create a new database or open an existing database.
Add & Delete group - ANSWERSA group on the Fields tab in Table Datasheet view that contains
options for adding different types of fields to a table.
All Access Objects - ANSWERSThe 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 - ANSWERSAn Access data type that automatically assigns a unique number to a
record.
backing up - ANSWERSMaking a copy of a database file to protect your database against loss or
damage.
Click to Add column - ANSWERSIn Datasheet view for a table, the datasheet column you can use
to create a new field in the table.
column selector - ANSWERSIn a datasheet, the column heading (also called the field selector)
that you click to select the entire column.
, common field - ANSWERSA field that appears in more than one table, allowing you to connect
the records in the separate tables
compacting - ANSWERSA 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 - ANSWERSA tab on the Ribbon that provides options for creating various database
objects, including tables, forms, and reports.
Current Record box - ANSWERSThe 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 - ANSWERSThe field property that determines what field values you can enter for the
field and what other properties the field will have.
database - ANSWERSA collection of related tables stored in the same file.
database management system (DBMS) - ANSWERSA software program that lets you create
databases and then manipulate data in them.
datasheet - ANSWERSThe 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 - ANSWERSA box in the upper-left corner of a datasheet that lets you select
the entire datasheet.
