Современная цивилизация остро нуждается в permanent processing and saving large amounts of different data. Also, there is a constant need to monitor the impact of their changes on other information arrays. It is most convenient to organize all these processes in the form of a database. A popular tool for such an organization can become a popular Access DBMS program.
Various data are accepted to be presented and stored inform of tables. It often happens that in several tables there is information that is related to each other in some way. The collection of such interdependent tables is a database.
Для того чтобы имеет возможность в полной мере Operate data from the database, you must also execute queries. And in order to facilitate the filling of the database with the initial information, usually specially developed forms are used. To automate the process, in some cases you have to additionally apply macros. The combination of the database and additional tools forms a system called a DBMS, a database management system. An example can be Foxpro, Oracle, Microsoft Access.
Main functions of the DBMS
The Access DBMS performs the following important functions:
- implementation of necessary actions with data and formulas;
- establishing links between tables and data sets;
- Ability to add requests.
The entire set of tools thatis available in the MS Access database, it is intended for full-fledged servicing of two main directions during the operation of the information system. This is the organization of designing and modifying the structure of the database and various necessary manipulations with the data.
From many other management systems thatused by programmers to automate the work with databases, the Access database is easy to learn. Since this platform is Russified, and also has a standard for all programs of MS Office interface, even inexperienced users will not feel any inconvenience during its development.
At the same time, Access is a full-fledgeda program for managing data sets with all necessary attributes. The created system can be used not only on a separate computer, but also in a branched local network.
Access Features
Moreover, communication between the tables is provided, while cascading data updating and cascading deletion, if necessary, are supported.
Perform all the basic operations with data,such as input, view, store, update, sort, filter, receive samples. Also indexing on the selected fields is carried out, control of the entered information.
When filling fields, calculations using various formulas can be used.
DBMS Access is a convenient and understandable program that has all the capabilities of such professional applications.
