right application?

B

brenda

This is a small business, and i'd like to be a reseller for marketing lists,
but also offer "database management" and custom reports from the database.
All info is currently in Excel. It works, but it's clumsy. Also, I can't
create custom reports in Excel. 1) Is Access the best software to use? I'm
relatively computer-illiterate. 2) Should I attempt to learn Access on my
own, or is it better to get training? If so, what type? Any info would help!
 
A

Aaron Kempf

I'd reccomend SQL Server, Access is a little bit obsolete


brenda said:
This is a small business, and i'd like to be a reseller for marketing lists,
but also offer "database management" and custom reports from the database.
All info is currently in Excel. It works, but it's clumsy. Also, I can't
create custom reports in Excel. 1) Is Access the best software to use? I'm
relatively computer-illiterate. 2) Should I attempt to learn Access on my
own, or is it better to get training? If so, what type? Any info would
Click to expand...
help!
 
A

Aaron Kempf

if you're in the Seattle area-- then I'd reccomend SqlSoft.. if you're
elsewhere; you should go to the closest community college and see what they
offer

don't get me wrong-- Access isn't awful-

but if you want a long-term solution including reporting and stability?
then you're best off lookign at SQL Server



brenda said:
This is a small business, and i'd like to be a reseller for marketing lists,
but also offer "database management" and custom reports from the database.
All info is currently in Excel. It works, but it's clumsy. Also, I can't
create custom reports in Excel. 1) Is Access the best software to use? I'm
relatively computer-illiterate. 2) Should I attempt to learn Access on my
own, or is it better to get training? If so, what type? Any info would
Click to expand...
help!
 
J

John W. Vinson

This is a small business, and i'd like to be a reseller for marketing lists,
but also offer "database management" and custom reports from the database.
All info is currently in Excel. It works, but it's clumsy. Also, I can't
create custom reports in Excel. 1) Is Access the best software to use? I'm
relatively computer-illiterate. 2) Should I attempt to learn Access on my
own, or is it better to get training? If so, what type? Any info would help!
Click to expand...

Access is very capable of making marketing lists... but it's got a much
steeper learning curve than Excel. If you want to market yourself as providing
database management, prepare to spend a good deal of time (and even more skull
sweat) learning how to do it right (it's VERY easy to do it wrong, even easier
if you're experienced with Excel since it's a very different environment!)

There are lots of resources for learning Access; two places to start looking
are

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

You may also want to consider hiring or working with someone already
experienced in Access, at least to get started.

John W. Vinson [MVP]
 
E

Ed Metcalfe

brenda said:
This is a small business, and i'd like to be a reseller for marketing
lists,
but also offer "database management" and custom reports from the database.
All info is currently in Excel. It works, but it's clumsy. Also, I can't
create custom reports in Excel. 1) Is Access the best software to use?
I'm
relatively computer-illiterate. 2) Should I attempt to learn Access on my
own, or is it better to get training? If so, what type? Any info would
help!
Click to expand...

Brenda,

If this is your first experience of database work I would strongly suggest
there is one thing you need to learn before you start learning the specifics
of MS Access (or any other relational database management system) -
normalisation (or "normalization", dependant on where you're from!).
Understanding this is absolutely paramount. You can be the best Access VBA
person in the world; if you don't understand the basics of normalisation
your databases will still be pants. :)

Ed Metcalfe.
 
Top