Access Vocabulary

Name: ____________________________________ Period: _________________

Information Technology
Access (ACCDB) Vocabulary Sheet


Directions: Write the definitions for the Access (ACCDB) terms in the table below. Page numbers are listed for assistance. Make sure you UNDERSTAND the meanings of these words. These are definitions that you should know and understand for the final exam!

Term
Definition
Page #
Table (in Access)


A database stores data in one or more spreadsheet-like lists.



254
Simple database
A database containing just one table.
254
Relational database
One that contains two or more tables of related information.
254
Record
Each row in a table is called a…
254
Field
Is a user-friendly window that contains text boxes and labels that let users easily input data.
254
Field name
The column heading is called…
254
Form
Is a user-friendly window that contains text boxes and labels that let users easily input data.
254
Query
Extracts data from one or more database tables according to criteria that you set.
254
Report
Is a summary of information pulled from the databases, specifically designed for printing.
254
Primary key field
Uniquely identifies each record among all other records in a database
258
Sort
The records in a table in alphabetical or numerical order.
282
Encrypt
Access security feature that compacts and scrambles a database file so that it is difficult for unauthorized user to decipher.
See
Glossary