A word of advice: do not let the internship become Access-focused. An "internship" on many occasions means "Oh hallo, so you are our new free slave obliged to do whatever crap we come up with and have not bothered to do ourselves?"
Access works on huge majority of IT-departments like a red rag on a bull. Justifiably or not, that is the situation.
Do PHP or one of the .NET flavors or ROR or Java or C++ - DO NOT DO ACCESS.
Access (and Office VBA) are limited relative to full-blown languages like, say, VB.NET. You can always learn and do Access as a sideline.
Update: Further, Access solutions are seldom developed in a team. Team development would seem to be a rather vital part of leaning.