СУБД MS Access

 General characteristic MS Access

Microsoft Access now is one of the most popular among desktop program control systems of databases. Among the reasons of such popularity it is necessary to note:

• High degree of universality and reasonableness of the interface which is calculated on work with users of the most various qualification. In particular, the control system of objects of the database is realized, allowing flexibly and operatively to pass from a mode of designing in a mode of their direct operation
• Deeply developed opportunities of integration with other software products which are a part Microsoft Office, and also with any software products supporting(maintaining) technology OLE
• Rich set of visual means of development

It is obvious, that a starting point during work with any is creation of a file (or groups of files) databases.

Start

• Start is carried out Start-up - Programs - Мicrosoft Access
• To execute a command the File - To create

On the screen there will be a window after creation of new base. The basic sections of the main window correspond to types of objects which database Access can contain. These are Tables, Inquiries, Reports, Macros and Modules. The heading of a window contains a name of a file of a database. In this case it refers to TradeTest.

The interface of work with objects of a database is unified. On each of them standard operating modes are stipulated:

• To create - it is intended for creation of structure of objects
• The designer - is intended for change of structure of objects
• To open - is intended for work with objects of a database

The important means facilitating work with Access for beginning users, masters - the special program superstructures intended for creation of objects of a database in a mode of consecutive dialogue are. For the skilled and advanced users there are opportunities of more flexible resource management and opportunities of objects in a mode of the designer.

Specific feature Access is that the information concerning one database, is stored in a uniform file.

Such file has expansion *.mdb. The given decision, as a rule, is convenient for nonprofessional users as provides simplicity at carry of data from one workplace on another. The internal data structure within the limits of mdl a format varied from the version to the version, but firm Microsoft supported their its capacity from below upwards, that is databases in a format of early beliefs these Access can be converted from files in a format used in versions боле late.

 

The author: Y.N.Antonov Is added: 18.06.2008