Become a member of PASS, find a local SQL Server user group

http://www.sqlpass.org/PASSChapters/USNortheast.aspx

Attend the meetings, introduce your self to other attending. In our user group frequent meeting sponsor(s) are consulting firms, employment firms wanting to talk to potential applicants. Do not be shy about being a newbie, let people know you are, and that you are looking for employment in a entry level position as either a DB Developer or DBA. Most jobs, good ones anyway, are not advertised, but filled by head hunters and by word of mouth, suggestions by those you know.

A second possibility, purchase a copy of SQL Server 2008 Developer Edition - cost about $50.00 available at AMAZON.COM. Work with it to become familiar with the differences between ACCESS and SQL Server.

Good luck.