Does the Max result rows option in Tools > Options > Query tab being defaulted at 5000 limit the processing of any records?

In the Tools > Options > Query tab, the Max result rows option does not limit the processing of any function on your dataset. It only limits the number of rows in the data preview to ensure higher efficiency of the preview on design time.