Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with this assignment ( it is MindtapAccess Moudle 3 : Maintaining and Querying a Database Case 1 Problem ) for Microsoft Access,
I need help with this assignment it is MindtapAccess Moudle : Maintaining and Querying a Database Case Problem for Microsoft Access, please try to use as little SQL as possible. Great Giraffe Jeremiah needs to modify a few records in the Career database and analyze the data within the database. To help Jeremiah, youll update the Career database and create queries to answer his questions. Complete the following:
Open the Career database you created and worked with in previous modules, and then click the Enable Content button next to the security warning, if necessary.
In the Student table, find the record for StudentID ART and then change the Street value to Barclay Avenue and the Zip to
In the Student table, find the record for StudentID ESP and then delete the record. Hint: Delete the related records in the Registration subdatasheet first. Close the Student table.
Create a query that lists students who are on a payment plan for any of the courses offered by Great Giraffe. List only the StudentID, FirstName, and LastName fields for the students in your results, and sort the results in ascending order by the LastName field. Save the query as AllPaymentPlanStudents, run the query, and then close it
In the Navigation Pane, copy the AllPaymentPlanStudents query, and then rename the copied query as LittletonPaymentPlanStudents.
Modify the LittletonPaymentPlanStudents query so that it only displays those students from the city of Littleton. Hint: When you are entering the criteria for a Short Text field, Access usually places the quotation marks around the text; however, you may also type the quotation marks if you are having trouble entering the text properly. The City field should not appear in the query datasheet. Save and run the query, and then close it
Create a query that lists students who are taking one of the Computer Science courses offered. Hint: Instead of looking at the individual sections, look at the Title of the courses. In the query results, display only the StudentID, FirstName, LastName, and Phone of the students in the courses. Sort the results by StudentID in ascending order. Save the query as CompSciStudents and run the query.
Use the CompSciStudents query datasheet to update the Student table by using for the Phone value for Wendy Bradshaw.
Change the size of the text in the CompSciStudents query datasheet to use a point font size. Resize columns, as necessary, so that all field values and column headings are visible.
Change the alternate row color in the CompSciStudents query datasheet to the Theme Color named Green, Accent Lighter and then save and close the query.
Create a query that lists the InstanceID, Title, StartDate, HoursPerWeek, and Cost fields for courses that begin anytime in the first three months of Save the query as FirstQuarterClassOptions, run the query, and then close it
Create a query that lists the total outstanding balances for students on a payment plan and for those students that are not on a payment plan. Show in the query results only the sum of the balance due, grouped by PaymentPlan. Name the summation column Balances. Run the query, resize all columns in the datasheet to their best fit, save the query as TotalBalancesByPlan, and then close it
Compact and repair the Career database, and then close it
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started