Finding the names and the year of the movies that have at least 5 actors
This code works in T-SQL and should work in Ms Access:

SELECT COUNT(M.MovieID) as 'Count', M.MovieName, M.Year FROM Movies M
INNER JOIN ActorsMovies AM ON AM.MovieID = M.MovieID
INNER JOIN Actors A ON AM.ActorID = A.ActorID
GROUP BY M.MovieID, M.MovieName, M.Year
HAVING COUNT(M.MovieID) &gt; 5


I also recommend not to use Year as a field name because it's a reserverd keyword in Ms Access and may cause problems:
https://msdn.microsoft.com/en-us/library/bb208875(v=office.12).aspx