Excel vs Access for order form

[TIbbs]

I need to design an order form to be distributed to all our customers. My problem is I don't know wether to use Excel or Access to achieve this.
The underlining data will come from our database so they can look up the codes and enter the quantities they require.
I worked mostly in Access for database development and am a bit reticent to use Excel since it is a flat file format. For a simple form I would use Excel, I have it used it in the past for data analysis mostly, pulling data from an underlying Access database.
I always know that requirements always change and more functionality might be required of the application at a later date.

So far I can only think of 2 main tables that may be used for the data entry:
Stock table
Discounts table

I can think already of a few problems, it seems that most companies have Excel installed, but not all have MS Access.

In terms of scalling the order form/application at a later date which will be better overall MS Access or Excel?

 

[DCrake]

It may be worth while writing the program in Visual Basic and creating an EXE file which can be deployed. This means that you do not need to have Access installed. Access 2007 comes with a runtime version, but you did not indicate which version you are using.

 

[TIbbs]

Sorry, I am currently using Access 2003.
I was leaning towards Access, but was not sure how I would deploy it.
Thanks I'll look into the EXE file.

 

[TIbbs]

Just looked into it, seems that I will need to purchase the Access 2003 Developer Extension. Some how I don't see it happening at the moment. Probably will have to work in Excel for the time being, oh well

 

[LeeInEngland]

I would develop in Excel. Provide your data in a hidden worksheet that you can source for validation of part numbers etc. This will make life easier for everyone. I know many companies wouldn't be able to run an .exe if you sent them one because of permissions on their systems.