Automatic Annual Leave

Hi I am quite new to Access but I am desperate to learn as much as I can as
fast as I can.

I am currently working on automating an annual leave process at work & am
struggling & need help.

My problem is that I want the user to complete a form selecting the date(s) &
time(s) of leave they require. The leave pot is in half hour slots for e.g.
8:00 - 8:30 & so on. There would be a % of leave given on each half hour
which is calculated against a staff in post figure.

Once the user submits the form the db would automatically check the slots for
each half hourly slot for the time they requested off & return an immediate
response.

I hope somebody can help me with this problem & it would be much appreciated.

Thanks in advance