Field, a single piece of information found in a database e.g. first name, date of birth. Each field will have assigned a data type e.g. text, number, Record, a collection of related fields about someone or something e.g. each student in a school will have their personal details stored as one record, Table, a collection of records on a particular topic e.g. subjects offered in school, Sorting, rearranging records in a database table in a predefined order e.g. by surname, Design View, option used to create the table/field/data type template which will then allow the records to be entered, Query Design, rather than writing SQL statements, in Business Studies we use the Query Design option in Access to create the code for us by defining criteria, Search Terms and Operators, used to be more selective as to the records which we want to appear e.g. AND, OR, NOT, BETWEEN, < and >, Datasheet View, the template used to enter (populate), edit and delete records in a database.

Database Key Terms

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

)
Continue editing: ?