Setup and use databases (Microsoft Access)
DATABASE
A database is an object which holds processed & organized data (collection of logically related records of file.)E.g. A list of students names, addresses, in a school database, or A/C number, name, A/C type, balance in bank database etc…
The following diagram shows the structure of a database.
DATABASE --- A collection of Tables, Forms, Reports and Queries.
FILE --- A collection of records.
RECORD --- A row in a table.
FIELD --- A column in a table.
