SQL Server can work seamlessly with Microsoft Access: SQL Server is the back end that contains tables and queries, while Access contains the forms and code.
Microsoft Access
Queries and Tables CCD, LLC
What is the difference between queries and tables? (in Microsoft Access for example)