Will the fuel pump relay keep a 2006 Honda Accord not crank over?

No, the engine will turn over it just will not start because it will be getting no fuel as the pump is not running.