User interface, Algorithm of transformation (application) - Databases

User Interface

Users are not only the dean's office, but also the contract department, the training department, the personnel department. At the same time, the database administrator (DBA) is in the dean's office. Therefore, the interface should be convenient for one user - DBA.

The interface is a means of interaction between the user and the computer and includes a general set of menus (button forms) and controls.

In the Learning process database, A button form is used, more traditional for Microsoft software products. In the main button form, three positions (buttons) are highlighted: Filling ; Using ; Exit the application. Additionally, the button Changes of the button form is entered. Position Filling is protected from unauthorized access so as not to introduce anarchy into the data entry process.

Clicking the Fill button will bring up the Deccan, Chairs, Contract Department, Human Resources, Training Department buttons. All buttons except the first are "linked" directly to the database forms "Learning process". There is a button to return to the main button form. The Deccanate button is again expanded in the Student, Student orders , PPI, Group, buttons, each of which is directly linked to the database forms "Study process". There is also a return to the Fill button.

For the Usage, button, there are currently about 30 report-documents of the database "Learning process".

When the button (form) Usage is opened, the Deccan, Chairs, Contractual department, Education department, Human Resources buttons appear In the form Deanery there are Forms Vedomosti, Group, Field Practice, Curators and Headmen, Session, Orders for Students. The Group form contains the Characteristics of the group. Group List and List of Groups with Headmen. The Practitioner's Practitioner form is reflected in the Work Practice form. In the form Curators and Groups - reports with a list of curators and a list of headmen. In the form Session reports on debtors, lists of students who passed the session with one and two fours, the average score of the group and the student, the results of the session are reflected. In the form of Orders for the student there are reports of orders for transfer to the next year, the deduction and the form of orders for the scholarship. In the latter, there are orders for scholarships to excellent students and students who passed the session with one and two fours. In each form of the button form, there are forms of return to the previous form.

Algorithm of transformation (application)

In this case, it is compiled using a system of queries, reports, programs using macros and the VBA programming language. Queries and programs act as intermediaries between the source tables and the final reports.

Here are some examples of using queries and programs for generating reports.

Example 14.1. Report Group is formed on the basis of the query Group. The query within Access is constructed fairly simply using the visual QBE language.

You must go to the Queries tab of the main Access DB window (Figure 14.10) and click the Create query in design view. In the pop-up window, specify the names of the required tables and queries , on the basis of which the query is built (in this case - based on the table "Group") and close this window. The main window for creating a query is opened (using the QBE programming language), at the top of which there are data on selected tables and queries.

Main Query Window

Fig. 14.10. The main query window

In the lower part of the main window, the names of the fields used in the query are entered in succession. To do this, a corresponding field is selected at the top of the window, which is clicked twice. At the bottom of the window, you can enter conditions for data selection, query parameters, data aggregation conditions.

After all the manipulations have been completed, the main window (the query formations) is closed (the & x; icon in the upper right corner of the window). The computer asks you to save the query by specifying its name (by default, REQUEST, where i is the serial number) or discard the results. After a possible correction of the name and pressing the Yes button, the request is completed and its name appears in the main DBMS window ( Requests tab).

You can easily run reports using the wizard. Let's go to the Reports tab (Figure 14.11) and select the Create report with the wizard. Next, the work is almost the same as creating a form in semi-automatic mode. In the first window of the Wizards , select tables (queries) and fields (in this example, the "Group with all fields" table) used in the report. In the second and third windows of the Wizards , you select the sorting and grouping fields (possibly with a summary). In the subsequent windows Wizards - the report layout and style. In the last window specify the name of the report (by default - OTCHeti) and clicking the Finish button completes the report construction. The generated report appears on the screen, and its name is fixed in the main DBMS window on the Reports tab.

If the resulting version of the report requires correction, it is closed and on the Reports tab of the main DBMS window click the Constructor. Next, move the necessary controls in the report.

It should be noted that the capabilities of the QBE programming language are limited. To obtain complex queries and reports, you must use the VBA programming language.

Report Window

Fig. 14.11. Report Window

Example 14.2. Let's show the programming procedure. Note that in VBA, program modules can be self-contained (they can be used with any object) or "quoted" to a form or report (form module, report module).

Consider a program of the second type.

In the main DBMS window, go to the Forms tab, select the form and click the Constructor.

Use the right mouse button to select the Properties element in the context menu for the form as a whole or an individual field. In the pop-up window that will open, go to the Events tab and click on the selected event line the ellipsis icon. In the Builder window that appears, select the Programs element and click the OK button.

The program can have the form

Option Compare Database

Private Sub Button12_GotFocus ()

Button8. Enabled = False

End Sub

In this case, the first two and the last lines of the program are typed computer. The module name is automatically generated and remembered when the form is closed.

Similarly, the modules for the reports are generated.

Offline modules are built in the main DBMS window on the Modules tab

Password protection and "read only" for the database as a whole and/or for individual tables. In Access, access can be generated using the Page, object setting which access level has specific table fields (by creating an access table). Hardware failures are compensated by DBMS operation (short-term failures) and automatic generation of a backup copy after a certain period of time (long-term failures). Manual backup should be performed with all update procedures, which may distort or lose data.

thematic pictures

Also We Can Offer!

Other services that we offer

If you don’t see the necessary subject, paper type, or topic in our list of available services and examples, don’t worry! We have a number of other academic disciplines to suit the needs of anyone who visits this website looking for help.

How to ...

We made your life easier with putting together a big number of articles and guidelines on how to plan and write different types of assignments (Essay, Research Paper, Dissertation etc)