Navigate through the records in the main form

Assignment Help Computer Engineering

Reference no: EM131275272

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

Reference no: EM131275272

Questions Cloud

Write about the arguments that socrates makes : Write about the arguments that Socrates makes, what you think of them and why. around 2 to 3 pages (pt.12)

Define the various methodologies for sociological research : Define the various methodologies for sociological research. Identify the sociological perspective to the inequalities of class, race, gender, ethnicity, sexual orientation, socioeconomics, and political aspects.

The story of anvil : Watched the flim ( Anvil ! The story of Anvil) then have the following requirement :

Working on was successful : After the upgrade you had been working on was successful, you determined that you need to install a new plug-and-play printer on a user's computer. The printer uses a USB port interface. You connect the printer to the computer and turn the printer..

Navigate through the records in the main form : 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.

Computers and troubleshoot problems : Discuss the following and remember we're learning how to work on computers and troubleshoot problems. We are the computer experts. There's no one for us to call, we are the ones people call! Don't rest until you have a thorough paragraph that show..

Determine the strain-hardening exponent for the metal : Define the following terms: strain-hardening exponent (n), strain-rate sensitivity (m), and plastic strain ratio (r). Use appropriate equations.

How the ad is expected to motivate them : Your task is to describe and then analyze the ad, explaining what audience is anticipated and how the ad is expected to motivate them.

Concept of strategic alignment : The introduction to ISO 27002:2005 includes this statement: "This International Standard may be regarded as a starting point for developing organization-specific guidelines. Not all of the controls and guidance in this code of practice may be appl..

User Account

All Pages