Query, A search carried out in a Database, Table, Stores data on a topic in columns and rows, Field, A column in a table. Holding one type of information., Record, A row in a table. Holding all the information about one thing., Text Field, Used to store words or letters. e.g. name or address, Number Field, Stores numbers. e.g. price or score, Simple Query, Searching a database using one condition (e.g. all students aged 12)., Complex Query, Searching a database using more than one condition (e.g. students aged 12 and in Class 1W2)., Field Type, Tells the database what kind of data a field can store (e.g. text, number, or Boolean)., Database, An organised collection of data stored on a computer., Criteria, The rules used in a query to decide which data is shown., Sort, Arranges data in order, such as A–Z or smallest to biggest., Data Dictionary, A plan for a database showing the names of fields, data types, keys and validation, Data, Raw facts or figures that are collected, such as numbers, words, or dates. On its own, may not mean much., Information, Data that has been processed or organised so that it makes sense and is useful., Wildcard, A character used to substitute or more characters.

Database Terms

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

)
Continue editing: ?