ok lets assume you have 2 fields (this can be expanded obviously) that you need to create, ID and Name. you will create 2 txtboxes, txtID and txtName, and a button, cmdSave.
you will then choose "even procedure" from the button's on click event in the properties box. This will open up a VBA editor and an empty sub for you to fill in. your code will be:
Code:
dim strSQL as String
strSQL = "INSERT INTO myTable (columnID, columnName) VALUES (" & Forms!myFrm!txtID & "," & Forms!myFrm!txtName & ");"
docmd.RunSQL (strSQL)
adjust myTable, myFrm, etc to make it work with what you have.