Split table (msaccess)
I've been asked to help optimize an access database.
Problem is, they've been double-registering for a long time now.
It's the database for a sponsorship program, where people in this country can "adopt" a child in the third world and give financial support.
Well... As of now, everything is stored in one table, but I want to split it up so that the information about the people here is stored in one table and the information about the children in another.
That way they don't have to double-register if one person supports several children.
Are there tools to do this effectively, or will they have to do everything manually?