Em Andamento

Access 2010 Database - Clinet / Booking/ Billing

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

Habilidades: Microsoft Access, PHP, Arquitetura de software

Ver mais: microsoft access client billing form, client billing access database, booking client billing, create access calendar booking database, client database billing, access billing database booking, what is time complexity in c, what is time complexity, time complexity in c, time complexity, system level architecture, stuck at work, staff care, software developer what they do, software developer on call, software developer make money, software developer by hours, scope of php developer, php intervals, php developer per day rate, php developer levels, out of scope requirements, microsoft access database developer, make money as software developer, looking for access developer

Acerca do Empregador:
( 0 comentários ) Bridge of Allan, United Kingdom

ID do Projeto: #1122799

Premiar a:

TCar

Hi! Happy to help you with this. Please check PM.

$1150 USD em 25 dias
(6 Avaliações)
4.2

13 freelancers estão ofertando em média $1188 para este trabalho

eperfections

Please check private message!

$2000 USD in 20 dias
(175 Comentários)
6.7
HussienSharaf

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-e Mais

$1400 USD in 5 dias
(28 Comentários)
6.5
rhomeu

Advanced MS Access developer here. Please have a glance at my profile.

$1500 USD in 20 dias
(40 Comentários)
6.5
syslogic

Expert VBA & SQL developer here...

$1400 USD in 21 dias
(27 Comentários)
5.9
ruimaxwell

Thank you.

$1450 USD in 10 dias
(45 Comentários)
5.5
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. Please see attached sample application that how much user friendly Mais

$750 USD in 10 dias
(16 Comentários)
4.6
braghunath

I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [url removed, login to view]

$1350 USD in 60 dias
(3 Comentários)
4.1
irajghazanfar

Please check PMB

$750 USD in 15 dias
(2 Comentários)
3.0
sdupor

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 Mais

$999 USD in 25 dias
(1 Comentário)
2.2
web2net

Please Check PM.

$1200 USD in 45 dias
(0 Comentários)
0.0
muhammadibaad

Sir, Plz see your pmb for more detail.

$750 USD in 20 dias
(0 Comentários)
0.0
krre

Dear Sir, We need to thank you to provide us opportunity to work with you. Commitment and Facilities we provide We have a team of dedicated and genuine IT Professionals that can offer you a complete arena of IT Mais

$1350 USD in 50 dias
(0 Comentários)
0.0
ActualCreative

{{Let's Start, Sir}}}

$750 USD in 15 dias
(0 Comentários)
1.0
Mzakapal

I can get this done in a particular time frame

$800 USD in 20 dias
(0 Comentários)
0.0