creating an update database for a loyalty points scheme

[Dirk2512]

hi i want to create a loyalty points scheme though a database,
general rulse apply 1 point per £1,

when the customer spens some money the staff then go to the machine and input the relevent data.

then a statment will be printed out for that customer with the points to date, and thier purchase the amount of point collect with the new total.

To search the full name and postcode would be adiquit as the printed statment could be lost and so could the customer id get confused by the customer.

for the report the layout would look like this:
eg

customer ID
cathy smith
e-mail,
address,
postal code,

02/12/2007 points to date 200
05/01/2008 puchase made £30.00
05/01/2008 new points total 230

if they use points it would look like

02/12/2007 points to date 200
05/01/2008 puchase made £30.00
05/01/2008 points use 125
05/01/2008new points total 100

point can be enterd manually and removed manually as customers want to save like a saving scheme

please help me with is as i have no idea where to start and if it posible, and limited knoledge of access

thanks in advance

 

[pbaldy]

I see two tables: one for customer data and the other for transactions. A case could be made for two transaction tables, one for points earned and the other for points used, but I'd go with one, with positive and negative transactions for earned/used.

 

[Dirk2512]

thanks pbaldy, im now a little closer, at the risk of sounding cheeky, as i said in the thread start my knowledge is limited, and i have no idea how to start this off, could you or some one please create the scripting and reports for me as i would me most thank full,

thanks in advance

 

[pbaldy]

I think you'll find many people here that will help you over the hurdles as you create the application. Not many will do the whole project for you. Generally, you start with proper table design, then create forms to enter/maintain data, then reports to pull the data out.

 

[Dirk2512]

ok thanks for the advice anyway

if i get stuck i will ask for help