. , , ,

,,,

,

1.

1.1

 

, , , , , , , .

:

1.         , , . ;

2.         , . , , ;

3.         , . , .

, , .

, . , .


1.2

:

   ;

   ;

   .

1.3

 

1.4

2 :

           : (, , )

           -: - - .

:

1.         :

           ( -)- (..., , ..), ;

           ( - ) , ( , , ..);

           ( - )- , ( , , ..);

2.         :

           ( - )- (, , ..);

           ( ) , (, , ..);

           ( )- , , ( , );

           ( - )- , ( , , ..);

           ( )- , : , , , , , ;

           ( ) , : , , ..

, , , .

, : --.

--. , . : ().

-- , . () . , , , .

( ) , . , .

1.5

, . , .

:

1) , .

( ).

2) , .. , () .

: , , , , . .

3) , .

. . , , , .

1.6

:

1.         - , . :

           - .

           2 .

           , , .

2.         :

           , .

3.         :

           . , , .

4.         :

           .

5.         :

           - , .

6.         :

           .

7.         :

● , .

8. :

● . .

SQL.

1.        

SELECT DISTINCTROW [ ]. , . , . , ., ., [ ]. , [ ]. , [ ]. AS 1, [ ]. AS 2, Sum ([ ]. +[ ]. ) AS

FROM [ ], ( INNER JOIN ( INNER JOIN ON . = . ) ON . = ) INNER JOIN ([ ] INNER JOIN [ ] ON [ ]. = [ ].) ON . = [ ].

GROUP BY [ ]. , . , . , . , . , [ ]. , [ ]. , [ ]. , [ ].

HAVING ((([ ]. ) = [Forms] ! [] ! []));

2.        

SELECT .*, . , .

FROM INNER JOIN ( INNER JOIN ON . = . ) ON . = . ;

3.        

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

FROM [ ] INNER JOIN (( INNER JOIN ( INNER JOIN ON . = .) ON . = . ) INNER JOIN ([ ] INNER JOIN [ ] ON [ ]. = [ ].) ON . = [ ]. ) ON [ ]. = [ ]. ;

4.        

SELECT . , . , . , . INTO [ ]

FROM INNER JOIN ON . =.

WHERE (((Date())= ))

ORDER BY . ;

5.        

SELECT , , , , "" AS []

FROM

UNION SELECT , , , , ""

FROM ;

6.        

INSERT INTO

VALUES ([ :], [ :], [ :], [ :], [ :], [ :], [ :], [ :], [ :]);

7.        

DELETE *

FROM

WHERE =[ :];

8.        

UPDATE [ ] SET [, %] = [ ]

WHERE (()=[ ]);

9.        

SELECT , , SUM( + ) AS [ ]

FROM

GROUP BY , ;

10.      

TRANSFORM SUM([ ].) AS [Sum- ]

SELECT [ ].

FROM [ ]

GROUP BY [ ].

PIVOT [ ]. ;

1.7

. , . , SQL, . .

:

1. - ;

2. - . ;

3. - , ;

4. - , .


2.

Microsoft Access 2003 .

Avtoservice.mdb. , , , ( ).

, , .

, , , .

, , . , .

:


. .

, , .

. , , . ( ), , , .


3.        

, .

:

:

:



1.          .. , .. , .. , 2006 .

2.          .. Access 2003 , 2004.

3.          . , . SQL- . SQL , 2003 .

4.          .. , ., 2008 .

1. 1.1 , ,

 

 

 

! , , , .
. , :