Answered step by step
Verified Expert Solution
Link Copied!

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 3: Maintaining and Querying a Database Case 1 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:
1.
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.
2.
In the Student table, find the record for StudentID ART5210, and then change the Street value to 417 Barclay Avenue and the Zip to 80202.
3.
In the Student table, find the record for StudentID ESP1734, and then delete the record. (Hint: Delete the related records in the Registration subdatasheet first.) Close the Student table.
4.
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.
5.
In the Navigation Pane, copy the AllPaymentPlanStudents query, and then rename the copied query as LittletonPaymentPlanStudents.
6.
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.
7.
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.
8.
Use the CompSciStudents query datasheet to update the Student table by using (303)555-0042 for the Phone value for Wendy Bradshaw.
9.
Change the size of the text in the CompSciStudents query datasheet to use a 14-point font size. Resize columns, as necessary, so that all field values and column headings are visible.
10.
Change the alternate row color in the CompSciStudents query datasheet to the Theme Color named Green, Accent 6, Lighter 80%, and then save and close the query.
11.
Create a query that lists the InstanceID, Title, StartDate, HoursPerWeek, and Cost fields for courses that begin anytime in the first three months of 2021. Save the query as FirstQuarterClassOptions, run the query, and then close it.
12.
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.
13.
Compact and repair the Career database, and then close it.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems For Advanced Applications 18th International Conference Dasfaa 2013 Wuhan China April 22 25 2013 Proceedings Part 2 Lncs 7826

Authors: Weiyi Meng ,Ling Feng ,Stephane Bressan ,Werner Winiwarter ,Wei Song

2013th Edition

3642374492, 978-3642374494

More Books

Students also viewed these Databases questions

Question

Examine the role of identification in the behavior change process.

Answered: 1 week ago

Question

What is electric dipole explain with example

Answered: 1 week ago

Question

What is polarization? Describe it with examples.

Answered: 1 week ago

Question

4 How can you create a better online image for yourself?

Answered: 1 week ago