I got straight distinctions in Access to HE in Science, and whilst it was a bit challenging it was achievable.
Yes you can go into pharmacy with an Access course, but only some unis accept it and only for particular courses. I am not going through all of the approved pharmacy courses, so you would need to check the entry requirements for all of the pharmacy courses yourself:
https://www.pharmacyregulation.org/education/approved-providers-education-and-training/accredited-mpharm-degreesA standard Access in Science would have an even 15 credit split for each of the sciences: biology, chemistry, and physics. The good news is that you have covered most of the sciences at the basic level. The bad news is you are very likely going to need a top up if you intend to apply for specific courses outside of life sciences at top end uni.
For life sciences and healthcare, generally the Access course alone should be adequate for your needs. For subjects like physical sciences and engineering, you would definitely need Maths A Level on top and possibly Physics A Level (depending on the individual uni). That's assuming the uni accepts Access courses.
For specific degrees that are very quantitative or involes a lot of physics, they would likely straight up reject the Access course.
You can alternatively use the Access course as a substitute for 3 A Levels and apply for degree courses that accept A Levels in any subject e.g. law, business (other than finance), property, architecture, etc.