Hi Steve,
You're not hearing (or heeding) the good advice you have already
received. Believe it or not, we would like you to succeed with your
use of Access to solve your business problems. We will not knowingly
help you shoot yourself and your boss in the foot or feet.
Your last post indicates that you haven't completed your analysis or
possibly don't know what it means or possibly think you know your
prospective application so well that you don't need to express it
before beginning your design. To wit: you have already proposed a
design based on incomplete and incorrect analysis. Proceeding in that
manner will lead to producing yet one more "laughable" application
that will be difficult and expensive to enhance and extend.
By the way, any application that finds some use has a value so don't
worry about past efforts. The problem with so many amateur Excel
based applications is that they are not highly automated and they are
not user friendly at all. They depend on the user being the most
critical part of the "program". The user is expected to know where to
go to replace data, enter new data and to interact in other ways with
what's there. Excel can be used to produce some pretty slick
professional applications (if I do say so myself!). The biggest
single problem people experience in coming to Access from managing
data in Excel is that they believe Access is simply a quirky version
of Excel. 'Taint so! Excel is flat. Access is Relational. Excel
is essentially a calculating platform. Access (en toto) is a
Relational Database Management System (RDBMS). Actually, Access is a
whole bunch of development tools that assume a RDBMS will be a part of
the mix.
In a "good" Access application you will not allow your users to see or
interact with the tables directly. You will provide meaningful forms
for your users to complete their tasks (in other words, all tasks have
to be defined and then you have to provide the forms and means to
complete them. No other tasks will be allowed!). To the extent
possible you analyze the proposed application and create a
specification before any code is written. When the specification is
complete, that becomes the "contract" for the application; all
epiphanies and bright ideas encountered before completion will be
noted for latter address. Deliver the contracted application and get
it signed off. If the will is there, peruse the new ideas with the
client for a new release. I would ask the client to use it and take
not of any more new ideas for inclusion in that second phase.
For a journeyman Access developer your proposed application seems to
be fairly small and relatively uncomplicated. If you and your boss
are ready, willing and able to fully specify the result you want and
the inputs available (with assistance from a developer) the technical
aspects of the whole thing could take a week or less. It could take
as long as a month if people are slow to respond with requested
documentation or to get to the phone. If you're in the least bit of a
hurry that's the way I'd recommend. Insist that the developer
document the code so that you can learn from how your Access
application was built.
Whether you do it yourself of have it done, you'll still want to learn
more about Access. There is a list of resources below that can help
you if you will use them and apply yourself. Start with the things
that seem easiest to learn and go on from there. If you were to
consume all of the items on the whole list you would be an Access guru
of awesome stature.
A couple of newsgroups I always recommend for Access newbies are:
microsoft.public.gettingstarted
microsoft.public.tablesdesign
A list of priceless Access resources I cribbed from the frequent posts
of John Vinson is below
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
The Access Web resources page:
http://www.mvps.org/access/resources/index.html
Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/
A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html
A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal
MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
HTH