What is the relationship between net force and acceleration based on the situation?