Database

table

A collection of data related to a specific topic

database

A database is a data structure that stores organized information. Most databases contain multiple tables, which may each include several different fields. A database is used to store large amounts of information for quick searching

Big Data

Data so large that it is difficult to store and process using traditional database software,

Difference between databases and spreadsheets

Spreadsheet crunches numbers. Databases sorts and locates common searches. Databases can be used simultaneously by many people

Query

The name of the search process in a database.

Field

a category of information found in the columns of a table; Example: Last name, First name, address, etc.

primary Key

a required field that makes each record unique (the "key" looking icon; shows which field name is your unique identifier in a table; assigned in design view)

relational Databases

are databases that consist of multiple tables of information that are related through common fields. It is a database that can work with data in two or more files at the same time

real world databases

example: Google; Firefox, internet explorer,e-commerce; HAC, are databases.

Data Type

text, number, date, or time; must be assigned to every field in a data table

Record

the rows of a database table, all of the information in the row represents the record

Datasheet View

the view in which each record is contained in a row and each field name is isted above each column

Design View

the view in which the structure of the table is displayed; data types are assigned here

Task Pane

vertical window to the right of the application window that contains many common startup tasks