Queries/Reports using tables in same database

Hi Alice, Welcome to the forum, Thank you for your post, In answer to your question, Access is a multi-relational database which is designed to extract information from multiple tables where these tables have a link or join through a relationship, there are three kinds of relationship these are one to one, one to many and many to many, if we take one to many for example this could be a department which has many workers, the department would be the one side and the workers the many side. If a relationship is created say through the department id field which will also appear in the employee table (employee is in ie HR) then it is straightforward for a query to link all the employees in the employee table who are in the HR dept together. I realise that this is a very simplified example but I hope it helps with your question. best regards Pete