Question

4. create a new delete query in design view with the following instructions: a. select all of the fields from the client table. b. add criteria to select only those records with a contractsigned date prior to 7/1/2021. c. run the query which should delete three records from the client table. save the query with the name deleteoldcontracts and then close it.

Answer 1

To create a new delete query in Design View with the given instructions, follow these steps:

1. Open the database in Microsoft Access and go to the "Create" tab.
2. Click on "Query Design" to open the Design View.
3. Add the "Client" table to the query by selecting it from the list and clicking "Add," then close the "Show Table" dialog box.
4. Select all of the fields from the Client table by double-clicking on each field in the table.
5. Change the query type to "Delete" by clicking on the "Delete" button in the Query Type group on the Design tab.
6. Add criteria to select only those records with a ContractSigned date prior to 7/1/2021 by typing "<7/1/2021" in the "Criteria" row under the "ContractSigned" field.
7. Run the query by clicking on the "Run" button (exclamation mark) in the Results group on the Design tab. This should delete three records from the Client table.
8. Save the query with the name "DeleteOldContracts" by clicking on the "Save" button (floppy disk icon) on the Quick Access Toolbar, typing the name in the "Save As" dialog box, and clicking "OK."
9. Close the query by clicking on the "X" button in the top right corner of the Query Design window.

Now you have created a new delete query in Design View with the specified instructions, which selects all fields from the Client table, deletes records with a ContractSigned date prior to 7/1/2021, and is saved with the name "DeleteOldContracts."