Build a MS Access Daily Report Generator

want to have master database for daily report, and give ability for several team members to log into it
select his dept.
fill his daily report
submit
i want the database to be able to generate sequential report number, one is global and one is related to project or date related report number.
i need to have the database file open for edit later on