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 ILACaccdb database from the location where you store your Data Files, then save it as ILACSupportDesk. Enable content if prompted.bCreate a new query in Query Design View based on the Calls table.cSelect 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 Hint: There are several ways to select all the records in a single month, but using the asterisk as a wildcard, as in is one of the shortest. dUncheck 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.eReturn to Design View and change the query into a Make Table query using the name April for the new table, then run the query.fSave the query with the name MakeApril then close itgOpen the April table to make sure that it has eight records with a CallDate value in April of then close itCreate an Append query.aCreate 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.bAdd criteria to the CallDate field to select only those records from May of 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
