Closed

I need a Microsoft Access Develper

Build a database to analyze and report on tenant information based on multiple attributes, flexible time periods, and trend analysis.

What attributes should each tenant have:

Name

Sq ft

Start date/end date

Type of business- clothing, furniture, services, grocery, etc.

Expense amount (to calculate health ratio)-a field to enter in the tenant’s rent to LL- a fraction should be calculated from the rent divided annualized sales. (e.g. rent of $30,000 per year divided sales of $100,000 equals 30%)

Ability to enter break point to calculate % rent- field to enter a celling of sales. Once a tenant surpasses this annual amount, and calculation should be made based on a percentage over that ceiling. For example- ceiling is known as Breakpoint- $100,00. Annual tenant sales are $125,000. Percentage rent is 3%- calculation should be $125,000-$100,000= $25,000. $25,000 x 3% is $750.00

Ability to run reports by one or more parameters:

-different attributes e.g.- by tenant less than 5,000 sq ft

-rolling years

-comparing year over year

-calculate health ratios

-by use

-Trend analysis by date range for categories (size, business type, etc), by individual business, overall project

Skills: Microsoft Access, Database Programming, Database Development, SQL, Database Administration

About the Employer:
( 0 reviews ) Austin, United States

Project ID: #30404815

29 freelancers are bidding on average $2368 for this job

(310 Reviews)
7.9
(15 Reviews)
7.5
(178 Reviews)
7.4
(7 Reviews)
7.0
(16 Reviews)
6.8
(4 Reviews)
6.4
(18 Reviews)
6.4
(68 Reviews)
6.2
(39 Reviews)
6.4
(57 Reviews)
6.4
(18 Reviews)
5.9
(32 Reviews)
5.6
(19 Reviews)
5.2
(4 Reviews)
5.3
(4 Reviews)
5.6
(11 Reviews)
4.8
(3 Reviews)
4.6
(11 Reviews)
4.9
(14 Reviews)
4.4
(3 Reviews)
4.4