Reference no: EM13754911
Case Problem:
Data File needed for this Case Problem: Rossi.accdb
Rossi Recycling Group Tom Rossi needs to modify some records in the Rossi database and then he wants to find specific information about the donors, agencies, and donations to his not-for-profit agency. Tom asks you to help him update the database and create queries. Complete the following:
1. Open the Rossi database located in the Access1 \Case3 folder, and then click the Enable Content button next to the Security Warning, if necessary.
2. In the Donor table, delete the record with DonorlD 36065. (Hint: Delete the related record first.) Close the table.
3. Create a query based on the Agency table that includes the Agency, FirstName, LastName, and City fields, in that order. Save the query as AgenciesByCity, and then run it.
4. Modify the AgenciesByCity query design so that it sorts records in ascending order first by City and then by Agency. Save and run the query.
5. In the AgenciesByCity query datasheet, change the contact for the Community Development agency to Beth Dayton. Close the query.
Attachment:- rossi database.rar
|
Prepare a capital expenditure budget
: If you were assigned to prepare a capital expenditure budget request to add a retail pharmacy in the hospital, which two individuals from your department(s) would you want to have on your team to help you? How would you utilize them to help you? J..
|
|
What led to growing nationalism in kenya
: What led to growing nationalism in kenya?
|
|
The evolution of computer technology
: Describe how concepts such as RISC, pipelining, cache memory, and virtual memory have evolved over the past 25 years to improve system performance.
|
|
Descriptions of the cost accounting system
: Write a 700- to 1,000-word paper identifying the specific cost accounting system an organization utilizes and how it uses the accounting information for financial management. Your paper must include the following:
|
|
Create a query based on the agency table
: Create a query based on the Agency table that includes the Agency, FirstName, LastName, and City fields, in that order. Save the query as AgenciesByCity, and then run it
|
|
Bond valuation questions
: XYZ Inc. bonds have a par value of $1,000, a 33 year maturity, and an annual coupon rate of 12.0% with annual coupon payments. The bonds are currently selling for $923. The bonds may be called in 4 years for 112.0% of par. What quoted annual rate ..
|
|
Explain the resulting impact to the business
: Discuss at least three reasons why you perceived the communication to be effective, and explain the resulting impact to the business.
|
|
What methods british government use to exercise thei power
: What methods did the British government use to exercise their power in the new world from 1754-1763?
|
|
Evaluate the progress
: Nick has a goal to pay his credit card balance in full by June 30. When he first wrote the goal in December, his balance was $2,500. It is now April, and he can pay all except $200. Evaluate his progress and describe the results in one to two sent..
|