The accretion history of dark matter haloes - II. The connections with the mass power spectrum and the density profile