Modify the structure of the payment table

Assignment Help Database Management System
Reference no: EM13948306

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

c.) 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: EM13948306

Questions Cloud

What are the key communication issues in global business : Produce a report on the use of communication techniques in a contemporary international service organisation -How are we using communication technologies in business organisations today and what are the key communication issues in global business?
Market research for a new product : Case - TruEarth Healthy Foods: Market Research for a New Product Introduction. This is a case write up. You need to read the case frist. And in the write up, you need to answer the following question. What do you recommend and why
Burgers vector-dislocation line orientations : 1. Cite the relative Burgers vector-dislocation line orientations for edge, screw, and mixed dislocations. 2. For an FCC single crystal, would you expect the surface energy for a (100) plane to be greater or less than that for a (111) plane? Why? (..
Articles attached about managerial economics : This week's paper is required to be approximately 4 -6 pages in length, not including the title page and the reference page. No paper should be fewer than 1400 words.
Modify the structure of the payment table : 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.
Consistently gave promotions and bonuses to managers : From the 1930s through the mid-1980s, General Motors consistently gave promotions and bonuses to managers who kept a low profile and avoided controversy. This is an example of which of the following organizational constraints?
Calculate the unit cell edge length : Calculate the unit cell edge length  for an 80 wt% Ag-20 wt% Pd alloy. All of the palladium is in solid solution, the crystal structure for this alloy is FCC, and the room temperature density of Pd is 12.02 g/cm3.
Give a brief definition of sequential file processing. : Develop an example to illustrate your definition. (The example does not have to be as elaborate. Just a record with a simple explanation)
Identify the type of products or services company provides : Describe the company you chose (give an overview/history). Examine the company's core business/industry (also identify trends) and Identify the type of products or services the company provides (describe the problems these products/services solve)

Reviews

Write a Review

 

Database Management System Questions & Answers

  Design an relational model model of a database

Design an Relational Model (RM) model of a database (DB) that will be useful for each of the chosen enterprises. (Hint: You may choose to translate the 2 ER model designs you created ).

  Write a program that uses the xml file from par display name

Write a program that uses the XML file from par (a) to display the names, states, and party affiliation of all the senators in the DataGridView in order by state. The two senators from each state should be in order by their first names.

  How to design and create tables

Databases are powerful tools for storing, managing, manipulating, and accessing data. Most information systems in use today make use of some form of database. In this lesson you will learn about the Access user interface (UI), how to design and ..

  Create a dtd file and an xsd file that specify the schemas

Create an XML file that describes 3 product elements; each product has three sub-elements: id, name, and description.

  Develop an eer model for the given situation

Develop an EER model for the following situation, using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation.

  Write steps to follow to create the relational database

Write down short description of database connectivity with Internet using one of widely disseminated technologies. (that is using either active server pages or Java server pages or others).

  Create a new table named sportinggoods in database

Create a new table named SportingGoods to contain the columns PartNum, Description, OhHand, Warehouse, and Priced for all rows in which the item class is SG.

  Aspects of tablespace management

Respond to the following in 100 words or less.  Work must be cited.

  Identify potential sales and department store transactions

Identify the potential sales and department store transactions that can be stored within the database. Design a database solution and the potential business rules that could be used to house the sales transactions of the department store

  What kind of information will be included in the database

To design a database, a database planner should spend a considerable amount of time thinking about what kind of information will be included in the database and how it will be organized. There are several approaches to creating a successful datab

  Examine a query written against the database

Examine a query written against the database. You will examine the entity/relationship diagram (ERD) and in writing explain what information the database is holding (not the specific data, but in words what the business application is and how that ..

  What are some reasons for studying file systems

What are the advantages of having the DBMS between the end user's applications and the database?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd