Microsoft Access Terms UPDATED ACTUAL
Exam Questions and CORRECT Answers
Database - CORRECT ANSWER - A file that consists of one or more tables and the
supporting objects used to get data into and out of the fields
Relational database software - CORRECT ANSWER - a computer application, such as
Microsoft Access, that is used to store data and convert it into information
Relational database management system - CORRECT ANSWER - Data are grouped into
similar collections, called tables, and the relationships between tables are formed by using a
common field
Flat or non-relational data - CORRECT ANSWER - data contained in a single page or
sheet
Field - CORRECT ANSWER - a basic entity, data element, or category, such as a book
title or telephone number
Column - CORRECT ANSWER - the data field that you assign to group data vertically
into columns. Example: First name, last name, address, and phone number
Record - CORRECT ANSWER - a complete set of all of the data about one person, place,
event, or idea. Example: All the fields on my class roster about one student.
Row - CORRECT ANSWER - the source field that you assign to group data horizontally
in a crosstab query
Table - CORRECT ANSWER - a collection of records
, Primary key - CORRECT ANSWER - the field that makes each record in a table unique;
ex. Student ID number
Foreign key - CORRECT ANSWER - a field in one table that also is stored in a different
table as a primary key
Query - CORRECT ANSWER - a database object that enables you to ask questions about
the data stored in a database and returns the answers in the order from the records that match
your instructions
Form - CORRECT ANSWER - an interface that enables you to enter or modify record data
Report - CORRECT ANSWER - a printed document that displays information
professionally form a database
Access speed - CORRECT ANSWER - the amount of time it takes for the storage device
to make the file content available for use
Compact and Repair Database Utility - CORRECT ANSWER - Reduces the size of the
database and eliminates wasted space
Datasheet view - CORRECT ANSWER - a grid containing columns and rows where you
add, edit, and delete records in a database table
Design view - CORRECT ANSWER - displays the infrastructure of a table, form, or report
without displaying the data
One-to-many relationship - CORRECT ANSWER - exists when each record in the first
table may match one, more than one, or no records in the second table
Cascades - CORRECT ANSWER - permit data changes to travel from one table to another.
Exam Questions and CORRECT Answers
Database - CORRECT ANSWER - A file that consists of one or more tables and the
supporting objects used to get data into and out of the fields
Relational database software - CORRECT ANSWER - a computer application, such as
Microsoft Access, that is used to store data and convert it into information
Relational database management system - CORRECT ANSWER - Data are grouped into
similar collections, called tables, and the relationships between tables are formed by using a
common field
Flat or non-relational data - CORRECT ANSWER - data contained in a single page or
sheet
Field - CORRECT ANSWER - a basic entity, data element, or category, such as a book
title or telephone number
Column - CORRECT ANSWER - the data field that you assign to group data vertically
into columns. Example: First name, last name, address, and phone number
Record - CORRECT ANSWER - a complete set of all of the data about one person, place,
event, or idea. Example: All the fields on my class roster about one student.
Row - CORRECT ANSWER - the source field that you assign to group data horizontally
in a crosstab query
Table - CORRECT ANSWER - a collection of records
, Primary key - CORRECT ANSWER - the field that makes each record in a table unique;
ex. Student ID number
Foreign key - CORRECT ANSWER - a field in one table that also is stored in a different
table as a primary key
Query - CORRECT ANSWER - a database object that enables you to ask questions about
the data stored in a database and returns the answers in the order from the records that match
your instructions
Form - CORRECT ANSWER - an interface that enables you to enter or modify record data
Report - CORRECT ANSWER - a printed document that displays information
professionally form a database
Access speed - CORRECT ANSWER - the amount of time it takes for the storage device
to make the file content available for use
Compact and Repair Database Utility - CORRECT ANSWER - Reduces the size of the
database and eliminates wasted space
Datasheet view - CORRECT ANSWER - a grid containing columns and rows where you
add, edit, and delete records in a database table
Design view - CORRECT ANSWER - displays the infrastructure of a table, form, or report
without displaying the data
One-to-many relationship - CORRECT ANSWER - exists when each record in the first
table may match one, more than one, or no records in the second table
Cascades - CORRECT ANSWER - permit data changes to travel from one table to another.
