Access 97 – Create Multiple Tables

In Access 97, I have a table, which contains the fields employee ID, employee name, project. Each employee can have multiple projects. I need an automated way to create a separate table for each employee and their projects. Is there a way to accomplish this using VB, or a make-table query? I am an Access newbie, so please be very detailed in your response. Thanks!