Need ODBC connection to postgresql to include materialized views
I have found that Postgres views are included in the linked tables within Access. Click on any linked table within Access and within the list should be your views.  I always find it useful within Postgres to preface a view name with 'VIEW_' so that they are all readily visible and accessible within Access.