My CC doesn't offer some of major prep courses I need to transfer. What should I do?

I am currently planning on transferring to Cal State San Bernardino for their Information Systems & Technology degree. The community college ( college of the desert) in my local area is missing a few computer classes that I need. I have been frantically trying to find colleges that offer these classes by taking a few of them online across different community colleges, but I am currently still missing one class. My major is not impacted, but I am still worried that I will get rejected for not completing all major requirements. My GPA is at a 2.85 and CSUSB is considered a local school from my location.
Any help will be greatly appreciated, Thanks.

According to http://www.assist.org/web-assist/reportOnly.do?agreement=aa&reportPath=REPORT_2&reportScript=Rep2.pl&event=19&dir=1&rinst=left&EM=1&sia=DESERT&ia=DESERT&ria=CSUSB&oia=CSUSB&ay=16-17&dora=ADMN=BA , the missing CSUSB course is IST 215, plus at least one of IST 274, 275, 276.

IST 215 = CIT 160 at San Bernardino Valley College
IST 274 = CSIS 214 at Mt. San Jacinto College
IST 275 = CSIS 202 at Mt. San Jacinto College
IST 276 = CS 80 at Copper Mountain College or CSIS 201 at Mt. San Jacinto College

However, these other colleges are a significant distance away.

You may want to ask CSUSB if the absence of the course at your CotD is a problem for admission. In most cases, transfer students are admitted if they are missing prerequisites which are unavailable at their CCs, but they need to take those courses after transfer to “catch up”.

Thank you for taking the time to read this.The link you have sent me is for their Administration degree. I am seeking an Information and Technology degree which is this:

http://web2.assist.org/web-assist/report.do?agreement=aa&reportPath=REPORT_2&reportScript=Rep2.pl&event=19&dir=1&sia=DESERT&ria=CSUSB&ia=DESERT&oia=CSUSB&aay=16-17&ay=16-17&dora=INF+SYS
I am actually taking 202 at Mt. San Jacinto College. It is an online course. I tried to find the 214 but they are not offering it this semester. I did get a chance to talk to a representative and they said it was totally okay since I got to College of the Desert because their Information Systems department is lacking and that Information Systems is not an impacted major at CSUSB.

If anyone is reading this, I was accepted 3 days ago.