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 'LEFiles' 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:
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
Amt Paid Currency Format: standard
Payment# Firm# DatePaid AmtPaid
10031 1111 06/03/2001 2500.00
10002 1147 06/01/2001 1700.00
10015 1151 06/02/2001 2000.00