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