Not sure what you are asking.  Do you want to be able to store the data in SQL Server and link from Access?  yes, you can do that.  Do you want to be able to link from SQL Server to Access?  Yes, you can do that, too with a Linked Server.