What is the relationship between significance tests of regression coefficients and of correlation coefficients?

(Multiple) regression coefficients

Standardised regression coefficitnes

Partial regression coefficients

Correlation

Part correlation

Semi-partial correlation