Microsoft Access query explainer

Explain and understand query for Microsoft Access.