Any ideas what should i do with importing a huge excel spreadsheet to access database

[tep186]

I doing a side project at work and I need some ideas on what I can do. I'm just an intern so I don't have much experience with Access. I have a huge excel spreadsheet that needs to be an access database. I imported into an Access table with the following fields:

SS
Term Date
Name
Destroy Date (Needs to be Function using Term Date). At least help me with this.
Connex Box

This table is used archive former employee files, add date when to destroy the [Destroy Date] which is the 30 years after the term date in which I need a function and the connex box is where the physical file is located. I thought about making the SS (social sec num) an primary key but I can't because there can multiple records with same social due to different termination dates for one employee. I don't if I making sense lol.

I need to be able to do this with database.
Edit and Sort by Decade
Condition. Formatting for Duplicates social sec. names


Connex Boxes are inputted later
Must be able to search for each duplicates file.
Able to undo deleting records.

[June7]

There is no "undo deleting records" in Access. Deleted record is gone. What you can do is have a field to mark record as Active/Inactive or have a date/time field for DateArchived or DateDestroyed, etc.

The search and filtering you listed can be accomplished with various queries.

Input data into Connex Boxes whenever you want.