Find Jobs
Hire Freelancers

I need a Microsoft Access Develper

$1500-3000 USD

Closed
Posted almost 3 years ago

$1500-3000 USD

Paid on delivery
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
Project ID: 30404815

About the project

28 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
Austin, United States
0.0
0
Payment method verified
Member since Apr 2, 2021

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.