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.