If you've created multiple spreadsheets that contain the same data columns, you can combine their contents into one Access file by repeating the data-import process with each individual spreadsheet.

In Access, you can create forms by using the Form tools found on the Create Tab; in the Form Group, these Form Tools are: Form: Create a Form that allows you to input data into one record at a time.