Information System based in Access for a Small Bussiness

[Jose Fernandez]

Dear Friends,

A friend of mine have asked me a favor, he has started a new small bussines
to rent equipment, he wish to control the inventory and to issue renting
orders from the clients, but it is required to avoid the multiple booking of
the rented equipment, I was thinking to generate a "Orders Control" with the
standard databases generated by MS Access and do some programming
modifications in order to avoid the multiple booking. Does anyone know about
where to find an example of such database or Information system in
Internet?, it is highly desirable if that is freeware, my friend does no
have enough finantial resources to afford it.

Thanks and best regards

[Pieter Linden]

"Jose Fernandez" <jf********@bellsouth.net> wrote in message news:<yN***************@bignews3.bellsouth.net>...

Dear Friends,

A friend of mine have asked me a favor, he has started a new small bussines
to rent equipment, he wish to control the inventory and to issue renting
orders from the clients, but it is required to avoid the multiple booking of
the rented equipment, I was thinking to generate a "Orders Control" with the
standard databases generated by MS Access and do some programming
modifications in order to avoid the multiple booking. Does anyone know about
where to find an example of such database or Information system in
Internet?, it is highly desirable if that is freeware, my friend does no
have enough finantial resources to afford it.

Thanks and best regards

The first place I would look for an answer to this might be Access
Cookbook, by Ken Getz. He *might* cover this, since it's a fairly
standard scenario. Albert Kallal has written a bunch of these
databases, so he might give you some pointers. Unless you're
reasonably good at Access and VB, I think this exercise is going to be
difficult. I did one a few years ago, and for the uninitiated, it's
quite a challenge. You can create a table of time slots, but it's an
UGLY design. that means you have to write queries/code to find
conflicts etc, I think. Again, as I said, look around for Albert's
posts on the subject. Otherwise, you're in for a lot of
frustration...

HTH,
Pieter

[Danny J. Lesandrini]

Good suggestions, Pieter. Another company that specializes in this kind
of product is a place I used to work for. I upsized their database from
Access to SQL Server, but their Access based product is really good.

Dean Evans & Associates in Denver CO
http://www.dea.com/

Their product focuses on allocating room resources, but it might work
for equipment, and it definitely addresses the double-booking issue.
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"Pieter Linden" <pi********@hotmail.com> wrote in message news:bf**************************@posting.google.c om...

"Jose Fernandez" <jf********@bellsouth.net> wrote in message news:<yN***************@bignews3.bellsouth.net>...

Dear Friends,

A friend of mine have asked me a favor, he has started a new small bussines
to rent equipment, he wish to control the inventory and to issue renting
orders from the clients, but it is required to avoid the multiple booking of
the rented equipment, I was thinking to generate a "Orders Control" with the
standard databases generated by MS Access and do some programming
modifications in order to avoid the multiple booking. Does anyone know about
where to find an example of such database or Information system in
Internet?, it is highly desirable if that is freeware, my friend does no
have enough finantial resources to afford it.

Thanks and best regards

The first place I would look for an answer to this might be Access
Cookbook, by Ken Getz. He *might* cover this, since it's a fairly
standard scenario. Albert Kallal has written a bunch of these
databases, so he might give you some pointers. Unless you're
reasonably good at Access and VB, I think this exercise is going to be
difficult. I did one a few years ago, and for the uninitiated, it's
quite a challenge. You can create a table of time slots, but it's an
UGLY design. that means you have to write queries/code to find
conflicts etc, I think. Again, as I said, look around for Albert's
posts on the subject. Otherwise, you're in for a lot of
frustration...

HTH,
Pieter