Question: what is the difference between power query and access?
Answer: Power Query offers capabilities to acquire, format and structure data but the assumption you are going with when you are using the Power BI stack is that you are operating on existing data, you are not building up data. On the other hand you can look at MS Access as a tool to build up and store structured data.