Microsoft Access Exam Review UPDATED
ACTUAL Exam Questions and 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.
ACTUAL Exam Questions and 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.
