No. Earning a ADT guarantees you admission to the CSU system, but not a particular campus or major. The campus you will be admitted to depends on several factors, such as the location of your community college, the program of study that you intend to follow, and your competitiveness for admission.
Go to http://adegreewithaguarantee.com/Degrees.aspx to find out which CSU campuses offer a major or similar major related to each AA-T or AS-T.
This degree may not be the best option for you if you are intending to transfer to a particular CSU campus or to a university or college that is not part of the CSU system. You should consult with a counselor when planning to complete the degree for more information on university admission and transfer requirements.