What is a database?

A database is collection of data organized to provide efficient retrieval.

A database is also a tool for collecting and organizing information. Databases can store information about people, products, orders, or anything else.

Common Database Terms

• File – A file is a stored collection of associated records.
• Record – All information (all fields/columns) for every item in a file is called a record (or each individual line).
• Field – A record is divided into separate headings/sections and each is known as a field – this could refer to each column/heading. There are different types of fields, including:
  • NUMERIC fields, which can be sorted in ascending or descending numeric order
  • CURRENCY and DATE/TIME fields
  • TEXT fields, which can contain numbers and text that do not need to be sorted, such as telephone numbers
• Data – Data is a collection of pieces of information.
• Database – A database is the organized collection of your data.
• Table – A table is a collection of data organized by categories called fields, into unique rows of data called records.
• Query – A query is a request you make of your data to extract only the information you want.
• Form – A form is a user-friendly interface used for entering or displaying data.
• Report – A report is a view of your data that shows the information you want. It may be in a different formant than the original data particularly if information as been grouped or subtotaled. You might create a report to print for a meeting.