User Manual

9-17
ﺔﺘﺑﺎﺜﻟﺍ ﺕﺎﻧﺎﻴﺒﻟﺍ ﺯﺮﻓ k
ﺩﻮﻤﻋ ﻞﺧﺍﺩ ﺓﺩﺪﻌﺘﻣ ﻁﻮﻄﺧ ﻭﺍ ﺪﺣﺍﻭ ﻂﺧ ﻦﻤﺿ ﺓﺪﻤﻋﺃ ﺓﺪﻋ ﺭﺎﻴﺘﺧﺍ ﻚﻨﻜﳝ .ﺔﺘﺑﺎﺜﻟﺍ ﺕﺎﻧﺎﻴﺒﻟﺍ ﻂﻘﻓ ﺯﺮﻓ ﻦﻜﳝ ﻪﻧﺍ ﻆﺣﻻ
.ﺯﺮﻔﻠﻟ ﺪﺣﺍﻭ
ﺔﺘﺑﺎﺜﻟﺍ ﺕﺎﻧﺎﻴﺒﻟﺍ ﺯﺮﻓ u
.ﺪﺣﺍﻭ ﺩﻮﻤﻋ ﻲﻓ ﻒﺼﻟﺍ ﺎﻳﻼﳋ ﻕﺎﻄﻧ ﻭﺃ ﺪﺣﺍﻭ ﻒﺻ ﻲﻓ ﺩﻮﻤﻌﻟﺍ ﺎﻳﻼﳋ ﻕﺎﻄﻧ ﺮﺘﺧﺍ .1
.(
9-7 ﺔﺤﻔﺻ) "ﺎﻳﻼﳋﺍ ﻦﻣ ﻕﺎﻄﻧ ﺭﺎﻴﺘﺧﻻ" ﺮﻈﻧﺍ •
ﺕﺎﻧﺎﻴﺒﻟﺍ ﺮﻴﻏ ﺕﺎﻧﺎﻴﺑ ﻰﻠﻋ ﻱﻮﺘﲢ ﻪﺗﺮﺘﺧﺍ ﻱﺬﻟﺍ ﻕﺎﻄﻨﻟﺍ ﻲﻓ ﺎﻳﻼﳋﺍ ﻦﻣ ﻱﺍ ﺖﻧﺎﻛ ﺍﺫﺍ
Syntax ERROR ﺽﺮﻌﺗ ﻑﻮﺳ •
.ﺔﺘﺑﺎﺜﻟﺍ
.ﺔﻴﻟﺎﺘﻟﺍ ﺕﺎﻴﻠﻤﻌﻟﺍ ﻦﻣ ﻱﺍ ﺀﺍﺩﺄﺑ ﻢﻗ ،ﻩﺀﺍﺩﺃ ﺪﻳﺮﺗ ﻱﺬﻟﺍ ﺯﺮﻔﻟﺍ ﻉﻮﻧ ﻰﻠﻋ ﺩﺎﻤﺘﻋﻻﺎﺑ .
2
2(EDIT) 6( g) 2(SORTASC) :ﻱﺪﻋﺎﺼﺘﻟﺍ ﺯﺮﻔﻠﻟ
2(EDIT) 6( g) 3(SORTDES) :ﻲﻟﺯﺎﻨﺘﻟﺍ ﺯﺮﻔﻠﻟ
ﺎﻳﻼﳋﺍ ﻝﺎﺧﺩﺍ ﻭ ﻑﺬﺣ k
ﺎﻳﻼﳋﺍ ﻦﻣ ﺍﺩﻮﻤﻋ ﻭﺍ ﻼﻣﺎﻛ ﻂﺧ ﻑﺬﳊ u
ﻑﺬﺤﻳ ﻑﻮﺳ .3(DELETE) ﻰﻠﻋ ﻂﻐﺿﺍ ﻢﺛ ﻦﻣﻭ ﺎﻬﻓﺬﺣ ﺪﻳﺮﺗ ﻲﺘﻟﺍ (ﺓﺪﻤﻋﻷﺍ) ﺩﻮﻤﻌﻟﺍ ﻭﺍ (ﻑﻮﻔﺼﻟﺍ) ﻒﺼﻟﺍ ﺮﺘﺧﺍ
.ﺪﻴﻛﺄﺘﻟﺍ ﺔﻟﺎﺳﺭ ﺽﺮﻋ ﻥﻭﺪﺑ .ﺔﻋﺮﺴﺑ ﺓﺭﺎﺘﺍ (ﺓﺪﻤﻋﻷﺍ) ﺩﻮﻤﻌﻟﺍ ﻭﺍ (ﻑﻮﻔﺼﻟﺍ) ﻒﺼﻟﺍ ﺍﺬﻫ
.ﺩﻮﻤﻋ ﻭﺍ ﻒﺻ ﻑﺬﳊ ﺔﻴﻟﺎﺘﻟﺍ ﺓﻮﻄﳋﺍ ﺀﺍﺩﺍ ﺎﻀﻳﺃ ﻚﻨﻜﳝ
.ﺎﻬﻓﺬﺣ ﺪﻳﺮﺗ ﻲﺘﻟﺍ (ﺓﺪﻤﻋﻷﺍ) ﺩﻮﻤﻌﻟﺍ ﻭﺍ (ﻑﻮﻔﺼﻟﺍ) ﻒﺼﻟﺍ ﻞﺧﺍﺩ ﺎﻳﻼﳋﺍ ﻦﻣ ﺮﺜﻛﺍ
ﻭﺍ ﺍﺪﺣﺍﻭ ﺮﺘﺧﺍ
.1
ﻰﻠﻋ ﻞﻤﺘﺸﺗ ﻲﺘﻟﺍ ﺎﻳﻼﳋﺍ ﻦﻣ ﺮﺧﺁ ﻕﺎﻄﻧ ﻱﺍ ﻭﺍ ،
C2:C4 ﻭ ،A2:B4 ﺭﺎﻴﺘﺧﺍ ﻚﻨﻜﳝ ،ﻼﺜﻣ ،4 ﻰﻟﺍ 2 ﻁﻮﻄﳋﺍ ﻑﺬﺣ ﺕﺩﺭﺃ ﺍﺫﺍ •
.ﺎﻬﻓﺬﳊ ﻁﻮﻄﳋﺍ
.ﺦﻟﺍ ﻭ ،
A2:B4 ﻭ ،A1:B1 ﺭﺎﻴﺘﺧﺍ ﻚﻨﻜﳝ ،ﻼﺜﻣ ،B ﻭ A ﺩﻮﻤﻌﻟﺍ ﻑﺬﺣ ﺕﺩﺭﺃ ﺍﺫﺍ •
.
3(DELETE) ﻰﻠﻋ ﻂﻐﺿﺍ .2
.
J ﻰﻠﻋ ﻂﻐﺿﺍ ،ﺖﻗﻮﻟﺍ ﺍﺬﻫ ﻲﻓ ﻑﺬﳊﺍ ﺔﻴﻠﻤﻋ ﺀﺎﻐﻟﺇ ﺕﺭﺮﻗ ﺍﺫﺍ .ﻑﺬﺤﻠﻟ
ﹰ
ﺍﺩﺍﺪﻌﺘﺳﺍ ﺍﺬﻫ ﻞﺧﺪﻴﺳ •
ﺩﻮﻤﻌﻟﺍ ﻑﺬﳊ ﻭ .
1(ROW) ﻰﻠﻋ ﻂﻐﺿﺍ ،1 ﺓﻮﻄﳋﺍ ﻲﻓ ﺓﺭﺎﺘﺍ ﺎﻳﻼﳋﺍ ﻦﻤﻀﺘﺗ ﻲﺘﻟﺍ ﺔﻠﻣﺎﻜﻟﺍ (ﻁﻮﻄﳋﺍ) ﻂﳋﺍ ﻑﺬﳊ .3
.
2(COLUMN) ﻂﻐﺿﺍ ،ﻞﻣﺎﻜﻟﺍ
ﻝﻭﺪﳉﺍ ﻲﻓ ﺎﻳﻼﳋﺍ ﻊﻴﻤﺟ ﺕﺎﻳﻮﺘﺤﻣ ﻑﺬﺣ u
.3(DELETE) 3(ALL) ﻂﻐﺿﺍ .1
.ﺀﻲﺷ ﻑﺬﺣ ﻥﻭﺪﺑ ﺀﺎﻐﻟﻺﻟ
6(No) ﻭﺍ ﺕﺎﻧﺎﻴﺒﻟﺍ ﻑﺬﳊ 1(Yes) ﻰﻠﻋ ﻂﻐﺿﺍ ،ﺔﺿﻭﺮﻌﳌﺍ ﺪﻴﻛﺄﺘﻟﺍ ﺔﻟﺎﺳﺭ ﻰﻠﻋ ﺍ
ﹼ
ﺩﺭ .2