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 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?