Useful site here compares MS Access and MS SQL. The site also provides a list of useful conversions of typical MS Access SQL functions into MS SQL.