Services Provided by the Microsoft Jet Database Engine

Microsoft Jet provides a variety of database management services, including data definition, data manipulation, data integrity, and security. There are seven basic services that a DBMS should provide. This section introduces these services and shows how Microsoft Jet accomplishes each one. The seven basic functions of a DBMS are:

• Data definition and integrity: create and modify structures for holding data, such as tables and fields, and ensure that rules to prevent data corruption from invalid entries or operations are applied to data operations.
  
  
• Data storage: store data in the file system.
  
  
• Data manipulation: add new data, modify or delete existing data.
  
  
• Data retrieval: retrieve data from the system.
  
  
• Security: control users’ access to database objects and data, thereby protecting the objects and data against unauthorized use.
  
  
• Data sharing: share data in a multiuser environment.
  
  
• Database maintenance: compact, repair, and convert data and database objects.