Microsoft access: how would I go about selecting a primary key for this table si

Question

Microsoft access: how would I go about selecting a primary key for this table since none are unique. I'm new to access and have to do a case. Kitty Robert Duiuey Road Wal Tam 13484 5815 AIS Lane FFF Donation File Animal Contribut ID Donation Date Code Amount September 30, 2013 September 20, 2013 October 15, 2013 October 15, 2013 October 31, 2013 October 31, 2013 November 30, 2013 November 15, 2013 December 1, 2013 C D 25 125 25 10 20 20 250 25 70 100 250 500 150 100 100 100 100 50 13456 13456 13456 13456 13456 13456 13456 13456 13456 13480 13480 13480 13480 13484 13484 13484 13484 13484 September 10, 201 October 10, 2013 November 11, 2013 December 14, 2013 September 5, 2013 October 10, 2013 November 8, 2013 December 15, 2013 -20. Furry Friends Foun Friends Foundation II (Creating Queries for Da rinds oundation is a no

Explanation / Answer

Answer for question:

In Generally if we don't have the any row to be a primary key of given table.
we can choose the two rows become a primary key of the table.
even though the duplicate values are repeated.
Lest assume that Donnation_Time and Code can considered as a primary key for given table.

FFF_Donation_Table(Donnation_Time , Animal_Code Amount, Contribution_ID,
Primary Key(Donnation_Time, Animal_Code))

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---