Reference no: EM13950435
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:
a.) Field Name: Deposit#
b.) Data Type: Textc.) Field Size: 3
Move the DatePaid field so that it follows the AmtPaid field.
Use the Payment datasheet to update the database as follows: Enter these Deposit# values for the three records:
a.) 101 for Payment# 10002
b.) 102 for Payment# 10015
c.) 103 for Payment# 10031
Add a record to the Payment datasheet with these field values:
a.) Payment#: 10105
b.) Deposit#: 117
c.) Firm#: 1103
d.) AmtPaid: 1750.00
e.) DatePaid: 06/20/2001
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 'LEFiles' zip file in the LE2 folder) to the end of your Payment table.
Use the Access Help system to learn how to resize datasheet columns to fit the data, and then resize all columns in the datasheet for the Payment table.
For Payment# 10002, change the AmtPaid value to 1300.00.
Delete the record for Payment# 10096.
Take a screen shot of the first page of data from the Payment table datasheet, and then save and close the table.
Now answer the following questions:
Do you see a potential problem with the Deposit# field? If so, describe it.
What business assumptions were made to define this table?
Combine your answers and your screen shot into a Word document
|
Field name
|
Data Type
|
Description
|
Field size
|
Other Properties
|
|
Payment#
|
Text
|
Primary
|
5
|
|
|
Firm#
|
Text
|
Foreign
|
4
|
|
|
Date Paid
|
Date/Time
|
|
|
Format: mmm dd yyyy
|
|
Amount paid
|
Currency
|
|
|
Format: standard
|
|
Payment
|
Firm
|
Date paid
|
Amount paid
|
|
|
10031
|
1111
|
06/03/2001
|
2500.00
|
|
|
10002
|
1147
|
06/01/2001
|
1700.00
|
|
|
10015
|
1151
|
06/02/2001
|
2000.00
|
|
|
|
|
|
|
|
|
Determine the effect on current income of debt restructuring
: Prepare a schedule that determines the effect on current income of the debt restructuring and the reduction in par value of the common stock necessary to eliminate any de?cit in retained earnings.
|
|
Principles of thermodynamics
: Ways to run cars on water are frequently touted on the Internet. For each of two different such proposals, write a three-page evaluation. In each evaluation, clearly state the claims made in the proposal.
|
|
Management theories-principles into management practices
: In the first assignment, students are given a scenario in which the shipping manager who has worked for Recycled Furnishings since the inception of the company is getting ready to retire. The scenario serves to set the stage for students to demon..
|
|
Measure of the departure of the state of a system
: Answer the following true or false. Explain. (a) Exergy is a measure of the departure of the state of a system from that of the exergy reference environment.
|
|
What business assumptions were made to define this table
: Use the Access Help system to learn how to resize datasheet columns to fit the data, and then resize all columns in the datasheet for the Payment table.
|
|
Solve for steady-state capital per worker
: If the saving rate (s) is 0.4, find capital per worker, production per worker, andconsumption per worker in the steady state. Solve for steady-state capital per worker, production per worker, and consumption perworker with s = 0.6. Solve for steady-s..
|
|
Determine the total gain resulting from the forgiveness
: Prepare a schedule to determine the total gain resulting from the forgiveness and restructuring of debt and the amount of future interest expense assuming (a) a nonbankruptcy approach and (b) a bankruptcy approach to the reorganization.
|
|
Determine the total quarterly cash out?ows
: Determine the total quarterly cash out?ows that will be required by Peltzer's debt restructuring. prepare a schedule that compares the effect on Peltzer's net income of accounting for the restructuring.
|
|
Interviewing and then analyzing and writing up results
: As noted in the syllabus, one of the important class requirements is the Interview Project. You can learn more about our topic and gain skill in interviewing and then analyzing and writing up results. This also is an opportunity to work with an..
|