MICROSOFT ACCESS TERMS
Database - 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 - ANSWER a computer application, such as
Microsoft Access, that is used to store data and convert it into information
Relational database management system - 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 - ANSWER data contained in a single page or sheet
Field - ANSWER a basic entity, data element, or category, such as a book title
or telephone number
Column - ANSWER the data field that you assign to group data vertically into
columns. Example: First name, last name, address, and phone number
Record - 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 - ANSWER the source field that you assign to group data horizontally in
a crosstab query
Table - ANSWER a collection of records
, Primary key - ANSWER the field that makes each record in a table unique; ex.
Student ID number
Foreign key - ANSWER a field in one table that also is stored in a different
table as a primary key
Question - ANSWER A database object through which you can ask questions
about data in a database, and get answers. The answers come back in a order
from the records that meet your instructions.
Form - ANSWER an interface through which you can put in or change record
data.
Report - ANSWER A document printed that shows information nicely
formated from a database
Speed at which Access accesses - ANSWER the length of time it takes for the
storage device to present the content of the file for use
Compact and Repair Database Utility - ANSWER compacts and reduces the
size of a database and removes wasted space.
Datasheet view - ANSWER is a grid of columns and rows in which you will
add, edit, and delete records for a database table
Design view - ANSWER shows the structure of a table, form, or report
without showing the data
Database - 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 - ANSWER a computer application, such as
Microsoft Access, that is used to store data and convert it into information
Relational database management system - 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 - ANSWER data contained in a single page or sheet
Field - ANSWER a basic entity, data element, or category, such as a book title
or telephone number
Column - ANSWER the data field that you assign to group data vertically into
columns. Example: First name, last name, address, and phone number
Record - 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 - ANSWER the source field that you assign to group data horizontally in
a crosstab query
Table - ANSWER a collection of records
, Primary key - ANSWER the field that makes each record in a table unique; ex.
Student ID number
Foreign key - ANSWER a field in one table that also is stored in a different
table as a primary key
Question - ANSWER A database object through which you can ask questions
about data in a database, and get answers. The answers come back in a order
from the records that meet your instructions.
Form - ANSWER an interface through which you can put in or change record
data.
Report - ANSWER A document printed that shows information nicely
formated from a database
Speed at which Access accesses - ANSWER the length of time it takes for the
storage device to present the content of the file for use
Compact and Repair Database Utility - ANSWER compacts and reduces the
size of a database and removes wasted space.
Datasheet view - ANSWER is a grid of columns and rows in which you will
add, edit, and delete records for a database table
Design view - ANSWER shows the structure of a table, form, or report
without showing the data
