On Your Own 19-2 Assignment Overview

The assignment is oyo19_2 given below

Student Data files used for this assignment:

• CharityLogo.png(To save, right click and save as)
• Contacts19.accdb
• Dontations19.accdb

The following are the minimal requirements to complete each homework assignment.

• Required course textbook
• Microsoft Office Suite 2013 (PC) or 2011 (Mac) software or more recent
• Windows Operating System: Windows 7 or more recent is recommended

Complete the weekly homework based on the following:

1. Complete the On Your Own project according to the project instructions and submit your assignment through the online course shell. Note: It is important to note that some On Your Own projects request a printed or self-submitted document. Students completing this course online or in a physical classroom must submit the assignment through the online course shell regardless of the textbook submission instructions.

2. Submit your assignment in the appropriate MS Office application using the filename "Last name_First initial_OYO#.htm". For example: if your name is Mary Smith, the file for the On Your Own project 9-1 should be saved as Smith_M_9-1.docx

3. Include a footer, which indicates the date and your course section.

4. Include a title page, which indicates your name, course section, professor name, and title of assignment.

5. Write a short answer for each On Your Own project. Submit the written portion in the text box located in the assignment submission link.

In your written portion, you must respond to the following:

a. Summarize the technical experiences in completing the On Your Own project in two to three sentences.

b. Identify the greatest skill learned in the assignment and how it will benefit you in the real world in two to three sentences.

c. Provide general comments on the overall assignment experience in two to three sentences.

Assignment: On Your Own 19-2

1. Open the data file Contacts19 located in the Chapter 19\On Your Own folder. Save the database as ContactsList19.

2. Use the Form Wizard to create a form based on the Property table. Select all the fields for the form and the Columnar layout. Specify the title PropertyInfo for the form.

3. Apply the Retrospect theme to the PropertyInfo form only.

4. Edit the form title so that it appears on one line as Property Information. (Hint: Increase the width of the title control on the form to display the title on one line.) Change the font color of the form title to the Orange, Accent 2 theme color.

5. Find the record with Room ID 3423, and then change the Room Name to your first and last names.

6. Change the line style for all the field value boxes on the PropertyInfo form to Transparent. (Hint: Select the Transparent line type.)

7. Change the text alignment for all the field value boxes on the PropertyInfo form to left. (Hint: Use the correct option in the Text Formatting group on the Home tab.)

8. Save and close the PropertyInfo form.

9. Use the Form Wizard to create a form containing a main form based on the Contacts table and a subform based on the Reservations table. Select the ContactID, ContactFirst, ContactLast, City, State, and Phone fields from the Contacts table, and the ReservationID, StartDate, EndDate, Guests, and Deposit fields from the Reservations table. Use the Datasheet layout. Specify the title ContactsAndReservations for the main form and ReservationsSubform for the subform.

10. Apply the Retrospect theme to the ContactsAndReservations form only. Then change the title on the main form to Contacts and Reservations and the Orange, Accent 2 color.

11. Navigate through the records in the main form, resizing the columns in the subform as necessary to their best fit. Make sure that all the field values in the subform are completely displayed.

12. Apply conditional formatting to the Deposit field so that field values that are less than $1,000 are formatted in bold. (Hint: Use the Conditional Formatting button in the Control Formatting group on the FORM LAYOUT TOOLS FORMAT tab.)

13. Save the form and then close it.

14. Use the Report Wizard to create a report based on the primary Contacts table and the related Reservations table. Select the ContactID, ContactFirst, ContactLast, and Phone fields from the Contacts table, and the ReservationID, StartDate, and EndDate fields from the Reservations table. Sort the detail records in ascending order by StartDate. Choose the Outline layout and Portrait orientation. Specify the title ContactsReservations for the report.

15. Apply the Retrospect theme to the ContactsReservations report only. Then change the report title to Contacts and their Reservations. Change the font color of the title text to the Orange, Accent 2 theme color.

16. Resize field labels and field value boxes as necessary to fully display their values, and then, if necessary, resize and move the page number so it appears within the page boundary for the report.

17. Format start dates that are on or after September 1, 2016 in a bold, Red font.

18. Preview the report to make sure that it is formatted correctly and all field labels and field values are fully visible. Save the report, print one page that shows the conditional formatting you applied, and then close the report.

19. Compact and repair the ContactsList19 database, and then close it.

Attachment:- Oyo19_2.rar