Can I use my Views on a SQL Sever database in MS Access?

I have Views on a SQL server database that I have painstakingly written. I am creating linked tables on my MS Access Database. I am only able to pick from tables. Is there a way to use my Views on the SQL Server within MS Access, which has all the data I need?

Views in SSMS:

Can only see Tables in MS Access linked Tables manager:

Solution

Yes, you can. From Access' point of view, linked tables and views are almost identical.

Except when linking a view, you need to tell Access the primary key - for tables it it determined automatically. Without specifying the PK, the linked view is read-only.

The Linked Tables Manager in Access shows only tables/views that are already linked.

To automate the process, see here: https://stackoverflow.com/a/32316883/3820271