Access

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.