This is very straightforward. Like Christian said, both username and password would be strings, and stored in the database as text fields in Access. Encrypt the password using an encryption algorithm of your choice, preferably one that isn't crackable like DES...
"The clue train passed his station without stopping." - John Simmons / outlaw programmer