Access Database - Invoice Tracking

Closed Posted Jan 1, 2011 Paid on delivery
Closed Paid on delivery

We are small radio/video clipping company looking for a MS Access developer to create a database for

[url removed, login to view] contacts

2. Media inventory

3. Invoice Creation

4. Invoice Tracking

5. Generating reports for analysis & pro-active selling.

Have attached a sample of the list above here for reference.

Customer Contacts are in 2 categories:

1. Agency

2. Direct Client

For Agency, they request the video clips on behalf of their clients so we would like to track who their clients are.

Also we would like to track which of their staff is managing the specific client account. The same staff could be managing a few client accounts & each client could have more than 1 staff attached to it.

For direct client, its just them.

Media Inventory, 2 types:

1. Regular

2. Custom

Regular recordings are in the media inventory list. The actual clip length is variable depending on the request.

Custom is upon request & will not be in the list, the details to be filled in on a adhoc basis

Each clip when requested based on the clip length, media & program will have a corresponding Ad Value.

Invoice Creation Form:

Four types:

1. One Time

2. By Agency by Month

3. By Agency by Client by Month

4. By Direct Client by Month

Have attached a sample of our invoice here with the information.

For Agency:

Invoice No. Autogenerate from PR Agency, PR Agency Client & Running No.

For Direct Client:

Invoice No. Autogenerate from Company & Running No.

Invoice Tracking:

Track paid & unpaid invoices by date range

Reports:

Types in attached excel file

As this the first time we are designing a access database, any advice or suggestion given will be appreciated.

Can use this access template as a starting point:

[url removed, login to view]

Thanks.

Microsoft Access Visual Basic

Project ID: #899358

About the project

41 proposals Remote project Active Feb 5, 2011

41 freelancers are bidding on average $176 for this job

kulhanekd

I would like to bid.. Donna

$150 SGD in 5 days
(30 Reviews)
5.7
winghei

Hi, I am an professional developer and a CPA

$150 SGD in 10 days
(28 Reviews)
5.3
eperfections

Please check your INBOX.

$120 SGD in 5 days
(28 Reviews)
4.9
ExactSystems

I have better solution for you .Please see detail on PMB. regards

$238 SGD in 15 days
(5 Reviews)
4.7
frehmanpk

Respected Sir, Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Looking forward to your prompt reply. Kindest regards.

$250 SGD in 10 days
(15 Reviews)
4.4
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

$155 SGD in 7 days
(12 Reviews)
4.3
SmartGuru

Hello, I have checked the documents that you have uploaded. I will be glad to provide you a solution using VB.Net 4.0 and MS Access as backend. Please check PMB for further details. Thanks and happy new year!

$215 SGD in 15 days
(11 Reviews)
4.3
piyushdpatel

Hi This is Piyush Patel I have 6 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$150 SGD in 5 days
(11 Reviews)
4.1
davidt999

Hi! I can do this for you. Please see PMB for a sample of my work. Thanks! David

$250 SGD in 7 days
(3 Reviews)
3.6
itcan

I am a professional MS Access Developer with more than 10 years experience. Please see your PMB for details of bid.

$230 SGD in 10 days
(2 Reviews)
3.3
finsoft03

Please check PMB.

$200 SGD in 21 days
(4 Reviews)
3.1
irajghazanfar

Please see PM for details.

$100 SGD in 7 days
(3 Reviews)
3.3
PerfectSquare

please see the PM

$180 SGD in 2 days
(11 Reviews)
3.1
techexpt

Ready to start now.Thanks.

$150 SGD in 7 days
(2 Reviews)
2.7
esalem

Hello, I can develop a solution for you in MS Access.

$190 SGD in 10 days
(2 Reviews)
2.5
astrolog

Please check my CV. I will be very happy to do the work;

$250 SGD in 10 days
(1 Review)
1.4
freelancerbuzzo

Ready to start right now.

$250 SGD in 10 days
(2 Reviews)
1.2
harrisrashid

I would like to work for you. No matter what database you prefer. I can do work in EXCEL, Microsoft SQL, MySQL, ORACLE. Similarly application can be made as web application or desktop application in any language (.NET, More

$75 SGD in 10 days
(1 Review)
1.0
albariconsulting

please check PMB for details

$450 SGD in 30 days
(1 Review)
1.0
SoftSandila

hi i can provide u with such an application in MSaccess, thanx, adnan

$500 SGD in 20 days
(0 Reviews)
0.0