Business & Technology Spring Final Exam Review

A group of fields, such as a telephone number, address, and name, which are pertinent to a particular item.

• record

• key

• form

• table

A connection between two tables using a common field; the ability to efficiently

combine data from related tables for the purpose of creating queries, forms, and reports.

• table

• network

• relationship

• key

A collection of data organized as meaningful information that can be accessed,

managed, stored, queried, sorted, and reported.

• table

• field

• database

• spreadsheet

The software that is used for creating desktop databases and learning about the general relational database theory.

• Microsoft Access

• Microsoft Excel

• Microsoft Notes

• Microsoft Outlook

An access interface that appears on the left side of the screen, and displays all objects; it organizes and list the objects in an access database

• design view

• database

• navigation pane

• table

A field (or combination of fields) that uniquely identifies each record in a table.

Examples: driver's license number, social security number, passport number, or student ID.

• database

• primary key

• form

• object

Where all data is stored in your database, and is known as the foundation of each database, organized data in columns and rows.

• table

• form

• query

• report

A database object that you can use to create a user interface for a database application; allows simplified entry and modification of data.

• table

• form

• query

• report

A request for data results from a database (usually from a table or more) or for action on the data.

• table

• form

• query

• report

A professional-looking formatted document from underlying tables or queries.

• table

• form

• query

• report