You need proper primary and foreign key assignments.
When I looked at your DB it did not have any. Each table needs a primary key. It should be an Auto number. You can choose a Long Integer also. You can have up to 2 million records using a long, actually a little more.
Spend some time looking at the sample DB I uploaded in the other thread. It has examples of how to create relationships and use them in a query.
After you spend some time assigning Primary Keys to your Tables and giving your tables the ability to store the values of other table's primary keys, you need to start building queries. After you practice with the table relationships, build a query. After your queries don't work how you want. Go back to redesigning your table structure and try again.