tblUsers =================== UserID AutoNumber UserName String (Not NULL, not empty string) Password String (Not NULL, Empty string OK, Default "") Active Boolean (Not NULL, default True) Comment String (Not NULL, Empty String OK, Default "")
INSERT INTO tblUsers ('UserName', 'Password') Values ('Hello', 'World')