Where to put the connection string

I used the Access 2010 upsizing wizard to upload the tables from an Access database to SQL 2008. I believe that I understand the connection string, but I don't know how to apply it. Is it a function in the autoexec macro of the database frontend?

Thanks.