Why can't i change the header and footer that access automatically applies to
any data sheet I print?
"data sheet" as in Query datasheet or Table datasheet?
Tables and queries have very little user changeable properties.
Don't print tables or queries.
Create a report, laid out however you wish, with the table/query as
record source.
You now have full control over the report's headers and footers.