Is access the program I want

[Sue]

I am using Form Flo to do price quotes - it was provided
by the home manuf. I hate it - it's junk. Will Access
allow me to create forms and do complex quoting using
large data bases? Is it possible to convert frp and
other form flow files into a format that access can read
so I don't have to redo all the entries? Newbie to
Access. Thanks, please respond by email if possible.

 

[StCyrM]

Hi Sue

Form Flo does it's advantages, but the one thing it's not is a good database.
Access should be able to meet your requirements.

First thing to do, is figure out if you can export the data from Form Flo. If
I remember right I believe you can export to a .DBF file. You could then link
or import that file into Access and take it from there.

Keep us informed as to your progress.

Best regards

Maurice

 

[John Nurick]

Hi Sue,

I've no experience of Form Flo. Access is immensely versatile for
databases with up to a few hundred megabytes of data - but there's a lot
of learning involved in building a good database application, especially
for complex quoting and estimating tasks.

Normally it's fairly easy to move data from another application into
Access (export into a standard format such as csv or dbf and then import
into Access), but everything else (the forms, the business rules, the
logic) has to be re-created from the start using Access's own tools and
taking advantage of the power of the relational database model.

So what this is getting round to is that unless you have lots of spare
time and want to learn database programming, you may be better off in
the long run either buying a third-party application that suits your
needs better than Form Flo or hiring an Access developer to build a
custom application for you. (I'm not in that business, so this isn't a
pitch for work<g>).

 

[Ed Warren]

Access is limited to about 4GB, if you need more than this may want to
consider a "real dbms".

I think Access is easy to learn, up the point you need to start some complex
calculations, then you have to go into Visual Basic for Applications.
Unless you have some programming experience, this can be a daunting task.

Best of Luck:

Ed Warren

 

[Kevin3NF]

2GB...not 4

--
Kevin3NF

Sick of all that junk filling up your mailbox?
http://spamarrest.com/affl?2967001