Computer Terms

MICROSOFT ACCESS

This is relational database

It contains information about a collection of people, or objects

If we think of a database of students, we would say that each student’s complete details are that students database record.

Each record is broken up into fields
Such as
Surname Smith
First name Peter
Address 12 Collins place Croydon 3136
Phone 9724 3212
Etc
Each Field in a record has a specific datatype

A “Datatype” is the type of data that the field can hold such as text, number, currency or date.


Surname Field
Would be Text data type (Text is any keyboard character, including numeral 0 to 9)
Age Field would be Number data type

Amount Owing field would be Currency data type.

Date of Birth field would be Date data type.

Access has 4 structures within it

Tables:- These hold infor...