.


:

:



,



( , )

:

































 

 

 

 
FAQ

" "

: " "

 

-2- 6

:

 

01.03.2011

31.05.2011

 

 

2011 .

ֲ Ͳ ò

( )

.

. .

6.080400

. 2. 6. . 04.

 

()

(, , )

1. () -

2. ()

3. () 1. .

2. -.

3. .

4. - ( , )__

1. .

2. .

3. .

4. , .

5. .

5. ( )_________

1. .

2. ()

6.


- . MS Access. 31 , 24 , 16 , 3 6 . , , , , , .

, , ᒺ , - .

ij , , .

, , .

, , .

:

1.

2.

3.

4. 볺

5.

 


Abstract

The given course project contains the developed informative-based system for the library for work of art literature. The given system is created by means the program MS Access.This term paper consists of 31 pages, 24 images, 16 papers of graphic part, 3 tables and 6 literary sources. The purpose of work is providing of effective intercommunication of user with the informative system, which is arrived at it by the developed interface with the use of the system of menu, forms for introduction and editing of data, forms for the leadingout of information which are searched by an user, and also leadingout of results of search in form of reports on a screen or on a print.

In this work there is description of the basic stages of planning and development of the informative system of treatment of database which is developed on the basis of model of relational database hotel, that allows to set synonymous relations between objects by the key fields of tables, and main - suits normalization and providing of integrity of data.

A dialog with an user takes place by means graphic interface menu, that includes at itself dialog boxes and forms setting of which are clear to the users.

The informative system allows to add, to edit, to withdraw not in contempt of here integrity of data.

A user can carry out the retrieval of data which interest him, using a certificate or marking the value of parameters of search.

Keywords:

1. Code of ganr

2. Code of books

3. Code of formular for reader

4. Code of reader

5. Code of gangs kinds

 


1. ...6

2.

2.1. ....9

2.2. ij ........................................................................................10

2.3. ..........................................................................................................11

3. ..................................................................................12

3.1 ą.........................................................................13

3.2 ...................14

3.3 ......................................................16

3.4 ................................................................17

3.5 볺......................................................................................18

3.6 .................................19

3.7 .20

4. ...21

5. ꅅ..27

6. 녅....28

7. 腅.....29

 


. , - .

, , - , .

, - . . , ' . - . , , , , , , , , , , . , , , , .

- ᑺ , ( , ᑺ ) . , ᑺ .

ᑺ . , : , . 2000 .

1970 . , , . ᒺ, . , . ᒺ (). , .

, .

: . . : MS Access, Paradox, Visual dBASE, Visual FoxPro.

MS Access , , ( ), , , , SQL, .

, .

 

2.

MS Access - , , , , , .

 
˳  
 
 
ֳ  
 
˳  
 
³  
볺 ˳  
ϲ 볺  
e-mail  
˳  
 
 
 
˳  
볺  
/  
 
 
ʳ  
   

 

 

2.2. ij .

볺
*          
  *        
    *      
볺       *    
*          
*   *      
* *        
*     * * *
* *        
*          
*   *      
      *    
* *        

2.3. .

 
 

 


.1. .

 

Access :

, , , ';

MS Access, ᒺ .

‑ ' Access, . , , . , ᒺ ( ). , , .

, , Ok.

; ; , (, ').

, . , , . , , .

, . :

 

.1.

 

.1 . , . , , . , , , . .

 

 

3.2.

, :

.2.

 

SQL :

SELECT .[ ], .[ ], .[ֳ ], .

FROM INNER JOIN ON .[ ] = .

WHERE (((.[ ])=[Forms]![ ()]![0]))

ORDER BY .[ ] DESC;

, . , , (.3). , (.3,4).

 

.3.

 

.4.

 

 

:

 

.5.

 

SQL :

SELECT .[ ], .[ֳ ], .[ ], .

FROM INNER JOIN ON .[ ] = .

WHERE (((.[ ])=[Forms]![ ()]![1]))

ORDER BY .[ ] DESC;

3.2: , . . г .

 

3.4.

.6 ֳ . ij .3.

.6.

 

SQL :

SSELECT .[ ], .[ ], ., .[ֳ ], .

FROM

WHERE ((([]![ֳ ])>[Forms]![ ()]![0] And ([]![ֳ ])<[Forms]![ ()]![2]));

 

-, .

 

3.5. 볺

볺 , , 볺 . :

 

 

.7. 볺

SQL :

SELECT 볺.[ 볺], 볺.[ϲ 볺], 볺.[e-mail 볺]

FROM 볺

WHERE (((볺.[ϲ 볺]) Like ('*'+[Forms]![ ()]![0]+'*')));

3.6

, , .

 

.8.

 

SQL :

SELECT .[ ], Avg(.[ֳ ]) AS [ ]

FROM INNER JOIN ON .[ ] = .

GROUP BY .[ ];

 

3.7

 

, . - . 䳿 . , .

.10.

 

SQL :

SELECT .[ ], .[ ], ., .

FROM ;

 

4.

. :

.11.

- - .

 

 

:

.12.

. . :

.13.

, . . . .

 

³ :

.14.

 

. :

.15.

 

 

:

.16.

. :

;

/ ;

, .

, , .

 

. :

.17.

 

:

.18.

, . .

 

 

- . , . MS Access.

- - , , , . , , .

, : , . , , .

, - .

<== | ==>
. |
:

: 2017-01-28; !; : 371 |

:

:

, .
==> ...

1689 - | 1517 -


© 2015-2024 lektsii.org - -

: 0.1 .