Access database for querying invoices

Closed Posted Nov 3, 2005 Paid on delivery
Closed Paid on delivery

Homework assignment

I have created an Access Database showing the orders for different projects within a company. There are three basic tables (Supplier, Order, Company Project).

Part 1

The information is imported into the spreadsheet from Excel. I want a function to automate this using a user interface. As a part of this any unmatched records need to be removed, i.e any suppliers with no orders, or projects with no suppliers (I think this is required to enforce referential integrity)

Part 2

I have created a number of reports which display the information I require. I wish to enable the user to decide how many records they wish to see using a input box. This is okay for the reports running off simple queries, however slightly more complicated for the reports running off complex queries.

I also wish to have the option to select in the input boxes the following info:

year, supplier or Sub-contractor, project, client

Thanks

Helen

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

4)The coder should create an interface for the database. The components of the interface shall include but not be limited to importing the data, viewing the reports, printing the reports.

5) If the system will not be payed for until it has been accepted by the buyer. Delivery of the system does not constitute acceptance. If there is a fault in the system the Seller will be responsible to remedy this fault as soon as possible and then the system will be re-tested. Once the system has passed all the acceptance testing the system will be accepted and payment made.

6) If after acceptance of the system there is an fault then the Seller is responsible for remedying that fault within a reasonable period of time.

## Platform

Windows XP

Engineering Microsoft Access MySQL PHP Software Architecture Software Testing

Project ID: #3071843

About the project

14 proposals Remote project Active Nov 12, 2005

14 freelancers are bidding on average $88 for this job

pShankar2

See private message.

$42.5 USD in 14 days
(409 Reviews)
7.1
Premshanks

See private message.

$38.25 USD in 14 days
(350 Reviews)
6.5
GeluExvW

See private message.

$63.75 USD in 14 days
(151 Reviews)
6.3
ebshightechvw

See private message.

$38.25 USD in 14 days
(81 Reviews)
5.4
siluvw

See private message.

$25.5 USD in 14 days
(108 Reviews)
4.7
gromilink

See private message.

$85 USD in 14 days
(17 Reviews)
4.5
hawkswayvw

See private message.

$318.75 USD in 14 days
(12 Reviews)
4.5
jacsoftvw

See private message.

$85 USD in 14 days
(6 Reviews)
4.4
denasvw

See private message.

$21.25 USD in 14 days
(83 Reviews)
4.3
carteblancc

See private message.

$25.5 USD in 14 days
(3 Reviews)
3.1
technodeb

See private message.

$306 USD in 14 days
(4 Reviews)
2.9
ProSoftSystems

See private message.

$17 USD in 14 days
(12 Reviews)
2.6
rjnkvw

See private message.

$42.5 USD in 14 days
(3 Reviews)
1.3
thesoftcoder

See private message.

$85 USD in 14 days
(0 Reviews)
0.0
adkumar

See private message.

$25.5 USD in 14 days
(0 Reviews)
0.0
maheepgupta

See private message.

$85 USD in 14 days
(0 Reviews)
0.0