Church attendance tracking

[Guest]

I have a table with a unique record for each member of our church. Right
now, we use a completely separate Excel sheet with a column for each Sunday
to track attendance. I would like to use access (so that the members list
updates automatically when we gain/lose someone). What's the best way to
track weekly attendance for a group of around 600 people?

 

[Ken Snell [MVP]]

Create a table (call it tblAttendance). It should have two fields:
PersonID
AttendDate

Each person is entered into one record for each date that they attend.