By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,225 Members | 2,223 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,225 IT Pros & Developers. It's quick & easy.

Information System based in Access for a Small Bussiness

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
"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

P: n/a
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.