Question: For our project, the group use Microsoft Access. The VBA class is capability limited. How can VBA class be made to support inheritance?

Answer: 
In short, you can't. Although you can do 'mock' inheritance through the use of the Implements keyword - a bit like an Interface in .Net.
VBA is a *scripting language*, not a fully featured *programming language*! It was never designed to support such things like inheritance, this is far beyond its intended scope. Rather, it is intended to be an automation client, that can invoke binary components (which in turn are written using a 'real' development system like e.g. C, C++, C#, VB.NET, Delphi) thru' a COM interface.