1

Data Base

A database is a collection of data that is organized so that it can easily be accessed, managed, and updated. The example

below is based on buildings, tenants, managers and lease information.

Table Organization

It is very important to have organized tables, being able to see all of the data is essential to completing a task. The need

to make the table image larger may be needed. Keeping the relationship and table order organized will assist in less

confusion as well.

As you can see there are many parts of a database.

Tables, queries, forms and reports.

There are a total of four tables in this database. They are

related in some ways and will be used in queries to filter

and organize information.

2

Database Multi-Page Form with sub form

Using sub forms can be beneficial in viewing information from multiple locations in one convenient location.

Queries

A query can assist you in filtering the data. Finding specific data that would be time consuming to look up yourself.

This query filters the data,

specifically the leases, by the

building code.

The sub form has been added to

view information all in one place.

This helps to obtain data faster.

3

This query filters the data by tenant name.

4

This query filters the data by the rent that is

$900.00 or more.

This query adds up the

total rent for each

building.

5

Database report Based on a query

A database report is the formatted result of database queries and contains useful data for decision-making and analysis.

I have developed a report to show the Tenants, rent and site

managers to determine which site manager. I have grouped the sites

and tenants, included a calculation for the rent, and have grouped by

the building code.