This database file should be saved as a zip file

Assignment Help Computer Engineering

Reference no: EM1336786

This database file must be saved as a zip file

Professional Litigation User Services (PLUS) is a company that creates all types of visual aids for judicial proceedings. Clients are usually private law firms, although the District Attorney's office has occasionally contracted for its services. PLUS creates graphs, maps, timetables, and charts, both for computerized presentations and in large-size form for presentations to juries. PLUS also creates videos, animations, presentation packages, and slide shows-in short, anything of a visual nature that can be used in a judicial proceeding to make, clarify, or support a point.

Raj Jawahir is responsible for tracking the daily payments received from PLUS clients. You'll help him maintain the Payments database by completing the following:

- Start Access and open the Payments database located in the LE2 Folder within the zip file.

- Create a table named Payment using the table design shown in Figure 1 (Hint: Make sure that you include spaces between components of the custom format for the Date Paid field.)

- Add the payment records shown in Figure 2 to the Payment table.

- Modify the structure of the Payment table by completing the following:

- Modify the structure of the Payment table by completing the following:
a.) Field Name: Deposit#
b.) Data Type: Tex
tc.) Field Size: 3

- Raj created a database named PlusPays that contains recent payments in the Payment Records table. The Payment table you created has the same format as the Payment Records table. Copy all the records from the Payment Records table in the PlusPays database (located in the zip file in the LE2 folder) to the end of your Payment table.

- Define a one-to-many relationship between the primary Firm table and the related Payment table. 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.

- 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?
Close the Firm Payments form. Make a screen shot for the search window with the search string you use

- 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.

Reference no: EM1336786

Questions Cloud

Explain the marketing mix : Explain The Marketing mix and What pricing strategy does Wal-Mart use and What pricing strategy does Wal-Mart use? How are they able to consistently generate higher profits

Explain why the factors are critical to competition : Dell, HP, IBM, and Microsoft are competitors of Apple. Describe why the factors are critical to competition. From the above factors explain if Apple is higher or lower than its competitors.

List of risks of procured or contracted work : Provide the list of risks related to the procured or contracted work.

Explanation of capital structure : How does the capital structure of a firm compare to the capital structure of an individual? In what ways are they similar?

This database file should be saved as a zip file : Professional Litigation User Services (PLUS) is a company that designs all types of visual aids for judicial proceedings. Clients are usually private law firms, although the District Attorney's office has occasionally contracted for its services.

Discuss the determinants of varying levels of income : Discuss the determinants of varying levels of income, the factors which determine a person's wages and if these qualifications always hold true.

Payout policy and capital structure for perpetual project : Suppose first that the project will be partly financed with $400,000 of debt and that the debt amount if it be fixed and perpetual. Then suppose that the initial borrowing will be increased or reduced in a proportion to changes in the market value ..

Give a full explanation as to why that statement is correct : Indicate whether every of the following statements is true or false, and explain why. If a statement is false or true, please give a full explanation as to why that statement is correct or not.

Logistics in warehousing and distribution : Discuss the explain the objectives of logistics in warehousing and distribution.

User Account

All Pages