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,

S3 AIT Database Key Terms

bởi
Nhúng

Bảng xếp hạng

Phong cách trực quan

Tùy chọn

Chuyển đổi mẫu

Bạn có muốn khôi phục tự động lưu: không?