Homework answers / question archive / 1) Create a query that finds all records in the tblStudent table in which the City field value is not equal to Denver

1) Create a query that finds all records in the tblStudent table in which the City field value is not equal to Denver

Computer Science

Share With

1) Create a query that finds all records in the tblStudent table in which the City field value is not equal to Denver. Display the FirstName, LastName, City, and Email fields in the query recordset, and sort in ascending order by City. Save the query as qryNonDenver, run the query, and then close it.

2) Create a query to display the InstancelD, TotalCost, and BalanceDue fields from the tblRegistration table and the Phone and Email fields from the tblStudent table. Find all records for which the BalanceDue value is greater than 0. Add a calculated field named Payer as the first column that concatenates FirstName, a space, LastName, and (student) if the BillingLastName field is null. Otherwise, the calculated field should concatenate BillingFirstName, a space, BillingLastName, and (billing). Sort the results on the calculated field in ascending order. Save the query as qryBalanceContacts, run the query, resize all columns to their best fit, and then save and close the query.

3) Create a parameter query to select the tblStudent table records for a City field value that the user specifies, using Enter the city: as the prompt text. If the user doesn't enter a City field value, select all records from the table. Display all fields from the tblStudent table in the query recordset. Save the query as qryStudentCityParameter. Run the query and enter no value as the City field value, and then run the query again and enter Littleton as the City field value. Close the query.

4) Create a find duplicates query based on the tblRegistration table. Select StudentID as the field that might contain duplicates, and select all other fields in the table as additional fields in the query recordset. Save the query as qryDuplicateStudentRegistrations, run the query, and then close it.