Excel form and database

I have this form that I send to vendors that send me defective stuff. I use to print it out and fill it out by hand. I don't want to do that anymore. This is what I want to do.? Tell me to what degree you can create what I want. ? PRINTING ? Rather than have to drag to set the print area each time I want to print a filled out form/record, I'd like to be able to just press a button and print my form just the way it is. I'm typically printing my form to PDF creator software to be emailed or faxed. ? DATA ENTRY ? Have the "Reason" field be either a selection from a drop down menu, or if the reason is unique, have the ability to type in a reason not on the drop down menu. ? As I get more vendor information in the database, have it so that the vendor info will autofill rather than have to fill it all out each time when I send the form to a vendor I have previously sent the form to. ? Make certain fields required entry ? Set a data entry field tab order ? Have the "Date requested" field be autofill ? Have certain fields be formatted to be upper caps only ? Have the "Requested by" field be a menu to select names from ? ? DATABASE MANAGEMENT ? Have each completed form, and all the information associated with it, be a unique? and searchable database record ? The form I will? email you is to be a data entry form for entering the requested information into a searchable? Excel database.? I'd like the data entry form to look just like the form I send to the vendor. ? ? ## Deliverables The completed unzipped data entry form can be emailed to you.