Create an Access Database

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  HYPERLINK
"https://mycampus.aiu-online.com/courses/ITD320/Assignment_Assets/1_u3ip
s.zip" \t "_blank" 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
HYPERLINK
"https://mycampus.aiu-online.com/courses/ITD320/Assignment_Assets/1_u3ip
s.zip" 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.

Display the report in Print Preview.

Figure 1

Field Name Data Type Description Field Size Other Properties

Payment# text primary 5  

Firm# text foreign 4  

DatePaid date/time     format: mmm dd yyyy (custom format)

AmtPaid currency     format: standard

Figure 2

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