I want to be able to add new records to my Tables through a Form interface. I have designed a form for entering all the fields present on the table and I want to be able enter the data onto the form and then click an 'Add Record' button and this record and all its detials be stored in the designated table. How do I do this?

In the form design view, put a button on the form and with the button wizard designate the command that you want.

Simply closing the form or moving to another record will save the entry you don't need a button to do this providing the form is based on your table.