How to setup booking and billing learner drivers using Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to setup a daily booking sheet for learners, create a
rolling bill for each learner and add notes. Any ideas?
 
Well... here's a "starter for 10"

You'll need a table to hold your leaners:

LearnersTable
==========
LearnerId
Name
Address1
....
....
Notes

A table to hold bookings

BookingsTable
==========
BookingId
LearnerId (to link to the correct learner)
BookingDate
BookingTime
Duration
....
....
Notes

You'll need somewhere to hold the charges you make. Either in the
LearnersTable if you may charge different learners different fees, or maybe
in a 'SystemValues' table if it's the same charge for everyone.
You could have a Notes field against each learner and against each booking
9as shown). Or if you wanted to have lots of notes against them, maybe a
notes table:

NotesTable
========

NoteId
LearnerId
BookingId
NoteText

Cheers,

Chris.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Planning a table to avoid adding fields 15
appending a Learner and Aims set of records to a txt file 4
Function needed to search and pull data from 1 table to another 4
MDB (Access 2002-2003) file format in Access 2007 17
Mark calculations 1
Moving Access Database to Sharepoint 4
generate list of non-entries within dates 3
Relationships 2

Back
Top