Will Access do what I want?

[Guest]

I have a very old DOS programme which is not compatible with Vista, so
looking at Access to see if it will do the same.
It is an order/invoice generating programme. I enter the customers' detail
on a database, from which I can generate an order and advice note on the
factory. When despatched, I can then create the invoice, totalling several
items, calculate the carriage and VAT automatically. It will also create a
stock check list.
Can anyone help?

 

[Guest]

Hi

Export your DOS files as comma dilimated and (then) import them in to
access. This will work for all versions of access includeing 2K7 vista as
far as I know.

 

[Joseph Meehan]

I have a very old DOS programme which is not compatible with Vista, so
looking at Access to see if it will do the same.
It is an order/invoice generating programme. I enter the customers'
detail on a database, from which I can generate an order and advice
note on the factory. When despatched, I can then create the invoice,
totalling several items, calculate the carriage and VAT
automatically. It will also create a stock check list.
Can anyone help?

Well without knowing details I don't think anyone can say with 100%
certainty, but I would say it is about 97% certain that it can. You should
be able to import the existing data, but not the forms reports etc, those
you will need to re-create.

The real problem is that Access has a rather steep learning curve and if
you are not familiar with modern database design you may find it more of a
job that you think. Of course you will learn a lot doing it and there are
lots of people here to help you along the way.

I would suggest thinking about what the real needs are before beginning
the project. The usual procedure for this kind of project is to try and
copy what exist, when in reality you really should design new based on the
real business needs, and not try to copy the existing design or look. Many
opportunities are lost by not using the new tools available and buy not
taking this opportunity to eliminate some prior rough parts of the existing
program.

 

[John W. Vinson]

On Mon, 25 Jun 2007 06:44:01 -0700, The bard <The

I have a very old DOS programme which is not compatible with Vista, so
looking at Access to see if it will do the same.
It is an order/invoice generating programme. I enter the customers' detail
on a database, from which I can generate an order and advice note on the
factory. When despatched, I can then create the invoice, totalling several
items, calculate the carriage and VAT automatically. It will also create a
stock check list.
Can anyone help?

Access is quite capable of doing this... in the same sense as Excel is quite
capable of creating an accounting application. You won't have the application
that you want sitting there ready when you open Access; but you can (with some
effort) create one to duplicate all these features.

Check out some of the links:

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


John W. Vinson [MVP]

 

[Tom Wimpernads]

Access doesn't have a steep learning curve.

it's marketed for beginners and newbies.

you should focus on SQL Server and learning ONE DIALECT instead of an
obsolete desktop piece of crap

 

[Joseph Meehan]

Access doesn't have a steep learning curve.

it's marketed for beginners and newbies.

you should focus on SQL Server and learning ONE DIALECT instead of an
obsolete desktop piece of crap

Aarron, why do you keep using other people's names when you post your
opinions?