MS Access Vocabulary PT 1

Collections of objects which work together to store, retrieve, display and summarize information and various tasks

• Databases

• Table

• Field

• Record

Collection of fields and records which store data

• Databases

• Table

• Field

• Record

Single piece of information related to the item it describes; categories the details of each record

• Databases

• Table

• Field

• Record

Complete sets of data about a specific item; made up of fields

• Databases

• Table

• Field

• Record

Character which indicates one or more unspecified characters

• Query

• Form

• Report

• Wildcard

Question asked about the data stored in a database which specifies how records should be sorted, filtered, calculated or shown

• Query

• Form

• Report

• Wildcard

Database object which can be used to enter, edit or display data from a table or query

• Query

• Form

• Report

• Wildcard

Formatted printout or screen display of the contents of one or more tables or queries in a database

• Query

• Form

• Report

• Wildcard

Database which contains or can contain multiple tables with relationships between them

• Relational Database

• Primary Key

• Parent Table

• Child Table

Unique field which can be used to identify a record

• Relational Database

• Primary Key

• Parent Table

• Child Table