UkrReferat.com

: 75834
: 2016-11-29
7 10



$

'

 

:   

, , :

Microsoft Access ()
,
Word Doc
11073
860

, .

 

.

CREATE TABLE. , ֲ

:

 

CREATE TABLE ֲ ([ ] DOUBLE, [в] TEXT (20),

[] TEXT (15), [] FLOAT);

 

. ALTER TABLE

, .

ADD COLUMN, DROP

COLUMN.

 

, ֲ

TEXT 30 :

 

L

 

N

 

 

j

 

?

 

?

 

j

 

j

 

J

 

?

 

?

 

j

 

j

 

jR-

 

j

 

j1

 

j"

 

j}%

 

j #

 

j&

 

jG(

 

?ALTER TABLE ֲ ADD COLUMN [ ] TEXT (30);

 

, .

, 25 :

 

ALTER TABLE ֲ DROP COLUMN [];

 

ALTER TABLE ֲ ADD COLUMN [] TEXT (25);

 

.

CREATE TABLE, CREATE INDEX ALTER TABLE. ϳ

, :

 

UNIQUE ( )

;

 

PRIMARY KEY ;

 

FOREIGN KEY .

 

,

̲ :

 

: CREATE TABLE ([̲] INTEGER

,[ ] DOUBLE, [ʲʲ ² Ͳ] DOUBLE,

CONSTRAINT _̲_ PRIMARY KEY ([̲], [ ]));

 

CREATE

INDEX: CREATE PRIMARY KEY INDEX _̲_ ON ([̲],

[ ]); ( ,

PRIMARY KEY);

 

ALTER

TABLE: ALTER TABLE ADD CONSTRAINT _̲_T PRIMARY KEY

([̲], [ ]);

 

DML , ,

.

 

. SELECT

ᒺ RECORDSET. ֳ ,

, .

SELECT:

 

SELECT [] < >

 

FROM <>[ IN < >]

 

[WHERE < >]

 

[GROUP BY < >]

 

[HAVING <>]

 

[ORDER BY < >]

 

[WITH OWNERACCESS OPTION ];

 

-

 

, , : ALL ( ),

DISTINCT (, -

 

, ) TOP (

). ALL.

-----> Page:

[0] [1] [2] [3] [4] [5] [6] [7] [8] 9 [10] [11] [12] [13] [14] [15] [16] [17] [18]

ò