We just recently moved an internal database from access to SQL Server Express 2008. Other then taking backups and applying patches are there basic administration tasks that I should be doing?
google "sql server administration for beginners"
also, have a look here for books to read BrentO
The pdfs from redgate are pretty good - lots of things you can look at.
Your three main things to look after are...
Test a backup to another database name and make sure it works for you. Make sure you are notified when the backups fail.
You'll want to do periodic maintenance on the indexes too. I prefer this script - http://ola.hallengren.com/
This type of stuff is a bit of a pain in sql express since there is no agent to run jobs. You'll need to use the windows task scheduler or another tool to schedule .bat's to run.