Em Andamento

Softrware using Access 2002 Database

**Please see the attached Access database and also look at the relationships**

## Deliverables

**Please see the attached Access database and also look at the relationships**

I have an Access database and need some programming done on it - basically this database has tables for

**Main tables**

**Property**

This table contains details of each of the properties to be managed and I have a form for entering information to this table already in the database.

**Contracts**

This table contains each of the contracts. One property - see above can have many contracts against it. I need a form that allows me to create the contracts against these properties

The contracts can be for expense (that is the property owner pays a cost of per period against the property) or for income (that is the property owner is paid an income)

**Tenants**

Each contract can have one or more tenants against each contract. So I need a form that allows me to enter many tenants against each contract

** Supplier**

This contains the details of the suppliers and I need a form to allow me to enter and amend suppliers ??" a supplier can provide a bill which may for the 1 or more properties. The supplier is linked to the bills.

**

Bills**

This table contains a series of transactions per property. When a contract is created from new I need an option that creates bills for the contract. If a contract is for a period of 6 months and is billed monthly then 6 bills will be created in this table for this contract. The bills will be referenced

Unique Contract Number - Month Number Year - Bill Number

So for unique contract number 1234 that runs from June 2009 through to Jan 2010 bills with references

1234-0609-1

1234-0709-2

1234-0809-3

1234-0909-4

1234-1009-5

1234-1109-6

1234-1209-07

1234-0110-08

will be created by the system

**Enter Bill**

Bills can be entered for a supplier or a contract. If a bill is entered for a supplier then the entry routine must allow me to link the bill to one or many properties.

When a bill is linked to many properties the the bill will have a total amount - when this is linked to many properties each property it is linked to has a 'piece' of the total amount - as an example if a bill is for £123 it can be linked to 3 properties say where one property has £80 another has £25 and another has £18 total £123

This apportioning is handled by the entries in table **allocations**

**Transactions**

This table contains all the bank transactions ??" each bank transaction can be to pay off individual bills - one bank transactions can be allocated to one or more bills - so a bank transaction can be say £234 and this is then allocated to 4 bill transactions in amounts £80, £120, £30 and £4

Items stay unallocated until they are manually allocated- so I need a routine to allocate them to bills.

Habilidades: Engenharia, Microsoft, Microsoft Access, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Área de trabalho do Windows

Ver mais: programming in access database, programming contracts c, programming access database, june is the month for, i need an access database, for the month of june, expense items, contract bank, supplier contract, c programming contracts, bank transactions entered, create bank database using, access database transaction, using access, create table using, access linked table, system using access database, monthly database access, expense form, table linked access, contract database access, database programming using, access create database, access 2010 example database, create access database monthly

Acerca do Empregador:
( 82 comentários ) United Kingdom

ID do Projeto: #3039270

Premiar a:

LogixSmith

See private message.

$55.25 USD em 18 dias
(54 Avaliações)
6.0

9 freelancers are bidding on average $323 for this job

fastudiovw

See private message.

$408 USD in 18 dias
(734 Comentários)
7.5
Wonderer

See private message.

$850 USD in 18 dias
(82 Comentários)
6.1
templecityt

See private message.

$238 USD in 18 dias
(21 Comentários)
5.5
alnaba

See private message.

$323 USD in 18 dias
(28 Comentários)
5.0
alexitkin

See private message.

$93.5 USD in 18 dias
(32 Comentários)
4.7
gendolftsl

See private message.

$127.5 USD in 18 dias
(36 Comentários)
4.3
amdadhossainvw

See private message.

$127.5 USD in 18 dias
(3 Comentários)
0.2
ibiaso

See private message.

$680 USD in 18 dias
(1 Comentário)
0.7