Thank you for your post.
You may want to look at the "Lending Library" template. Pull down the File menu and select "New Database...". On the right side are a list of available templates. Select "Lending Library", and this should give you a good start.
Yes, you can archive the records. One of your tabs could have a relationship into a table based on not the current date. Needless to say, you can have a tab with a relationship that only shows todays date. With this latter relationship/tab, you can use a calculation field to sum the records (for today).
I have also sent you a private message (top of this page - right side - X Messages).