Proyek Queri-queri Lanjut dan Sub-subqueri
-
Upload
kathleen-hensley -
Category
Documents
-
view
30 -
download
2
description
Transcript of Proyek Queri-queri Lanjut dan Sub-subqueri
![Page 1: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/1.jpg)
Proyek Queri-queri Lanjut dan Sub-subqueri
![Page 2: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/2.jpg)
Proyek Queri-queri Lanjut dan Sub-subqueri
![Page 3: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/3.jpg)
Variables dan Data
![Page 4: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/4.jpg)
Integer
• 2 bytes• -32768 32767
![Page 5: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/5.jpg)
Long
• 4 bytes• +/- 2,147,483,648
![Page 6: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/6.jpg)
Single
• 4 bytes• +/- 3.402823 E38• +/- 1.401298 E-45
![Page 7: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/7.jpg)
Double
• 8 bytes• +/- 1.79769313386232 E-308• +/- 4.94065645841247 E-324
![Page 8: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/8.jpg)
Currency
• 8 bytes• +/- 922,337,203,685,477.5808
![Page 9: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/9.jpg)
Variant
• Any data Type• Null
![Page 10: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/10.jpg)
Fungsi-fungsi Internal standar
![Page 11: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/11.jpg)
Fungsi String
• LCase, UCase• Format• StrComp• Len• InStr
• Chr, Asc• String• Trim, LTrim, RTrim• Left, Right, Mid• & Concatenation
![Page 12: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/12.jpg)
Len
• Len"Ramanujan") = 9
![Page 13: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/13.jpg)
InStr
• ("8764 main"," ") = 5
![Page 14: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/14.jpg)
String
• String(5, "a") = "aaaaa"
![Page 15: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/15.jpg)
Trim, LTrim, RTrim
• Trim(" Maria ") = "Maria"
![Page 16: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/16.jpg)
Left, Right, Mid
• Left("jackson",5) = "Jacks"
![Page 17: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/17.jpg)
& Concatenation
• "Frank" & "Rose = "FrankRose"
![Page 18: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/18.jpg)
Fungsi Matematis Standar
• Numeric
![Page 19: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/19.jpg)
Numeric
• Exp, Log• Atn, Cos, Sin, Tan• Sqr• Abs• Sgn• Int, Fix• Rnd, Randomize
![Page 20: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/20.jpg)
Conditions
![Page 21: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/21.jpg)
Basic Conditions
• If (conditiona1) Then statement for true• Else• Statement for false If (condition2) Then statements for
true• End If• End If
![Page 22: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/22.jpg)
Nested Conditions
• Response = MsgBox ( . . .) If (response = vbYes) Then 'statements for Yes
• Else• If (response = vbNo) Then 'statements for No• Else• 'statements for Cancel End If• End If
![Page 23: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/23.jpg)
Pernyataan Select
• Response = MsgBox( . . . ) Select Case response case vbYes
• 'statements for Yes Case vbNo• 'statements for No Case vbCancel• 'statements for cancel End Case
![Page 24: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/24.jpg)
Loops
![Page 25: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/25.jpg)
Input dan Output
![Page 26: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/26.jpg)
Subroutines
![Page 27: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/27.jpg)
Subroutine StatusMessage dapat dipanggil dari lokasi mana saja.
• Main program ... StatusMessage "trying to connect." ... StatusMessage "verifying access." ... End main program Sub StatusMessage (Msg As String) 'Display Msg, location, color End Sub
![Page 28: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/28.jpg)
Komputasi
![Page 29: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/29.jpg)
Variable Scope
![Page 30: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/30.jpg)
Form
• Button1• Button2
![Page 31: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/31.jpg)
Form-Module Code
• Sub Button1_Click()• Dim I1 As Integer• I1 = 3• End Sub• Sub Button2_Click()• Dim i1 As Integer• I1 = 7• End Sub
![Page 32: Proyek Queri-queri Lanjut dan Sub-subqueri](https://reader035.fdocument.pub/reader035/viewer/2022081603/568136cb550346895d9e6755/html5/thumbnails/32.jpg)
Proyek Queri-queri Lanjut dan Sub-subqueri