What is an obvious reason why Visual Basic for Application not evolved into vb.net type programming syntax or environment?
Because very little object referencing is needed when programming within an MS office application because so much is already built-in, and secondly to keep things simple for all those who already know VBA and are not seeking to be big time programmers.
Unlike SQL written in large robust databases, the MS Access database engine allows for data to be updated directly from within a select query, true or false?
True
Name one of the foremost 'inconvenient truth's' in coming up with an efficient data model for a relational database?
One of the most inconvenient truths in building an efficient data model lies in coming up with tables that will need to be kept denormalized. Those tables that are used the most will need to be incorporated into the model so that their access takes up the least amount of resources. A database is sluggish when information obtained most often, and by most people, causes a choke hold on the system.