Reference no: EM13948296
Professional Litigation User Services (PLUS) creates all types of visual aids for judicial proceedings. Raj Jawahir is working with the Payments database to track and analyze the payment history of PLUS clients. He again needs your help. He would like you to enhance the Payments database by completing the following:
Make a copy of the database called supporting database and use it for this.
Define a one-to-many relationship between the primary Firm table and the related Payment table. Use the Payments table you created in ysupporting database. Select the referential integrity option and both cascade options for the relationship.
Use the Form Wizard to create a form containing a main form and a subform. Select the Firm# and FirmName fields from the Firm table for the main form, and select all fields except Firm# from the Payment table for the subform. Use the Datasheet layout and the Industrial style. Specify the title, 'Firm Payments', for the main form and the title, 'Payment Subform', for the subform. Resize all columns in the subform to their best fit. Take a screen shot of the first main record and its displayed subform records.
For the form you just created, change the AutoFormat to Sandstone, save the changed form, and then take a screen shot of the first main form record and its displayed subform records.
Navigate to the second record in the subform for the first main record, and then change the AmtPaid field value to 1,800.00.
Use the Find command to move to the record with the Firm# 1142 and delete the record. Answer Yes to any warning messages about deleting the record.
Use the appropriate wildcard character to find all records with the abbreviation "DA" (for District Attorney) anywhere in the firm name. (Hint: You must enter the wildcard character before and after the text you are searching for.) How many records did you find? Which firms did you find and how did you arrive at your answer?
Close the Firm Payments form.
Use the Report Wizard to create a report based on the primary Firm table and the related Payment table. Select all fields from the Firm table except Extension, and select all fields from the Payment table except Firm#. In the third Report Wizard dialog box, specify the PLUSAcctRep field as an additional grouping level. Sort the detail records by AmtPaid in descending order. Choose the Block layout, Landscape orientation, and the Bold style for the report. Specify the title, 'Payments By Firms' for the report.
Use the Office Assistant to ask the following
question: "How do I move an object behind another?" Click the topic, "Move a text box or other control in front of or behind other controls." Read the information and then close the Help window. Make sure the PLUS picture is still selected, and then move it behind the Payments By Firms title.
Use the Office Assistant to ask the following question: "How do I change the background color of an object?" Click the topic, "Change the background color of a control or section." Read the information and then close the Help window and hid the Office Assistant. Select the Payments By Firms title object, and then change its background color to Transparent.
Attachment:- supporting database.zip
|
Use the appropriate parameters to pass information
: When creating this program please write the program so that the function main, in addition to the variable declaration, is merely a collection of function calls. Your program should use the following functions
|
|
Corrosion prevention measures
: Suggest an appropriate material for each of the following applications, and, if necessary, recommend corrosion prevention measures that should be taken. Justify your suggestions.
|
|
Prepare a perceptual map for your chosen product
: Identify the important attributes for your chosen product and select two key variables for your perceptual map. Prepare a perceptual map for your chosen product/brand and using a minimum of seven competitors, rank each product/brand on the two va..
|
|
Small businesses generally need more marketing
: Research the steps entrepreneurs on restricted marketing budgets can us to market their companies' products and services. Provide in-text citations for your sources.
|
|
Define a one-to-many relationship between tables
: Use the Find command to move to the record with the Firm# 1142 and delete the record. Answer Yes to any warning messages about deleting the record.
|
|
Identify a major consumer product and the company
: Select/ identify a major consumer product and the company that makes it. Provide a brief history of them both. (Select an existing publicly owned company. View the link Public Companies for a comprehensive list of publicly traded companies.) Ident..
|
|
What guidance do the accounting standards
: What guidance do the accounting standards and pronouncements provide to the CFO - how are relationships within a group determined?
|
|
Corrosion than noncold worked metals
: 2. Briefly explain why cold-worked metals are more susceptible to corrosion than noncold- worked metals. 3. Briefly explain why, for a small anode-to- cathode area ratio, the corrosion rate will be higher than for a large ratio.
|
|
Calculate the accounting rate of return for each project
: Calculate the accounting rate of return for each project the expected cash flows are the difference between cash revenues and cash expenses. Which project should be chosen based on the accounting rate of return?
|