Question: 1 4 . - Open theCustomersWithoutConfirmations - queryin - Design - View - and perform - the - following tasks: 1 a . - Change

14.- Open theCustomersWithoutConfirmations-queryin-Design-View-and perform-the-following tasks: 1a.- Change-the join-property-for-the-relationship-between-the-Customers-and-Confirmations-tables-to-select-ALL-records from-the-Customers-table-and-only thoserecords-fromthe-Confirmations-table-where-the joined-fields-are-equal.b. Add-the-Is-Null-criteria-for-the-ConfirmationID-field-and-add-an Ascending-sort-order-on-the-LastName-field.Save-the-changes-to-the-query.Open the query-in-Datasheet-View-and-confirm-that-there-are-nine-records-in-the-query-result.Close-the-query.1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!