Designing a Database

Designing a Database

The Database Objects

• Table a collection of stored data that is organize into fields. It consists of organized data into column and rows.

Record – a row represents a set of information.

Field – a column represents a specific of information.

• Query it filters a database to change, view, and analyze records in different ways to meet specific criteria used to retrieve a specific group of record from a table.

Dynaset is the resulted output.

• Form it is where you can enter a new record, study existing data, view data from a table or a query, or simply print information or any combination of these tasks.

• Report it is a carefully organized presentation of data from a table of query. It can show group of data with subtotals and totals from a summary of information from a table or query. One can print the data in acceptable manner, which is easier to read using report, but you cannot edit data in it.