Select [All/DISTINCT] < > |*]
FROM < >
[WHERE <_ >]
[GROUP_BY < >]
[HAVING <_ >]
[ORDER_BY < , >].
:
* , (Select * FROM )
[] , ,
{} ,
| 2
; SQL
,
_
Select: Select. Select .
Select :
1) ( )
2) ( Where Having)
3) : CREATE VIEW, DECLARE, CURSOR INSERT
4) (INTO-).
38. MS Access.(1)
Microsoft Access () . :
, . , ,
, Microsoft Office, , OLE
, ( ) .
39. MS Access. .(1)
Microsoft Access
Microsoft Access , ( Access). Access , , , , . , , , . Microsoft Access , , , . Access.
1. . , . , . (), , , ( ). (, ..). ( , ) , .
|
|
2. . , . QBE ( ) SQL ( ). , , . , .
3. . , , . , . . , , VBA.
4. . , , .
5. . , , Access . , , . . . VBA.
6. . , , Visual Basic . , , , "" .
7. . - , , (, ).
40. MS Access. .(1)
Access, :
- , : , , , , . , , , . . , , .
. , , , . , . .
|
|
. , , , , , , . .
41. . . . .(1)
MS Access , .. , .
. , . . .
.
, , MS Access . , "", : .
MS Access -, . , . , .
MS Access .
. . , . , , "" (AutoNumber). , MS Access .
. , . MS Access .
!, ., [, ]. 64 . , .. .
: , , , MEMO, , , /, OLE.
, . .
. , , .
MS Access . , ה . , , MS Access , . - OLE .
MS Access
, . /
1. AllowZeroLength ( ) | 8. FieldSize ( ) | 15. Required ( ) |
2. DataType ( ) | 9. Format ( ) | 16. SortOrder ( ) |
3. Caption ( ) | 10. IgnoreNulls ( ) | 17. Unique ( ) |
4. DecimalPlaces ( ) | 11. FrozenColumns ( ) | 18. ValidationRule ( ) |
5. DefaultValue ( ) | 12. Indexed ( ) | 19. ValidationText ( ) |
6. Description ( ) | 13. InputMask ( ) | |
7. FieldName ( ) | 14. Primary ( ) |
Microsoft Access : (Datasheet View), (Design View), (PivotTable View) (PivotChart View).
|
|
, : , , , . . , . . , , . , . , .
42. . .(2)
, . , Microsoft Access . , .
Microsoft Access : , . .
:
1. .
2. 1.
3. (Primary Key) (Table Design).
, . (Yes) (ID) (AutoNumber).
, (, ). , . , , . , , .
, . . :
1. .
2. , .
3. (Primary Key) (Table Design)
43. : .(1)
. . .
|
|
-- (1:). , , .
, . , . , , . , .
MS Access . , , . , .
, 1: . .
44. , , , .(1)
, . , . . . , . , . .