Question: Start Access, open the IL _ AC _ 9 - 2 . accdb database from the location where you store your Data Files, then save

Start Access, open the IL_AC_9-2.accdb database from the location where you store your Data Files, then save it as IL_AC_9_SupportDesk. Enable content if prompted.b.Create a new query in Query Design View based on the Calls table.c.Select all fields from the Calls table using the asterisk (*), then add the CallDate field a second time and add criteria to select only those calls in April of 2021.(Hint: There are several ways to select all the records in a single month, but using the asterisk as a wildcard, as in 4/*/2021, is one of the shortest.) d.Uncheck the Show check box for the CallDate field, then display the datasheet to make sure youve selected the correct records. The datasheet should have eight records.e.Return to Design View and change the query into a Make Table query using the name April2021 for the new table, then run the query.f.Save the query with the name MakeApril2021, then close it.g.Open the April2021 table to make sure that it has eight records with a CallDate value in April of 2021, then close it.2.Create an Append query.a.Create a new query in Query Design View based on the Calls table. Add all the fields to the query grid except for the CallID field.b.Add criteria to the CallDate field to select only those records from May of 2021, then display the datasheet. It should have seven records

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!