Re: I'm not a SQL programmer but I need help please

If not already done so I would look at some off the shelf products as
Bespoke usually means big "£££'s" (talking from experience)
Many of the companies do job costing modules - as you already use Sage Line
50 - Sage would be my first port of call - Sage MMS or Sage Construct
(specific for the construction industry - CIS etc) but there are others out
there . . . .

Sorry if I am teaching granny to suck eggs - you may have already looked at
off the shelf packages

"Tim" <Tim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:565A8573-FEFD-4AA5-B670-317A3EA752C2@xxxxxxxxxxxxxxxx
> Hello
>
> Yes, I certainly am not a programmer. Access gives me enough of a
> headache.
> What I'm after is some advice.
> 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
>
>
> Tim


.

Relevant Pages

  • Re: A Challenge?
    ... >>> especially Sage, and I run all my company accounts on it. ... >> I'm at the end of said alley now, and it is harming the business. ... either under GPL or to anyone else - outright sale never came up. ... > What do you have in mind - a row of phones with people having control ...
    (comp.sys.acorn.apps)
  • Re: A Challenge?
    ... Sage is Sage, and I'm sure the accounts side is wonderful - but the stock ... control is *crap* - only short descriptions allowed, ... much the same reasons I am (i.e. the need to run a profitable business). ...
    (comp.sys.acorn.apps)
  • Bookkeeping and Accountancy software
    ... The concepts of bookkeeping from a managerial perspective ... The business is lacking organisational structure for it's size and is ... With regards to Sage we run the accounts package alongside Sage ... PS If someone thinks another accounting product is more suitable for ...
    (uk.business.accountancy)
  • Re: Bookkeeping and Accountancy software
    ... > good at "running" the business but has difficulty wresting himself away ... > bookkeeping side of the business. ... > "Bookkeeping and Accounts for Small Business" by Tony Bannister. ... > With regards to Sage we run the accounts package alongside Sage ...
    (uk.business.accountancy)