Create a query to find all records in the tblstudent table

Assignment Help Computer Engineering

Reference no: EM133423539

Question: The Giraffe Jeremiah Garver is the operations manager at Great Giraffe, a career school in Denver, Colorado. Great Giraffe offers part-time and full-time courses in areas of study that are in high demand by industries in the area, including data science, digital marketing, and bookkeeping. Jeremiah created an Access database named School to store data about courses, registrations, and e following steps:

1. Open the School database located in the Exams folder provided with your Data Files.

2. Modify the first record in the tblStudent table datasheet by changing the First Name and Last Name column values to your first and last names, if necessary. Close the table.

3. Create a query to find all records in the tblStudent table in which the LastName field begins with H. Display the FirstName, LastName, City, and Phone fields in the query recordset, and sort in ascending order by LastName. Save the query as qryLastNameH, run the query, and then close it.

4. Create a query that finds all records in the tblCourse table with a Title value of Computer Science or Data Science. Use a list-of-values criterion and include the fields Title, StartDate, and HoursPerWeek in the query recordset, sorted in ascending order by StartDate. Save the query as qryCompOrDataSci, run the query, and then close it.

5. 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.

6. Create a query to display the InstanceID, 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.

7. 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.

8. 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

Reference no: EM133423539

Questions Cloud

Network technician for a small corporate network : network technician for a small corporate network. Today is your first day on the job, and you need to familiarize yourself with the network

Emotional intelligence is great trait that leaders possess : Emotional Intelligence (EQ) is a great trait that leaders possess and can actually build and grow unlike IQ.

How can dr. conlin decide which antibiotic is best to give : Mr. Brown goes to his doctor's office with a nasty, smelly bacterial infection on his hand. Dr. Conlin has ten different antibiotics that she could give him.

Describe four important functions of the blood : Describe four important functions of the blood. List and describe the basic functions of the four main components of blood Briefly describe the clotting

Create a query to find all records in the tblstudent table : Create a query to find all records in the tblStudent table in which the LastName field begins with H. Display the FirstName, LastName

Explain the role of glial cells and positive feedback loop : Explain how the nervous system processes pain and can misinterpret pain. Explain the role of glial cells and positive feedback loop.

What finally brings her to medical attention is development : What finally brings her to medical attention is the development of red, painful swelling on the dorsum of her left foot. Her physician notes Roth spots in both

How can utilization of nurse residency programs : How can the utilization of nurse residency programs for new nurse graduates help with nurse retention rates?

Identify the purpose and audience of your report : Identify the purpose and audience of your report. 4) Use at least seven references outside of your textbook (you may use your textbook too, but are not require

User Account

All Pages