Solving task from Access database

[michał123]

Hello, I need help with solving task for my studies. I have no idea how to do this task. Could someone explain the way how to do it?
In attachment I uploaded 2 tasks and database.


Thank you in advance

[nick404]

Use queries and enter in the criteria it states for each field. For example the 3rd problem in your second picture would be a query where Buyer ID = "4084"

[ranman256]

3. (just to start you)
qsSellers = select [SellerId], [SellerName], [product] from tblInvoice
qsSoldProducts = select [BuyerId], [BuyerName], [product] from tblInvoice where [BuyerCity] = "Paczkow"

qsAnswer = select [product] from qsSellers, qsSoldProducts where qsSellers.Product = qsSoldProducts.Product