title: Transistioning from Excel to Access - challenges in assigning/determining a Primary Key
body: <p>I am currently working on attempting to transition a large database of testing records from Excel to Access to allow for better relational analysis between different groups; however, with how our team completes tests the same tests are repeated on a cycle making it difficult to capture a unique ID - </p>
  
  <p>I have considered assigning one for each test but then realized the ID would still repeat when the test is ran again. I have considered using the timeframe of the review but that would also be repeated unless I build a separate table for each individual test. I have considered using the issue number that would be assigned to items requiring action, but this would not apply to all rows therefore access would not allow it.</p>
  
  <p>Within our current database we capture test name, type, timeframe reviewed, start and end dates, result types, descriptions and root cause, and issue identifiers if remediation is required. </p>
  
  <p>Does anyone have any suggestions on how I might transition this data into Access without losing the Primary Key feature on certain tables?</p>