I think you still need work on the table structure to get it in 3NF.
Really??? The client doesn't think they have intelligent people working for them???
Well, it is possible that you could get it on one form by using subforms in multiple tabs. One tab w/subform for check in/out, one tab w/subform for archiving, one tab w/subform for LT archiving, one tab w/subform for destruction. I still think these are all "events" and should be in one table, but ..... (my $0.02
)
Also, there are 5 tables with a field named "ID" .... gets confusing when creating queries. I make the PK (as much as possible) include the table name, like the checkout table.