Find Jobs
Hire Freelancers

Access 2010 Database - Clinet / Booking/ Billing

$750-1500 USD

进行中
已发布超过 12 年前

$750-1500 USD

货到付款
The purpose of the database is to assist in an animal day care facility with Client/Animal information, booking and billing. 1. Record Client & Animal information. A single client to one or many animal relationship will exist. Accessc 2010 Tbls and Forms for these have already been “draft” created as such can be used as a guide. 2. Calendar booking form/ system to record bookings. Booking will be on a full day or half day duration. Booking will be made in the "animal" name and a "charge" should be assigned to the Client. Note: Maximum number of animals per day booking is in place but this should have the potential to be easily changed. As such once the daily limit is reached a warning should be given and no further bookings be allowed for that day. An example of the type of calendar view preferred can be supplied. 3. Billing - Clients will pay either upfront and purchase "bulk" passes or single day pass . Pass charges will vary and individual Pass charges apply depending on the type of pass purchased. E.g. Discount for new client for first 20 purchased then the rate varies upon the number purchased. As such bookings made in Animal name need to be charged backed to Client and these charges taken off the running “pass” credit they hold. 4. Staff rota linked to the days booking. A certain staff to animal ratio will exist as such dependent on the number of bookings for a day. Again the ratio may change so this should be easily amended. Staff rota should be booked at hourly intervals and as such a staff cost / billing report option would be required. 5. Queries / Reports required: 1. Client Information 2. Animal information 3. Booking – Option to report on overall booking from Day to Day / Month or just a specified from to period timeframe, or based on Client or Animal name over specified From / To period. 4. Client Billing – Option to report by Client “Pass” total as of specified date. “Pass” level within a specified from / to range (to allow follow up call to purchase more), Pass total no longer in credit. Reports should be able to run on Booking in system as of the date specified or to include all bookings even if in the future. 5. Staff – Report to produce the staff rota for a given specified From / to period. Plus Staff costs based on hours worked. All reports should be printable. 6. I want the interface of the database to be simple, so anyone can easily Add/Update Client /Animal information. Make a booking and record pass credits and allocate these against bookings to provide statements to clients. If the database could be set up with User id / Password controls with a potential for 2 levels of access. Client & Booking and Client, Booking and Staff. This started out as an offer to create a simple Client/ Animal db to record information which at the time I said I would try and do myself. The requirements are now a little beyond the scope of my knowledge as such require the assistance of a more experienced Access developer. I have no idea if what I am after is possible and how complex or time consuming this would be. I would welcome feedback on not only if you are willing to take on the project but if you could comment on timescales and complexity as if only certain items can be achieved within budget so be it. Full details and copies of the Access tables and Forms that I have created are available. The budget is tight as I want to present this database as a gift to my friend as such the db will be as good as I can be achieved with the money available.I am more than happy to have a working db created if such things as input forms and reports etc are basic layout as I should be able to take it back and work on those things myself. In essence I am stuck on the booking / Billing/Invoicing side of things. I am willing to wait 4 weeks for completion. And looking for the db to be in created in Microsoft access2010 Many Thanks
项目 ID: 1122799

关于此项目

13提案
远程项目
活跃13 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi! Happy to help you with this. Please check PM.
$1,150 USD 在25天之内
4.9 (6条评论)
4.2
4.2
13威客以平均价$1,188 USD来参与此工作竞价
用户头像
Please check private message!
$2,000 USD 在20天之内
4.9 (175条评论)
6.7
6.7
用户头像
HI, I m a system analyst and software designer. I m very skillful with MS Access. Plz check my profile. I m sending some demos for my work in Access. I can also work using VB.net as front-end and Access DB as back-end for the same cost. Regards, Hussien Sharaf
$1,400 USD 在5天之内
5.0 (28条评论)
6.5
6.5
用户头像
Advanced MS Access developer here. Please have a glance at my profile.
$1,500 USD 在20天之内
4.9 (40条评论)
6.5
6.5
用户头像
Expert VBA & SQL developer here...
$1,400 USD 在21天之内
4.9 (27条评论)
5.9
5.9
用户头像
Thank you.
$1,450 USD 在10天之内
5.0 (45条评论)
5.5
5.5
用户头像
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. Please see attached sample application that how much user friendly application development capability I have. Looking forward to your prompt reply. Kindest regards. Farrukh Rehman.
$750 USD 在10天之内
4.8 (16条评论)
4.6
4.6
用户头像
Please check PMB
$750 USD 在15天之内
3.0 (2条评论)
3.0
3.0
用户头像
Hello sir, I have more than 10 years working with databases in Access (and other software), implementing solutions in different industry segments, and I am completely capable of delivering described solution. Holder of MS Office Master certificate and ECDL Expert. Please check PM.
$999 USD 在25天之内
5.0 (1条评论)
2.2
2.2
用户头像
Please Check PM.
$1,200 USD 在45天之内
0.0 (0条评论)
0.0
0.0
用户头像
Sir, Plz see your pmb for more detail.
$750 USD 在20天之内
0.0 (0条评论)
0.0
0.0
用户头像
{{Let's Start, Sir}}}
$750 USD 在15天之内
0.0 (0条评论)
1.0
1.0
用户头像
I can get this done in a particular time frame
$800 USD 在20天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED KINGDOM的国旗
Bridge of Allan, United Kingdom
0.0
0
会员自7月 7, 2011起

客户认证

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