Microsoft access database: How can I add a field column from a form button?

I’m trying to create an daily attendance database with “Present”, “absent”, & “absent with apology” as the attendance field entries, that field should have the current date as the title,also is it possible to generate an excel worksheet report after seven days through a command button on a form?(attendance columns are the only changing fields) The other static fields in my table are “name” and “location”. Please help!