Conversions of anything are rarely the way to approach a problem. And your problem statement is not entirely clear - if you plan to ask more questions always supply some sample data and the results you expect from that sample data.
In this case it looks as if you are trying to get a count of data based on column
- so start off with a query that does that e.g.
SELECT colldet.college, S_P, Count(*) AS Expr1
FROM manuscript RIGHT JOIN colldet ON manuscript.coll_name = colldet.college
GROUP BY colldet.college, S_p;
You can then use the Access equivalent of SQL's PIVOT - TRANSFORM statement (Microsoft Access SQL) | Microsoft Docs