Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, working on my database management homework. Can anyone help me? Here is a google drive link for my database: https://drive.google.com/file/d/18QXoxauuxiuZSJEWVMq1dJpcRnZMO4-Y/view?usp=sharing And here is the

Hello, working on my database management homework. Can anyone help me? Here is a google drive link for my database:

https://drive.google.com/file/d/18QXoxauuxiuZSJEWVMq1dJpcRnZMO4-Y/view?usp=sharing

And here is the assignment :

Hike Appalachia Molly and Bailey Johnson use the Appalachia database to maintain and analyze data about the hikers, reservations, and tours for their hiking tour business. Youll help them by creating a form and a report in the Appalachia database. Additionally, youll troubleshoot some problems in another database containing tour information. Complete the following:

1. Open the Appalachia database you created and worked with in previous modules, and then click the Enable Content button next to the security warning, if necessary.

2. Use the Form Wizard to create a form containing a main form and a subform. Select all the fields from the Hiker table for the main form, and select all the fields except HikerID from the Reservation table for the subform. Use the Datasheet layout. Specify the title HikerReservations for the main form and the title ReservationSubform for the subform. 3. Apply the Integral theme to the HikerReservations form only. 4. Edit the form title so that it appears with a space between the two words. Change the font color of the title to the Dark Teal, Text 2, Darker 25 theme color.

5. Insert the Mountains picture, which is located in the Access1 > Case4 folder provided with your Data Files, in the HikerReservations form. Remove the picture from the control layout, and then move the picture to the right of the form title. Resize the picture so it is approximately double the original size.

6. Resize all columns in the subform to their best fit so that the subform column titles are fully displayed. Save the form.

7. Use the Find command to search for records that contain WV in the State field. Display the record for Sarah Peeler (HikerID 509), and then change the Phone field value for this record to 703-599-2043. Close the form.

8. Use the Report Wizard to create a report based on the primary Hiker table and the related Reservation table. Select all the fields from the Hiker table, and then select all the fields except HikerID from the Reservation table. Do not select any additional grouping levels, and sort the detail records in ascending order by ReservationID. Choose the Outline layout and Portrait orientation. Specify the title HikersAndReservations for the report.

9. Apply the Integral theme to the HikersAndReservations report only.

10. Edit the report title so that it appears as Hikers and Reservations; then change the font color of the title to the Dark Teal, Text 2, Darker 25?? theme color.

11. Left-align the Tour Date field label and field value box, then move the People field label and field value box to the left, to reduce the space between the Tour Date and People columns.

12. Insert the Mountains picture, which is located in the Access1 > Case4 folder provided with your Data Files, in the HikersAndReservations report. Move the picture to the right of the report title.

13. Apply conditional formatting so that any People field value greater than or equal to 3 appears as bold and with the Red color applied.

14. Preview the entire report to confirm that it is formatted correctly. If necessary, return to Layout view and make changes so that all field labels and field values are completely displayed.

15. Save the report, print its first page (only if asked by your instructor to do so), and then close the report. 16. Compact and repair the Appalachia 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

Advances In Databases And Information Systems 14th East European Conference Adbis 2010 Novi Sad Serbia September 2010 Proceedings Lncs 6295

Authors: Barbara Catania ,Mirjana Ivanovic ,Bernhard Thalheim

2010th Edition

3642155758, 978-3642155758

More Books

Students also viewed these Databases questions