Insert query in msAccess with autonumber

Well this is very simple task
if you have watched it carefully see your query you have 6 tables values and 5 parameters so it is always gives you error all the tabled values which you want to insert then must be matched with the parameters suppose you want to insert 3 fields then you can add 3 parameters only

now take a look at your query you have id as a extra field as you mentioned that you have id as a auto increament so just remove that one

and your new query will look like this one

cmd1.CommandText = "INSERT INTO LoginTable(GivenName,Gender,EMail,UserName,Password) VALUES (@GivenName, @Gender, @EMail, @UserName, @Password)";

:)

You can have a look at this examples given at the below link:
syntax-error-on-insert-into-single-column-auto-increment-table[^]