Toggle navigation
Home
Ask A Question
Answer Questions
Users
Support/FAQ
Login
Register
145MIS311AccessAssignment.docx
Details
Question Title:
Access Table (Management Information Systems)
View the Question
Preview - Click download on the question page for the full document.
<!DOCTYPE html PUBLIC "-//ABISOURCE//DTD XHTML plus AWML 2.2//EN" "http://www.abisource.com/2004/xhtml-awml/xhtml-awml.mod"><html xmlns="http://www.w3.org/1999/xhtml" xmlns:awml="http://www.abisource.com/2004/xhtml-awml/"> <head> <meta http-equiv="Content-Type" content="application/xhtml+xml; charset=UTF-8" /> <title> Abiword HTML Document </title> </head> <body> <div> <p style="text-align:justify;margin-bottom:5.000000pt;margin-top:5.000000pt"> <span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'">MIS 311 Fall 2017 /</span><span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman';text-decoration:underline">Access Assignment</span> </p> <p style="text-align:justify;margin-bottom:6.000000pt;margin-top:3.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">You work for a non-profit organization that accepts donations from individual donors and disseminates them through multiple agencies. Until now, data on donors, donations, and agencies used to be tracked in Excel files. Now, your manager asks you to create a database to store and process data.</span> </p> <p style="margin-bottom:6.000000pt"> <span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'">Instructıons</span> </p> <p style="text-align:justify;margin-bottom:6.000000pt;margin-top:3.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Create the database and name it</span><span style="font-weight:bold;font-style:italic;font-size:12pt;font-family:'Times New Roman'">XYZDonationsTeamX.accdb</span><span style="font-size:12pt;font-family:'Times New Roman'">. X should indicate the teammembers’ last names.</span><span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman';text-decoration:underline">Only the teammembers whose lastnames mentioned in the filename will get a grade.</span> </p> <p style="margin-bottom:6.000000pt;margin-top:3.000000pt"> <span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'">“Donor” table:</span> </p> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Import donor data from the Excel file and name the table Donor. During the import, make sure that the table has the proper primary key and the primary key is marked correctly such as Required Yes and Indexed / No duplicates (you can also modify that after transfer)</span> <p class="list_paragraph" style="text-align:justify;margin-bottom:6.000000pt;margin-top:3.000000pt;margin-left:18.000000pt" awml:style="List Paragraph"> </p> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Once you import the data from Excel, check the data type, mark the field properties as below:</span> <table border="0" cellpadding="0" style="width:100%;background-color:#4f81bd;border:1.00pt solid #4f81bd;border-collapse:collapse;empty-cells:show;table-layout:fixed"> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Field Name</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Data Type</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Field Size</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">DonorID</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Number</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Long Integer</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Title</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">S. Text</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">4</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">FirstName</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">S. Text</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">20</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">LastName</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">S. Text</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">25</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Phone</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">S. Text</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">14</span> </p> </td> </tr> </table> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Add a new field for YearofBirth that indicates the year part of the birthdate of the donor. Assign correct data type and field size. Enter date values.</span> <p style="margin-bottom:6.000000pt;margin-top:12.000000pt"> <span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'">“Agency” table:</span> </p> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Import agency data from the Excel file and name the table Agency. During the import, make sure that the table has the proper primary key and the primary key is marked correctly such</span> <a name="_GoBack"> </a> <span style="font-size:12pt;font-family:'Times New Roman'">as Required Yes and Indexed / No duplicates (you can also modify that after transfer)</span> <p class="list_paragraph" style="text-align:justify;margin-bottom:6.000000pt;margin-top:3.000000pt;margin-left:18.000000pt" awml:style="List Paragraph"> </p> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Once you import the data from Excel, check the data type, mark the field properties as below:</span> <table border="0" cellpadding="0" style="width:100%;background-color:#4f81bd;border:1.00pt solid #4f81bd;border-collapse:collapse;empty-cells:show;table-layout:fixed"> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Field Name</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Data Type</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Field Size</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">AgencyID</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">S. Text</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">3</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">AgencyName</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">S. Text</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">40</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">ContactFirstName</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">S. Text</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">20</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">ContactLastName</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">S. Text</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">25</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Address</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">S. Text</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">30</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">City</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">S. Text</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">24</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">State</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">S. Text</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">2</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Zip</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Number</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Long Integer</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Phone</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">S. Text</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">14</span> </p> </td> </tr> </table> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Add 2 new records (meaningful not xyz or abc) to the Agency table, and then save the table.</span> <p style="margin-bottom:6.000000pt;margin-top:12.000000pt"> <span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'"> “Donation” table:</span> </p> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Import donation data from the Excel file and name the table Donation. During the import, make sure that the table has the proper primary key and the primary key is marked correctly such as Required Yes and Indexed / No duplicates (you can also modify that after transfer)</span> <p class="list_paragraph" style="text-align:justify;margin-bottom:6.000000pt;margin-top:3.000000pt;margin-left:18.000000pt" awml:style="List Paragraph"> </p> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Once you import the data from Excel, check the data type, mark the field properties as below and note the foreign keys under description:</span> <table border="0" cellpadding="0" style="width:100%;background-color:#4f81bd;border:1.00pt solid #4f81bd;border-collapse:collapse;empty-cells:show;table-layout:fixed"> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Field Name</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Data Type</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Description</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Field Size</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Other</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">DonationID</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Number</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Long Integer</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">DonorID</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Number</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Long Integer</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">AgencyID</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">S. Text</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">3</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">DonationDate</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Date/Time</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Format: Short Date</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">DonationDescription</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Long Text</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">DonationValue</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Currency</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Format = Currency</span> </p> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Decimal Places = 2</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">PickupRequired</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Yes/No</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="text-align:center;margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Format = Yes/No</span> </p> </td> </tr> </table> <p style="margin-bottom:6.000000pt;margin-top:3.000000pt;margin-left:18.000000pt"> </p> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Add below records to the Donation table and save the table. (Hint: My date settings are MM/DD/YYYY. Yours might be DD/MM/YYYY or DD.MM.YYYY depending on how your machine was installed. Check your Access settings and enter data accordingly)</span> <table border="0" cellpadding="0" style="width:100%;background-color:#4f81bd;border:1.00pt solid #4f81bd;border-collapse:collapse;empty-cells:show;table-layout:fixed"> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Donation ID</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Donor ID</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Agency ID</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Donation Date</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Donation Description</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Donation Value</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Pickup Required</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">2217</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">36012</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">A82</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">12/25/2011</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Cash</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">50</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">YES</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">2222</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">36016</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">A64</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">11/11/2011</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Cash</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">35</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">YES</span> </p> </td> </tr> <tr> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">2300</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">36001</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">A82</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">1/31/2013</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">Cash</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">30</span> </p> </td> <td rowspan="" colspan="" style="padding: 0.00pt;background-color:#4f81bd;border:1.00pt solid #4f81bd"> <p style="margin-bottom:0.000000pt"> <span style="font-size:12pt;font-family:'Times New Roman'">NO</span> </p> </td> </tr> </table> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Define the relationships between Agency, Donor and Donation tables (Hint: You will set only two relationships and be careful about setting it correctly). Save the changes to the Relationships window.</span> <p style="margin-bottom:6.000000pt;margin-top:12.000000pt"> <span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'"> “Donations by Donor” query:</span> </p> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Create a list of donations by donors. Display the Donor ID, First Name, and Last Name of the donor, donation date, and donation value in this given order. Sort the query results first by the donor’s last name in ascending order, the donor’s first name in ascending order, and then the donation value from smallest to largest. Save the query as</span><span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'">Donations by Donor</span><span style="font-size:12pt;font-family:'Times New Roman'">.</span> <p style="margin-bottom:6.000000pt;margin-top:12.000000pt"> <span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'">“Large Cash Donations in Q1” query:</span> </p> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Create a list of donations that are in cash, value more than or equals to $60 and donated in the first quarter of 2010. Display the Donor ID, First Name, and Last Name of the donor, donation date and donation value in this given order. Save the query as</span><span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'">Large Cash Donations in Q1.</span> <p class="list_paragraph" style="margin-bottom:6.000000pt;margin-top:3.000000pt;margin-left:18.000000pt" awml:style="List Paragraph"> </p> <p class="list_paragraph" style="margin-bottom:6.000000pt;margin-top:3.000000pt;margin-left:18.000000pt" awml:style="List Paragraph"> </p> <p style="margin-bottom:6.000000pt;margin-top:12.000000pt"> <span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'"> “Clothes or Junction City Donations” query:</span> </p> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Create a list of donations of clothes or donations made in Junction City only. Display Donation ID, Donation Date, and Donation Description, Agency ID, Agency Name, City in this given order. Apply relevant criteria. Sort the query results first by City then by Donation Description in ascending order. Save the query as</span><span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'">Clothes or Junction City Donations.</span> <p style="margin-bottom:6.000000pt;margin-top:12.000000pt"> <span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'"> “Donation Statistics by Agency” query:</span> </p> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Create a list of donations by Agency. Display the sum, the average, the maximum and the count of donation value grouped by Agency Name that should appear as the first field. Rename the columns as Total Donations, Average Donation, Maximum Donation and Number of Donations. Sort the query results Total Donations in descending order. Save the query as</span><span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'">Donation Statistics by Agency.</span> <p style="margin-bottom:6.000000pt;margin-top:12.000000pt"> <span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'"> “Donors without Donations” query:</span> </p> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">You will call the registered donors who did not make any donation yet. (Hint: Identify donors in the Donor table who have no matching records in the Donation table.) Display the Donor ID, Title, First Name, Last Name, and Phone. Save the query as</span><span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'">Donors without Donations.</span><span style="font-size:12pt;font-family:'Times New Roman'"></span> <p style="margin-bottom:6.000000pt;margin-top:12.000000pt"> <span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'">“Donors and Donations Report” report:</span> </p> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Create a report of donations grouped by donors. Display the Title, First Name, and Last Name of the donor, and the Donation Date, Donation Value and Donation Description. Group on DonorID from smallest to largest. Show the sum of donation value for each donor at the group footer, and the grand total of donations at the report end. Do not show the date at the end of the report, but display page number at the end of each page. Insert a note (label) describing the report and the names of the team members (i.e. employees) who generated the report. Save the report as</span><span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'">Donors and Donations</span><span style="font-size:12pt;font-family:'Times New Roman'">.</span> <p style="margin-bottom:6.000000pt;margin-top:12.000000pt"> <span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'">“Agency Info” form:</span> </p> <span></span><span style="font-size:12pt;font-family:'Times New Roman'">Create a form to enter modify agency records. Insert date/time, one picture / logo / image, and a note indicating that the form was designed by x,y,z. Be creative to make the form more user friendly. Save the form as</span><span style="font-weight:bold;font-size:12pt;font-family:'Times New Roman'">Agency Info</span><span style="font-size:12pt;font-family:'Times New Roman'">.</span> <p style="text-align:center;margin-bottom:6.000000pt;margin-top:3.000000pt"> </p> <p style="margin-bottom:6.000000pt;margin-top:3.000000pt"> </p> <p class="footer" style="text-align:right" awml:style="footer"> </p> <p awml:style="footer"> <div> </div> <p class="footer" style="text-align:right" awml:style="footer"> </p> <p awml:style="footer"> </p> </p> </div> </body></html> ">
