Essentially you are correct, it will check for the prerequisite on the target machine and if not present will download and install it ... but you have to specify where to find the installer.
See this
TechNet blog[
^] for a walk through of how to check for, and if necessary install, sql server express with your application.
and the
msdn reference[
^]