Re: Not specific access question, need help please
- From: "Bill McKnight" <mcknight.bill@xxxxxxxxxxx>
- Date: Sat, 3 Dec 2005 15:59:48 -0500
Hi Tim,
I am willing to open up a dialogue with you regarding your question(s). But
I need a couple of weeks. I'm moving to Phoenix, AZ this week and need to
settle in and activate new cell phone and internet services. Should be all
set by Monday the 12th.
About me, I am an ex-accountant of ten years who has managed information
systems for the past seven. My experience is within construction and
manufacturing industries and includes implementing ERP systems within these
environments (including job costing).
In a nutshell the primary difference is scalability, capability and
flexibility going forward. Many database back ends will suffice (Oracle,
DB2, SQL Server, MySQL). The database needs to store the data securely,
efficiently and maintain integrity. With any of these database engines
design and architecture is the key.
Your focus needs to be on business process analysis. Defining the who,
where, when, why's of how and what you do. This melding of systems,
programming and business analysis get you what you want. It sounds like you
need integration between the GL, AR, AP, PR and JC modules.
To share my experience and knowledge with you, contact me at
mcknight.bill@xxxxxxxxxxx and give me ten days to get back to you.
Bill McKnight
"Tim" <Tim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8C2E04A8-6F44-4D1B-A272-75B31F0E24E1@xxxxxxxxxxxxxxxx
> Hello
>
> Me and my brother run a small business and we have decided to have a
> database developed specifically for our business. The question is what do
we
> need? We have approached several companies offering to build a bespoke
system
> for us based on SQL Server 2003 (as I understand, correct me if I'm
wrong).
> Another company that seems quite useful uses Visual Fox Pro. Now I've
looked
> at both these websites. I realise they are both Microsoft programmes.
Would
> someone tell me what the difference is between the two?
> Our business is in the building services industry on the mechanical side;
> that is we install heating systems, air conditioning, ventilation and
> building controls and we operate around 25 operatives and have around 5
> office staff and the business is getting very stretched. The only thing
that
> is semi automated are our accounts which are done on Sage Line 50 v10.
> We do not have even a simple employee table, mobile phone table, etc. An
> important area for our business is job costing, adding material costs +
> labour costs, and this is something we would be very interested in.
> The companies we have spoken to that offer bespoke services whether be by
> SQL or Visual Fox Pro say that once a core module is built e.g. An
employee
> module, other modules could be bolted on at a later stage so that they
would
> interact.
>
> I would very much appreciate someone who would just spend some time
> clarifying some of the points I have made. If I haven't been specific
enough,
> I would be happy to give you further details.
>
> Thank you in advance
>
> Regards
>
>
> Tim
>
> P.S. I have posted this to SQL discussion board but it doesn't seem as
> active as Access + as I understand there are links between SQL and Access
.
- Prev by Date: Re: Save User Information
- Next by Date: Re: DSUM function
- Previous by thread: Re: How can I scan documents into Access
- Next by thread: Re: Not specific access question, need help please
- Index(es):
Relevant Pages
|
