Queries

Dear Joel

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

Access is a Relational Database which means that as long as the tables are linked correctly to each other directly or indirectly you should be able to extract any field or records from any table while creating a query.

If you are querying tables that have many-to-many relationship then it is important to display the junction table (The table that combines the two tables). You may still get some results but they may not make any sense at all.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007