Re: Considering using Access

From: Joe Fallon (jfallon1_at_nospamtwcny.rr.com)
Date: 05/14/04 

Date: Thu, 13 May 2004 23:16:11 -0400

Ditto.
You should hire a Pro to do the work for you.
It will pay for itself many times over.
PLUS - you can have all the input into the design that you want and when it
is done you can teach yourself all about Access on a COPY of a working
application that you have a deep understanding of.

And I am not looking for work either so... 

-- 
Joe Fallon
Access MVP
"tina" <nospam@address.com> wrote in message
news:IGWoc.2347$hH.53613@bgtnsc04-news.ops.worldnet.att.net...
> hi Joe. sounds like database you're proposing will be "mission-critical".
> Access is an extremely powerful and versatile tool, and I have no doubt it
> can handle the tasks you describe, but...
>
> IMHO:  unless you have a solid grounding in a programming language (if not
> VBA, then another) and/or *previous experience in relational database
> design* and/or plenty of experience in using Access - you're setting
> yourself quite a task. if you try to "learn as you build", the time
> investment alone will be formidable for a busy company owner, never mind
the
> cost of fixing mistakes. because of the importance of the database to your
> company's operation, i would really suggest you hire a professional to do
> the job for you. (and no, i'm not trying to drum up work for myself. i'm
not
> good enough to take on a mission-critical project). if you don't hire
> someone initally to build the database, it's likely you'll have to hire
> someone later to fix it.
>
> hth
>
>
> "Joe Rivera" <latteralus@hotmail.com> wrote in message
> news:F801148E-28EA-4B26-82DB-0E4C7C3FE9BD@microsoft.com...
> > I own and operate a taxi company in CT and need to computerize my
> operation. A friend has suggested using access to store our accounts,
> reservations, print reports, etc. I am currently using Access 2000 and
have
> been studying it alot lately trying to figure whether or not my needs can
be
> met using Access.
> >
> > I have been plannning this all out ahead of time on paper so that I can
> look at what my needs are and will be in the future in an attempt to save
> myself some agrivation when or if I try to make this work.
> >
> > Basically what I am looking for is an application that can be networked
in
> small office, I have 2 phone operators, one dispatcher, I need the jobs
the
> operators are entering into a form to automatically update in the form the
> dispatcher is using, so that he will have up to date information. I will
> also need a variety of reports, including a "snapshot" report, showing
jobs
> in a specific time frame so that he can plan his day more efficiently.
This
> seems to be alot of work, but alot of work in not my problem...
> >
> > As of right now, it seems as though this can be done with Access, the
> problem I am having is when I try to determine how the customer records
> table will work. I am thinking each customer will be assigned a number,
> which will continuously grow (autonumber), however, my problem is that
> certain people use our service everyday, some only on Mondays, or Tuesday,
> etc. Would using a macro be the best way to accomplish that, or would an
> action query be more effective? Can I have either of those functions
> automatically insert the information desired by perimeters I set in the
> query and also change the date to the current date? Also... I need some
> advise as to how I should plan out my customer table, should each customer
> using the service have a identifying number? But how will I link alternate
> trips together, people going certain days, etc.
> >
> > I need help, any suggestions are much appreciated.
> >
> > Joe
>
>

Relevant Pages

  • Re: Considering using Access
    ... hi Joe. ... then another) and/or *previous experience in relational database ... seems to be alot of work, but alot of work in not my problem... ... I am thinking each customer will be assigned a number, ...
    (microsoft.public.access.tablesdbdesign)
  • Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
    ... UDQ Consulting Services Believes that Every Problem Should Have an Easy & ... templates, spreadsheet applications, and database applications. ... P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
    ... > UDQ Services has years of experience with MS Excel and VBA (Visual Basic ... > templates, spreadsheet applications, and database applications. ... > P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.worksheet.functions)
  • Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
    ... UDQ Consulting Services Believes that Every Problem Should Have an Easy & ... templates, spreadsheet applications, and database applications. ... P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.programming)
  • Spreadsheet/VBA Consulting - 50% Off or Even Free
    ... UDQ Consulting Services Believes that Every Problem Should Have an Easy & ... templates, spreadsheet applications, and database applications. ... P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.misc)