Please see the attached file below. Thank you
Assessment Description: Please see the attached file below. Thank you
Page 1 of 1 Access Assignment You are the treasurer of the local drama club, and have begun to create a database of potential donors and volunteers for you r organization. You discovered that some donations have already been made, but the records are stored in an Excel workbook. You use your newly gained knowledge of Access to import an Excel spreadsheet and perform a basic query. Step Instructions 1 Start Access . Open the downloaded Access file named Access_ Assignment _D ataFile.accdb . Save the file as Access_Assignment_YourLa stName. 2 You will examine the data in the downloaded Excel worksheet to determine which field will become the primary key in the table and which field will become the foreign key so that you can join it to the existing table in the database. Click here to view how to create a table. Open the Donations.xlsx Excel workbook, examine the data, and close the workbook. You will import the Excel workbook that contains donation information into the database. Click the External Data tab , click New Data Source , point to From File in the Import & Link group, and th en select Excel . Navigate to and select the Donations.xlsx workbook to be imported as a new table in the current database. Ensure that First Row Contains Column Headings is selected. Set the DonationID field Indexed option to Yes (No Duplicates) . Select Do nationID as the primary key when prompted and accept the table name Donations . Do not save the import steps. 3 In Design View of the Donations table, change the Data Type of the DonationID field to Short Text in Design view of the Donations table. Set the Field Size of DonationID to 5. Set the Field Size of DonorID to Long Integer . Save the changes and switch back to Datasheet view. 4 Sort the records in the Donations table by the DonationAmount field in descending order. Save and close the table. 5 You will use the Simple Query Wizard to create a query of all donors who live in North Carolina. Learn more about creating queries . Add the Firstname , Lastname , Phone , and State fields from Donors (in that order). Save the query as Don or Volunteers . 6 Add a criterion in Design view to select only donors with NC in the State Field. 7 Sort the query results in ascending order by Lastname. Run, save, and close the query. 8 Close all database objects. Close the database, exit Access an d submit the database in the assignment.