Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

4512 jamesford dr jamestown nc

17/11/2021 Client: muhammad11 Deadline: 2 Day

Management Information System And App

Capstone Exercise

The Morris Arboretum in Chestnut Hill, Pennsylvania, tracks donors in Excel. They also use Excel to store a list of plants in stock. As donors contribute funds to the Arboretum, they-can elect to receive a plant gift from the Arboretum. These plants are both rare plants and hard-to-find old favorites, and they are part of the annual appeal and membership drive to benefit the Arboretum's programs. The organization has grown, and the files are too large and ineffi- cient to handle in Excel. Your task will be to begin the conversion of the files front Excel to Access.

Create a New Database You need to examine the data in the Excel worksheets to determine which fields will become the primary keys in each table and which fields will become the foreign keys. Primary and foreign keys are used to form the relationships between tables.

a. Open the a02c1Donors Excel workbook.

b. Open the a02c1Plants Excel workbook.

C. Examine the data in each worksheet and identify the col- umn that will become the primary key in an Access table. Identify the foreign keys in each table.

d. Create a new, blank database named a02c1Arbor_ LastFirst.

Create a New Table Use the new blank table created automatically by Access to hold the donations as they are received from the donors.

a. Switch to Design view and save the table as Donations.

b. Add the remaining field names in Design view. Note: The data for this table will be added later in this exercise.

• Change ID to DonationID with the AutoNurnber Data Type.

• Add DonorID (a foreign key) with the Number Data Type and a field size of Long Integer.

• Add PlantID (a foreign key) as Number Data and a field size of Long Integer.

• Enter two additional fields with an appropriate data type and field properties. Hint: You need the date of donation and the amount of donation.

c. Verify the primary key is DonationID.

d. Save the table. Close the table.

Import Data from Excel You need to use the Import Spreadsheet Data Wizard twice to import a worksheet from each Excel workbook into Access. You

need to select the worksheets, specify the primary keys, set the indexing option, and name the newly imported tables (see Figures 2.12 through 2.17).

a. Click the EXTERNAL DATA tab and click Excel in the Import & Link group.

b. Locate and select the a02c1Donors workbook

c. Set the DonorID field Indexed option to Yea (No Duplicates).

d. Select DonorID as the primary key when prompted.

e. Accept the table name Donors.

f. Import the a02c1Plants file, set the ID Held as the pri- mary key, and then change the indexing option to Yes (No Duplicates).

g. Accept the table name Plants.

Ii. Open each table in Datasheet view to examine the data.

I. Change the ID field name in the Plants table to PlantID.

CreataRelationships You need to create the relationships between the tables using the Relationships window. Identify the primary key fields in each table and connect them with their foreign key counterparts in related tables. Enforce referential integrity and cascade and update related fields.

a. Open the Donors table in Design view and change the Field Size property for DonorID to Long Integer so it matches the Field Size property of DonorID in the Donations table.

b. Open the Plants table in Design view and change the Field Size property for PlantID to Long Integer so it matches the Field Size property for PlantID in the Donations table.

C. Close the open tables and open the Relationships win- dow.

d. Add the three tables to the Relationships window using the Show Table dialog box. Close the Show Tables dialog box.

e. Drag the DonorlD field in the Donors table onto the DonorID field in the Donations table. Enforce referential integrity and cascade and update related fields. Drag the PlantID field from the Plants table onto the Nunn) field of the Donations table. Enforce referential integrity and check the Cascade Update Related Fields option.

f. Close the Relationships window and save your changes.

Nair,

742 CHAPTER 2 • Capstone Exercise

Page 1

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Solution Provider
Supreme Essay Writer
Top Writing Guru
Study Master
Top Academic Tutor
Homework Master
Writer Writer Name Offer Chat
Solution Provider

ONLINE

Solution Provider

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$43 Chat With Writer
Supreme Essay Writer

ONLINE

Supreme Essay Writer

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$32 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$31 Chat With Writer
Study Master

ONLINE

Study Master

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$46 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$34 Chat With Writer
Homework Master

ONLINE

Homework Master

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$22 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Achilles trade price taxi supplier - Apa code of ethics psychology - Are hidden lines shown in a section view - Liberating education consists in acts of cognition - Business - Who started the ehr mandate - Oswego case study answers - Ancient history past papers - Whoso list to hunt - Rhapsody on a windy night techniques - Statistics Excel: Week 4 - Dead poets society scene analysis - Block Chain Development discussion 6b - The magnitude of the electric current is directly proportional to the _____ of the electric field. - Theme of blindness in the great gatsby - English language igcse paper 2 - A primary rationale for utilizing qualitative designs in the field of counseling is - HN522 Discussion 3 - Workers performing similar work are paid more in some industries than others. Explain why this is so. - Barkers chemist raynes park - English 2 - Homework help - There will come soft rains questions and answers pdf - Self report altruism scale - Custom units in excel - Ana scope and standards of practice apa citation - Aig’s ceo, edward liddy, demonstrated his lack of personal commitment to high ethical standards by - Homework america history 2 - Chapter 7 their eyes were watching god - Rasmussen college algebra - 11 smith place mount annan - Ms project cash flow report - Lithium fluoride dot and cross diagram - Topic 3 thread 1&2 - Order 2470891: Electrical Safety in the Perioperative Environment - Snap on krl722 accessories - Discussion needed by friday @ 6pm - 8 step model for ethical decision making - Counseling with choice theory the new reality therapy william glasser - Five primary revenue models used by e commerce firms - Psychology test - How to improve employee turnover rate in capsim - Australian cultural orientation program - CASE 3-TRANSFER PRICING AND RESPONSIBILITY CENTERS - What are the components of a relational database - Economists normally assume people's preferences should be - Total annihilation unit limit - Bsbfim601 task 1 - How to make a hot pack with calcium chloride - Pakistan flag hoisted in kerala - Windshield survey - Chem syllabus year 11 - 16x 35 7x 8 - Net ionic equation agno3 nacl - Bfmcx - Fair is foul and foul is fair literary technique - Assignment - Why is salr less than dalr - Compare mendelian and non mendelian inheritance - Compare and contrast servant leadership and followership - The boisterous sea of liberty pdf - Ethics - Parasitic load test car - Dis 7 - Capitol technology university tuition - Gsma sas certification list - Gattaca biology questions and answers - Why are books compared to birds in fahrenheit 451 - Billionaire card game kmart - Figurative language poster project - Visio 2010 uml stencil - Bi6 assignment - Request Refusal: Rising Phoenix Team Sinks Application - Strategic decisions are often useful examples of __________ decisions. - Balancing chemical equations phet - Theory tree social work - Chisholm human freedom and the self summary - Clinical outcomes variable scale - Discussion - Dallas world aquarium internship - Flowol 4 lesson plans - How to make a forest in a shoebox - 4.5 9 distance in kilometers codehs - Watchmen discussion questions - Broader view of corporate responsibility - Hunter united employees credit union - Events that make a conflict more difficult are called - Balance chemical equations worksheet - I like my baby heir with baby hair and afros - Entrepreneurial lifetime reward sims 4 - Our fear of immigrants questions and answers - MK405 Unit 4 Discussion - Factors affecting t1 relaxation time - The Era of Reconstruction,1865–1877 - Real insight marketplace - Discuss , why there has been a marked increase in the road accidents in developing countries in the recent years - Modish mist leave in treatment - Nsw biology stage 6 syllabus - Jay z song cry live jaguar wright - Weka association rules example