1. Members (Relevant chapters - Access 1-2)
a. Import your data from the Members spreadsheet into a new Access database table named Members.
b. Be sure to add a primary key-a field that will uniquely identify each member. Remember that you must not use names or information that could potentially be repeated as a primary key.
c. Create a second table that will house the donations from each member. Identify an appropriate field to exist in both tables that will serve as a commonfield.
d. Create a relationship between your 2 tables. Resolve any potential errors in your database design at this point.
e. Add data to the new Donations table. Include at least 30 donations and ensure that some members have multiple donations entered.