Good Afternoon Guy And Girls!

I am looking for some help regarding staff rotas and possible use of microsoft access or excel! i have self taught knowledge of both programs.
my partner is in charge of creating the staff rotas at work and they seem to be taking up alot of time, so i am wondering if there is a way i could help out by creating a spreadsheet that would auto fill staff into the days etc..

the problem that exists is that there are 6 staff in total, 5 staff are contracted to 10 x 24 hour shifts a month 1 staff contracted to 5 shifts, one of the full timers is not allowed to work with the part time staff! there has to be 2 staff on at all times!

if any one could shed any light on a way around this it would be of major help as it would free up alot of time that is currently wasted trying to do it manually!

i understand this is a big ask!! but any help would amazing!!

thanks
rob