I have an excel spreadsheet that is unpopulated(no data). I want to turn this excel sheet into a database. The excel sheet highlights all the information I request with equipment requisitions. My question is: Must I turn each field/column in the excel sheet (there are 30 fields/column btw) into a database Table? Or do I make one simple Table with all the fields in the excel table as fields in the one Access Table?
Additionally, which ever route is recommend from the above question, Could I then use a Access Form to input new requisitions? Overall all the data that would be input to my excel sheet I track as a single requisition. I give it a numerical designation.