Find Jobs
Hire Freelancers

ACCESS 2000 AND VBA

$30-50 USD

已完成
已发布超过 21 年前

$30-50 USD

货到付款
and your application will be assessed for how much of the specification you have implemented (the functionality) and how well you have used the features of Access 2000 and VBA to provide a robust, well designed, easy to use (ie generally professional) application. The supporting essay will be designed for you to demonstrate how well you understand and can describe the concepts covered in the module such as · key features of Access 2000 and VBA · the way VBA relates to other programming languages as a visual programming language and as a language using Object Oriented concepts · developing Visual applications and using 4GL's · what is expected from a modern programming development environment (IDE) · component based development · multi-tier architectures and will require you to reflect on these and illustrate with examples from your individual work in the application. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. The supporting essay will consist of an essay and a technical report/recommendation. You are to write an essay (suggested length, excluding sample code, screen clips etc, of 5 to 10 pages of word processed text) reflecting on the facilities Access provides for developing applications giving examples from your experience developing the coursework application (this is very important, just paraphrasing the notes will not get marks; you must illustrate your points from your experience). Your essay should cover · how fully Access provides the functionality you need to develop applications · how easy to use and helpful the Access 2000 IDE is. This includes features of the IDE in developing Forms and Reports, of the VBA IDE in developing and debugging code and of the VBA language. · how the object approach of Access helps in developing software and whether the differences between 'pure' OO such as in C++ and Access/VBA are a help or a hindrance · how the productivity and the range of tools affect the way you went about developing the application (including any 'methodology' or life cycle related issues) You should also write a short technical report (target 3 maximum 5 pages of word processed text) to The Holloway Rapid Supply Company Management. The report should summarise the advantages of Microsoft .NET technology and indicate how it could be applied to systems in HRSC. The work consists of developing a small application using Access 2000. The system is to support the following functions:- 1. Allow the user to enter a customer's name or custno and the system will show his\her name and address, credit limit and the Location and Address of the Depot delivering to that customer. 2. Allow the user to enter a customer's name or custno and the system will show his\her name and address, and the Order Number, Date_Placed, Date_Delivered and total value (ie the total of the order line quantities times the product prices) of all orders for that customer in reverse date order (ie the latest first). 3. Allow all users to change their own passwords (on SystemUser). The only exceptions to this users whose user_type is Manager who can add, delete or update all rows on SystemUser. 4. Allow a user to supply the name of a product and the system will produce a list of all customers who have ordered the product in the last month (ie Corder.Date_Placed is >= the current date - 31 days). 5. List which Customers (by name) who have placed no orders in the last 365 days. 6. Allow a user to supply the name of a product and the system lists the names of the customers who have ordered that product most recently, ie find the date of the latest order(s) for that product and list all customers who have ordered that product on that date. 7. Produce a list of all suppliers with the depots they supply to and each product they supply to that depot with, for each product, a list of the depots with the product in stock and the quantity held. 8. Produce a list of all undelivered orders outstanding for at least 10 days (ie orders with date_placed <= current date - 10 and date_delivered null) in decreasing order of the length outstanding ie with the longest outstanding order first. 9. Sometimes outstanding orders get forgotten. This function should produce a list of all orders where the date placed is more than a year ago (ie date placed is < current date - 365 days) and the date delivered is null. It should then delete thes orders (both the Corder row and the Oline rows for the orders). ONCE BID ACCEPTED I WILL INCLUE THE FULL SPECIFICATION ## Platform ACCESS 200 AND VBA
项目 ID: 2885011

关于此项目

4提案
远程项目
活跃21 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
See private message.
$29.75 USD 在14天之内
5.0 (18条评论)
2.4
2.4
4威客以平均价$37 USD来参与此工作竞价
用户头像
See private message.
$41.65 USD 在14天之内
4.9 (33条评论)
5.4
5.4
用户头像
See private message.
$34 USD 在14天之内
5.0 (79条评论)
5.2
5.2
用户头像
See private message.
$42.50 USD 在14天之内
4.5 (24条评论)
4.0
4.0

关于客户

UNITED KINGDOM的国旗
london, United Kingdom
4.0
11
会员自9月 3, 2007起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。