In Progress

Access Database for Tennis Coaching Business

I need an access database designed which will store customer (tennis student) details (So name, address, dob, phone numbers, email, type of lesson, coach name, day of lesson, etc), provide invoicing via email and keep track of payments made.

I do not want to have to create each invoice individually, it should be created based on the type of lesson and the number of weeks in the term. The invoice will refer to any outstanding balances from previous terms.

MS Access Database for Tennis Coaching Business


Background: I run a small tennis coaching business. I need a database which will handle email invoicing, customer payment details and customer information. The year is divided into 4 terms with an invoice being sent to every student at the start of each term. The invoice amount varies depending on the type of lesson and how many weeks in that particular term (can vary from day to day if there are public holidays).

Requirements:

• Store personal details relating of students (phone, address, dob, email, etc)
• Store details of their current class (type, day, time and coach) as well as classes for previous terms.
• Record personal details of coaching staff (name, phone, email, etc).
• Produce and email invoices (which can be sent as a batch… not having to click send for each invoice)
• Record amount and type of payment (cash, direct deposit, cheque) as well as total account balance
• Be able to send invoices for outstanding account balances (again, sent as a batch)
• Capacity to specify discount on any individual invoice

Desirable:
• The commercial product I used previously had the capacity to send sms messages to students (I could specify “all students”, “students with lessons on a Monday”, etc. This was done through smsglobal with whom I have an account. (http://www.smsglobal.com/en-au/technology/developers.php) . It would be good to have this capability.
• Same concept as above but with email messages instead. (Say if I want to send a reminder about the start of a new term to all students).

Skills: Microsoft Access

See more: database tennis, tennis coach database, tennis access database, coaching details database, access tennis database, create database tennis, tennis coaching business, tennis coaching business access, database access tennis, access database tennis, access tennis coach, microsoft email for business, i need an access database, name tennis coaching business, tennis coaching, tennis coaching invoice, tennis coaching database, tennis database access, coaching business, student database, microsoft access for business, Business coach, access microsoft, access database, customer details database

About the Employer:
( 1 review ) Baulkham Hills, Australia

Project ID: #1096787

Awarded to:

jhaynes75

Professional software developer with over 11 years experience. Please see PM.

$125 USD in 3 days
(29 Reviews)
6.1

41 freelancers are bidding on average $170 for this job

rhomeu

Advanced MS Access developer here. Please check private message box.

$250 USD in 10 days
(38 Reviews)
6.5
kulhanekd

15 years experiance in access. I can do this for you. DOnna

$150 USD in 10 days
(29 Reviews)
5.7
amnmttl

PLease check PMB for BID Details

$125 USD in 7 days
(15 Reviews)
4.3
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]

$180 USD in 15 days
(3 Reviews)
4.1
eperfections

Hi, I have all the required expertise and I can develop this database. Regards ePerfections

$150 USD in 5 days
(12 Reviews)
4.0
piyushdpatel

Hi This is Piyush Patel I have 6 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$150 USD in 2 days
(7 Reviews)
3.8
sinfulm3

Hello Sir, kindly check PMB for sample work.

$100 USD in 6 days
(6 Reviews)
3.6
PerfectSquare

please see the PM

$40 USD in 1 day
(10 Reviews)
3.1
gerrymwalsh

I have 12 Year access development experience, and have created similar billing databases before.

$190 USD in 5 days
(1 Review)
2.4
Vanshitakhatri

Request you to please check pmb

$225 USD in 10 days
(1 Review)
1.7
DamithaKD

HI. I am a programmer for 6 years. i can give you a db Program for this :) if you like me to work send me a pm :) Kaushalya Damitha

$120 USD in 5 days
(1 Review)
1.0
hitgon

DBA Profile

$30 USD in 1 day
(1 Review)
1.0
digitalscape

I can create your database of what you ask any connection with programs such as Microsoft Access, Sql, Mysql, Visual Basic forward to working with you

$31 USD in 12 days
(0 Reviews)
0.0
klamprakis

Dear Sir / Madam, I have studied computer science and I am working for more than 5 years as a business analyst. I believe I have the required skills in order to complete successfully this assignment in terms of More

$170 USD in 5 days
(0 Reviews)
0.0
mummum2000

must sent the liset of Reports that you want from the software.

$30 USD in 2 days
(0 Reviews)
0.0
sang20052000

please contact me

$60 USD in 1 day
(0 Reviews)
0.0
Haider2100

Dear Concern, I am vb6 and MS Access programmer. I have more than 10 years experience to development various type of desktop database application. So if you give me to do this job I will you complete it within a week More

$200 USD in 7 days
(0 Reviews)
0.0
JohnieB

I can make the database that you want

$30 USD in 14 days
(0 Reviews)
0.0
minato123

I can create your database of what you ask any connection with programs such as Microsoft Access, Sql, Mysql, Visual Basic forward to working with you

$33 USD in 11 days
(0 Reviews)
0.0
sandee1983

We are masters in the Access databse design and planing, developing. We have no. of prestigious clinets among various industries. Thanks Sandeep +91-8698373616

$30 USD in 10 days
(0 Reviews)
0.0