Home / Expert Answers / Computer Science / nbsp-1-create-a-query-in-access-that-uses-two-tables-the-patient-table-and-the-session-table-pa595

(Solved):   1. Create a query in Access that uses two tables, the Patient table and the Session table. ...



1. Create a query in Access that uses two tables, the Patient table and the Session table. Add the LastName, FirstName, and S

 

1. 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. 2. Enter an additional record in the Session table with the PatientNum 1022. What happens when you try to move onto another record? What is the error message? Why?


We have an Answer from Expert

View Expert Answer

Expert Answer


1. When the join line is present between the Patient and Session table, the query displays all records where there is a match between the two tables.
We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe