469,576 Members | 1,677 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,576 developers. It's quick & easy.

Information System based in Access for a Small Bussiness

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
Nov 12 '05 #1
2 1743
"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
Nov 12 '05 #2
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Scott | last post: by
2 posts views Thread by genc ymeri | last post: by
2 posts views Thread by Ian Oldbury | last post: by
2 posts views Thread by Stefke | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.