Access database for querying invoices

已关闭 已发布的 Nov 3, 2005 货到付款
已关闭 货到付款

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

工程 微软Access MySQL PHP 软件构架 软件测试

项目ID: #3071843

关于项目

14个方案 远程项目 活跃的Nov 12, 2005

有14名威客正在参与此工作的竞标,均价$88/小时

pShankar2

See private message.

$42.5 USD 在14天内
(409条评论)
7.1
Premshanks

See private message.

$38.25 USD 在14天内
(350条评论)
6.5
GeluExvW

See private message.

$63.75 USD 在14天内
(151条评论)
6.3
ebshightechvw

See private message.

$38.25 USD 在14天内
(81条评论)
5.4
siluvw

See private message.

$25.5 USD 在14天内
(108条评论)
4.7
gromilink

See private message.

$85 USD 在14天内
(17条评论)
4.5
hawkswayvw

See private message.

$318.75 USD 在14天内
(12条评论)
4.5
jacsoftvw

See private message.

$85 USD 在14天内
(6条评论)
4.4
denasvw

See private message.

$21.25 USD 在14天内
(83条评论)
4.3
carteblancc

See private message.

$25.5 USD 在14天内
(3条评论)
3.1
technodeb

See private message.

$306 USD 在14天内
(4条评论)
2.9
ProSoftSystems

See private message.

$17 USD 在14天内
(12条评论)
2.6
rjnkvw

See private message.

$42.5 USD 在14天内
(3条评论)
1.3
thesoftcoder

See private message.

$85 USD 在14天内
(0条评论)
0.0
adkumar

See private message.

$25.5 USD 在14天内
(0条评论)
0.0
maheepgupta

See private message.

$85 USD 在14天内
(0条评论)
0.0