vehicle bookings

HI all, I am new to access and I am having trouble getting my head around the
design of a new data base for my work. As usual the bosses do not want to
fork out any money for a product that is on the market. I work for a company
that can have between 20 to 60 vehicles, some of the vehicles could be loan
vehicles from other contractor or hire vehicles. I am trying to make a
booking database where I can enter the date and time booking for a period
from 4 hours to days/ weeks. The main problem is trying to forecast when
additional vehicles are required so ultimatly I am trying to build a database
that I can enter the booking and in the event I do not have enough vehicles I
can suspend the booking until confirmation of additional vehicles. A the same
time the database will have to tell me if I am double booking a vehicle for
any period.

Q 1 is this posible with MS access

Q 2 Can anybody assist/ help

Q 3 Does anybody have a database that will preform this function,

Thankyou

.

Relevant Pages

  • Re: vehicle bookings
    ... design of a new data base for my work. ... ability to track more - more information about the vehicles, ... booking the vehicles, and other business logic that may need to be included ... booking database where I can enter the date and time booking for a period ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Find out if record exists in 2nd table
    ... I have corrected my typing and all seems to be working properly, but, now my ... fields on my booking in form, i have attempted to do it but appear to be ... What i want is to populate company,make & model from the vehicles table after ... Kevin did not use apostrophes everywhere The first set is ...
    (microsoft.public.access.formscoding)
  • Re: Find out if record exists in 2nd table
    ... If the vehicle exists in the vehicles tbl i want to automatically populate 3 ... fields on my booking in form, i have attempted to do it but appear to be ... What i want is to populate company,make & model from the vehicles table after ...
    (microsoft.public.access.formscoding)
  • Re: Find out if record exists in 2nd table
    ... previous to this discussion i was using the following booking form: ... Reg Number - text box field ... data from vehicles table ... What i want to do is automate the ...
    (microsoft.public.access.formscoding)
  • Re: Mail Merge with DB to create a table of related records
    ... Now that it is hooked up to each data source is it possible to set something ... "Peter Jamieson" wrote: ... the source for the DATABASE field. ... use that to insert the databse of vehicles /as a field/ you then have ...
    (microsoft.public.word.mailmerge.fields)