This is an excellent question, kinda reminded me of good ol' days when I worked with Access :-), thank you Timothy. The difference between Access and SQL Server is caused by the difference in so called mid point rounding rule:
Access uses to even rule
SQL Server uses away from zero rule.
Oleg