Create a query in Access that uses two tables, the Patient table and the Session table. Add
Question:
Create a query in Access that uses two tables, the Patient table and the Session table. Add the LastName, FirstName, and SessionDate fields to the query grid. Run the query. How many records are displayed? Delete the join line between the field lists in Query Design View. Rerun the query. How many records are now displayed?
Why are the results different? You do not need to save the queries.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
When the join line is present in Query Design View the query performs an inner join which ...View the full answer
Answered By
Benard Ndini Mwendwa
I am a graduate from Kenya. I managed to score one of the highest levels in my BS. I have experience in academic writing since I have been working as a freelancer in most of my time. I am willing to help other students attain better grades in their academic portfolio. Thank you.
107+ Reviews
240+ Question Solved
Related Book For 
Concepts Of Database Management
ISBN: 9780357422083
10th Edition
Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt
Question Posted:
