If you look on Bing Streetside you can see there Trenham Avenue joins Tyefields by crossing the footway of Tyefields. There is a give way before the footway. An example of an OSM continous crossing?

https://www.bing.com/maps?&cp=51.575797~0.515389&lvl=19.83&dir=213.16301&pi=-25.197578&style=x&v=2&sV=2&form=S00027

access=no is rarely correct. It means the road exists but there is not access along it, for anything. That means no private access, and pedestrian access.