SQL input form

you might consider using lightswitch: http://blogs.msdn.com/b/bethmassi/archive/2012/08/15/getting-started-with-lightswitch-in-visual-studio-2012.aspx

i'd create winform with gridview control which binded to the table in your sql server DB.
the gridview will be editable so user can input new data for all fields.

add Submit button which submits all the data into your sql DB using table adapter.

check this code for example:
Insert, Update, Delete with DataGridView Control in C# (Windows Application)  

Everyone's suggesting solutions that will work, but before you settle on a solution make sure you look at the details view control and/or forms view control (if you want to modify the layout of the form).

These two forms behave slightly differently than the gridview and will make for a more convenient user experience.

All you need to do to add any of these is just create a new webform.aspx file and add a sqldatasource control. If the data is all in a single table, you can click the advanced setting, and as long as your table has a primary key, VS will create the insert and update commands for you.

Next just drop your dataview/formview/gridview onto your form and select your sqldatasource as it's data source.

To do that Link that table in MS Access and in that create form based on Link table using Wizard.