Excel, Access, or ??

[McLaren]

Greetings all, I'm looking into creating a file for work, and I'm not sure if I should be looking at using excel, access, or perhaps something else entirely. In a nutshell I want to have a database with rows for
part number
description
fixture location
program number
notes

I would also like to be able to do searches limited to one column or another, sort the entire database based on one column or another(with the row data staying matched up), and most importantly be able to click on the program number or notes or part number and open the matching file in a given application.

Any suggestions on what program to look into using? I'm thinking access, but I haven't used it yet, and I'm thinking it might be overkill from the little I browsed around the help file.

Thanks in advance.

 

[sweater_vests_rock]

McLaren.

Really Access or Excel would work, assuming your number of records is small -- Excel only allows <65537 records, and the file gets to be pretty large if you need all of them!

From what you described, I would lean towards Access, but I'm not sure it is worth LEARNING Access to do this (although you should probably learn it sometime )

Ben.

 

[McLaren]

Well, you're right, I probably should learn it sometime. I guess a simple project would be easier to learn it on, as opposed to a more difficult one. Access it is!
Thanks for the reply.