In Progress

photostudio data base

Computer application for the following two main tasks.

1. Organize customer Information in a database.

2. schedule customer appointments in different studios.

1. Organize customer Information in a database.

Data Base : Access, SQL or similar as multi user application

1. Main Data Base

Field Name Type Width Decimal Value

Market Area Character 2 0 GC, SC, RS

Booking_No Numeric 5 0 automatic, index

Cust_Status Character 9 0 Drop down menu

Cust_First_Name Character 16 0

Cust_Last_Name Character 16 0

Cust_Adress Character 25 0

Cust_Place Character 16 0

Cust_Zip Numeric 4 0

Cust_Phone Numeric 12 0

Cust_Mobil Numeric 12 0

Cust_email Numeric 25 0

No_Makeover Numeric 1 0

Marketer_Name Character 16 0 drop down menu

Marketer_Location Character 16 0

Marketer_Date Date 8 0

Date next call Date 8 0

Fee_Paid Numeric 6 2

Fee_Balance Numeric 6 2

Photographer_Name Character 16 0 drop down menu

Make_Up_Art__Name Character 16 0 drop down menu

Session_Date Date 8 0

Sales_Amount Numeric 8 2

Notes memo

Values with drop down menus:

Field status:

Sitting, booked, confirmed, attended, cancelled, rebooked, completed

- Evaluation of Data entry as screen print and printed lists

- Filter and query criteria to following single or combined Field names

- Market area (filter selection)

- Cust Status (Filter selection)

- Marketer Name (Filter selection)

- Marketer Loccation (Filter selection)

- Marketer Date ( Filter selection Date1 to date2 )

- Photographer Name (Filter selection)

- Make Up Art Name (Filter selection)

- Session Date ( Filter selection Date1 to date2 )

- Cust zip (Filter selection)

- Sum and average calculations over every numeric field within every filter selection

- Find data entry by cust last name, booking No,

- using email addresses for single or contact of customers or bulk mail – or dataimport from MS OUTLOOK

- Print out lists with summed and average numeric fields over defined time periode and filtered data field:

o Photographer Name / Sales amount

o Makeupart Name / Sales amount

o Marketer Name / Fee paid / fee balance

o Cust Status / cust First name / Cust last name / Marketer Date / Cust phone/ Cust mobil / date of next call / Notes

2. schedule customer appointments in different studios

Our company would consider to buy a license of an probably existing time schedule software module to customize with the Data Base and integrate in software!

- Daily, weekly and monthly overview with with each studio resource in one column side by side.

- Flexible time duration for every booking

- Different background colour for Status fiel booked, confirmed, no show, attended

- Booking field shows booking No, cust first name, cust last name and opens full data base record when mouse click

Taidot: C-ohjelmointi, tietojenkäsittely, Valokuvaus, Visual Basic, Windows Desktop

Näytä lisää: freelance photo studio database software, free photostudio customer database software, printed names, phone marketer, overview data entry, numeric art, marketer find, data entry application software, buy bulk email addresses, buy art, bulk mail lists, customer database softwear photo studio, photo studio project, photostudio database software, project photo studio, full data base, print menus, find art, data entry overview, call lists

Tietoa työnantajasta:
( 0 arvostelua ) Tewantin, Australia

Projektin tunnus: #25801