Creating an access database

Assignment Help Data Structure & Algorithms
Reference no: EM1380711

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: EM1380711

Questions Cloud

Creating database for charity event : Your Project is to organize a charity event. You must use at least two events, one of which must be a Windows program such as Word, WordPad, or Paint.
Who loses also explain why : He was also obligated to deliver proceeds of sale to Witt also of course failed to do that. Park claimed that car was rightfully his. Witt argued that Park owned nothing because he never got title also because Witt never got his money. Who loses a..
Illustrate how international economy affects your planning : Illustrate how international economy affects your planning or operating decisions for good or service.
Illustrate what are risks also benefits of expanding disney : Illustrate what are risks also benefits of expanding Disney brand in new ways. Support your answers with a minimum of one source per question, no more than five years old.
Creating an access database : PLUS is a corporation that makes all types of visual aids for judicial proceedings. Customers are usually private law firms, although the District Attorney's office has occasionally contracted for its services.
Llustrate what does disney do best to connect with its core : llustrate what does Disney do best to connect with its core consumer. Support your answers with a minimum of one source per question.
Explain how you will resolve them : explain how you will resolve them. Also address any matters or requirements specific to your state. If there are none, state that.
Explain how easy was it to find specific occupation : Explain how easy was it to find specific occupation (Technical Management) you were looking for also explain how comprehensive was information provided about that occupation.
Designing asp.net assignment : Design an ASP.NET assignment with Visual Studio.NET 2005. Create an event handler that assigns the entry in the TextBox control to Label control's Text property when the consumer clicks the Button control.

Reviews

Write a Review

 

Data Structure & Algorithms Questions & Answers

  Write algorithm for program to compute the sum of number

Write an algorithm for a program which will satisfy following requirements: - Asks a user how many numbers they want to calculate.

  High bandwidth network for the multimedia team

Assume you have been assigned to build a network for a multimedia development company that currently uses a 10-Mbps Ethernet network. The corporation requires a high bandwidth network for multimedia team.

  Explain the concept of dns

Assume your job is to support desktop computers in a small corporation of 32 workers. A consulting company is setting up a private Web server to be used internally by company workers.

  Processor sharing to worse performance than fcfs

Create a second experiment answering the question "Is it possible for processor sharing to have worse performance than FCFS? "

  Explain sorting algorithm which is optimal in cost

Explain a sorting algorithm which is optimal with respect to this cost model and uses O(n) space. That is, time used by algorithm should exactly match lower bound

  Describe why full binary tree requires to have node

Describe why. Full binary tree requires to have a node with 0 or 2 children and complete tree have their child starting from left. Choose the one true statement. Every binary tree is either complete or full.

  Creating villian

Announce a new Villian called sharpay who has a wit of 24, a stealth of sixteen, and who has currently claimed three victims: Chad, Troy, and Gabriella.

  System administrators database, network and application

What methods would you use to effectively manage a team of system administrators database, network, application working in your data center?

  Discussion on data mining techniques

The tax authorities working for many governments are often confronted with challenge of detecting tax evasion and fraud. Suppose you work at income tax department.

  Discuss and define complex data binding

Discuss and define complex data binding and what benefits can this capability lend to a multiple table database application?

  Importance of database documentation

Assume your database is performing poorly, and you just started this new job within the past month. You ask to see the documentation for system and are told it does not exist.

  Algorithm on dynamic programming-minimize amount of walking

Our goal is to plan this trip so that we minimize the maximum amount of walking done in a single day. Your algorithm should be based on dynamic programming and run efficiently.

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