Suljettu

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

Taidot: Microsoft Access, Tietokantaohjelmointi, Tietokantakehitys, SQL, Tietokannan hallinto

Tietoa työnantajasta:
( 0 arvostelua ) Austin, United States

Projektin tunnus: #30404815

29 freelanceria on tarjonnut keskimäärin $2368 tähän työhön

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