Switch my Excel DB to Access?

[Guest]

Greetings,
Over the past year, I have been learning Excel for a decent sized worksheet
that keeps track of open positions, who is applying for jobs, and quite a bit
of other 'employment' type data. This is mainly a database with quite a few
vlookups. This is also a shared workbook with several people in the office
that keep it open and update throughout the day.

My question is...would it be wiser to work towards learning access and then
switching it over to access? What would be the advantages? Disadvantages?
I would appreciate all insight.

Thank you in advance,
Mike

 

[Steve Schapel]

Mike,

I would say definitely, it sounds like Access is more suitable than
Excel to this purpose.

You might find this interesting:
http://office.microsoft.com/en-us/assistance/HA010429181033.aspx

 

[John Vinson]

Greetings,
Over the past year, I have been learning Excel for a decent sized worksheet
that keeps track of open positions, who is applying for jobs, and quite a bit
of other 'employment' type data. This is mainly a database with quite a few
vlookups. This is also a shared workbook with several people in the office
that keep it open and update throughout the day.

My question is...would it be wiser to work towards learning access and then
switching it over to access? What would be the advantages? Disadvantages?
I would appreciate all insight.

I'd recommend it. See Steve's link for technical details.

But my take on it is: Excel is a spreadsheet, an excellent one.
Access is a relational database interface program. (It's not a
relational database itself - it uses the JET relational database
engine by default, but can use SQL/Server or any other database
engine).

If you need to perform database functions, use a program designed for
database functions - Access!

You can drive nails with a crescent wrench, but that doesn't make it a
hammer!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps