Access or Excel? What should I use for a small project?

[bolido2000]

I want to write a template for my parents business. It should have the following fields: Item #, Description, Date in (merchandise arrive in the store), Date out (merchandise sent out), quantity, and price. Its basically to keep track of inventory. Would Excel or Access be a better solution? Which one would be easier to do?

 

[HomeBrewerDude]

i'm guessing access.

 

[Hoober]

Depends...

Do you want to have a database and then set up a form for your parents and their employees to use to insert information, or do you just want a spreasheet that tallies said information?

 

[toekramp]

access, access, access, access, access, access, access...i'd choose access

 

[IamElectro]

Is as broad as it is long. Both would work well the Excell sheets would be a little easier but the Access Dbase would be more versatle. With Access you could set up forms to enter the data and Queries could be set up to easily retrive specific data as appossed to searching multiple sheets for something in Excell

 

[HomeBrewerDude]

access should be more idiot proof too.

 

[alareau]

excel is a poor man's access!

Access all the way

 

[DT4K]

What you are describing is essentially a small database.
So Access would be more appropriate.

You can easily setup a couple of db tables and some forms to enter, display, and edit the data.