The DBMS concepts we have studied are well-illustrated in Access and all of the important functions are implemented. Technically speaking, Access is simply a user interface to the JET Database Engine . It is a quite adequate interface to most of the underlying JET capability. This enables developers to access data definition functions without having to deal directly with a data definition language. Access's GUI also gives users a friendly interface to the database so they do not need to use a data manipulation language directly.
Access does have limitations in producing very customized applications.
More sophisticated developers will require a more general purpose tool such as Visual Basic to produce customized user interfaces to Access databases. An understanding of these components and their use is essential is designing good database applications. Here is a list of these components.