access queries

Good morning 

I need assistance , 

Need to create a table in access which is based on  a other table with field as project start date and end date. 

e.g. project start and end date (plus minus 4 months total duration

Table for audit schedule needs to be based on the start date and end date  (1 audit per month for the duration)