Excel, Access, Works, or Other?

[Michael]

I am posting this for a friend, so please reply to the newsgroup.
Thanks!
Michael

"
Hello:

I need to know which Windows database program (Excel, Access, Works, etc.)
is the easiest to use to accommodate the following requirements for a
database of about 500 to 1,000 rows and about 30 columns. The data
presently resides in Microsoft Works for Mac (v4.0 on system 7) and will
somehow get entered into the new Windows db.

1) Creating a filter limited to criteria such as: "Column 5 (or whatever
its name)" contains "XXX" or "YYY" but does not contain "ZZZ."

2) Printing a report that contains only those people included in the above
filter, and limiting the printed report to only the desired columns.

3) Printing mailing labels only for those same "filtered" people.

The filter criteria will need to be modified several times per year.

Thanks very much.

--Gary
"

 

[Rafael Ortiz]

It's really a matter of preference. I personally like to use Excel, because
I can usually make it do whatever ai need it to do. Access, on the other
hand, is a great database application, and I can set up a database, but I am
not nearly as familiar wth it.

So I think a lot depends on your friend's comfort level with the different
applications - use whatever he is most familiar with. After all, what good
would it do to use Access if you cannot set up queries or reports...?

MRO

 

[Jim Carlock]

Excel and Access work great together!