1 / 32

Proyek Queri-queri Lanjut dan Sub-subqueri

Proyek Queri-queri Lanjut dan Sub-subqueri. Proyek Queri-queri Lanjut dan Sub-subqueri. Variables dan Data. Integer. 2 bytes -32768 32767. Long. 4 bytes +/- 2,147,483,648. Single. 4 bytes +/- 3.402823 E38 +/- 1.401298 E-45. Double. 8 bytes +/- 1.79769313386232 E-308

Download Presentation

Proyek Queri-queri Lanjut dan Sub-subqueri

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Proyek Queri-queri Lanjut dan Sub-subqueri

  2. Proyek Queri-queri Lanjut dan Sub-subqueri

  3. Variables dan Data

  4. Integer • 2 bytes • -32768 32767

  5. Long • 4 bytes • +/- 2,147,483,648

  6. Single • 4 bytes • +/- 3.402823 E38 • +/- 1.401298 E-45

  7. Double • 8 bytes • +/- 1.79769313386232 E-308 • +/- 4.94065645841247 E-324

  8. Currency • 8 bytes • +/- 922,337,203,685,477.5808

  9. Variant • Any data Type • Null

  10. Fungsi-fungsi Internal standar

  11. LCase, UCase Format StrComp Len InStr Chr, Asc String Trim, LTrim, RTrim Left, Right, Mid & Concatenation Fungsi String

  12. Len • Len"Ramanujan") = 9

  13. InStr • ("8764 main"," ") = 5

  14. String • String(5, "a") = "aaaaa"

  15. Trim, LTrim, RTrim • Trim(" Maria ") = "Maria"

  16. Left, Right, Mid • Left("jackson",5) = "Jacks"

  17. & Concatenation • "Frank" & "Rose = "FrankRose"

  18. Fungsi Matematis Standar • Numeric

  19. Numeric • Exp, Log • Atn, Cos, Sin, Tan • Sqr • Abs • Sgn • Int, Fix • Rnd, Randomize

  20. Conditions

  21. Basic Conditions • If (conditiona1) Then statement for true • Else • Statement for false If (condition2) Then statements for true • End If • End If

  22. 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

  23. Pernyataan Select • Response = MsgBox( . . . ) Select Case response case vbYes • 'statements for Yes Case vbNo • 'statements for No Case vbCancel • 'statements for cancel End Case

  24. Loops

  25. Input dan Output

  26. Subroutines

  27. 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

  28. Komputasi

  29. Variable Scope

  30. Form • Button1 • Button2

  31. 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

  32. Proyek Queri-queri Lanjut dan Sub-subqueri

More Related