Yes it is possible to handle such scenario with OpenAccess. The approach you should take though is to create a database VIEW which joins the columns from the different table that you want to present. You can map the view then to an entity as you would map a regular table. You can additionally create a partial class to the one generated by OpenAccess and add some properties that you can calculate out of the existing ones.
All the best,
the Telerik team