Kursus dan Bimbingan Belajar

Sabtu, 29 Juni 2024

VB6 IDE Menu

File > Save Project menu : To save the project.

File > Open Project menu : To open the existing project.

File > New Project menu : To create a new project.

Edit > Copy menu : To copy code or object.

Edit > Paste menu : To paste code or object.

Edit > Cut menu : To cut code or object.

View > Code menu : To display Code window.

View > Object menu : To display Form Designer / Form Object window.

View > Toolbars menu : To Add A Toolbar To The IDE Or Remove A Toolbar From The IDE.

View > Object Browser menu : To Access the Object Browser.

Project > Add Form menu : To add A Form To A Project.

Project > Add File... menu : To add existing file.

Project > Remove <object or file name> menu : To remove selected / active object.

Project > Components menu : Add Controls To The Toolbox ( Add Component ).

Project > References menu : To choose and add ActiveX DLL Components to the Project.

Project > <Project Name> Properties menu : Configure the Project.

Debug > Toggle Breakpoint menu : Checking Code Segments With Breakpoints.

Run > Start menu : Run the Project.

Run > End menu : Terminate the program.

Tools > Add Procedure menu : add procedure such as Sub procedure, Function procedure, Property procedure, Event procedure ( when Code window is active ).

Tools > Options menu : Configure the IDE.

Tools > Menu Editor menu : To add menu to the project.

« back to Visual Basic 6 IDE

task, develop, maintenance, integration, delivery, build, vb, programming, Dynamic Link Library, Integrated Development Environment

Jumat, 28 Juni 2024

SQL Reference Sheet free download in PDF format.

SQL ( Structured Query Language ) command from DDL ( Data Definition Language ), DQL ( Data Query Language ), DML ( Data Manipulation Language ), CREATE TABLE command, SELECT command, UPDATE table command, SELECT GROUP BY command, INSERT command, DELETE command, SELECT ORDER command

Download ( studydrive )

Click SQL Reference Sheet Download Link For Free:

https://www.studydrive.net/en/doc/sqlrefsheet-upl/1738895

learn database, learn sql, database, dbms, sql learner, sql, learn computer, computer course, information technology student, study computer

Learn About Visual Basic Classic List 2

DAO Object List In Visual Basic
Microsoft DAO ( Microsoft Data Access Objects ) List.

ADODB Properties 1
ActiveConnection property using on these following objects, Open method using on these following objects.

Datagrid Visual Basic Classic 1
Deklarasi variable, configure a database connection, display data from ADODB recordset to DataGrid, configure DataGrid (caption & width), display data from active cell of DataGrid ( clicked ).

Database Connection String
Microsoft ACE OLEDB 12.0 ( Microsoft Office Access database modern version ), Microsoft Jet OLE DB 4.0 ( Microsoft Office Access Classic Version ),

Handle Keyboard Shortcut In Microsoft Visual Basic
How to let the user press Ctrl-A to select all of the text in a TextBox in Visual Basic 6.

Supported Picture File Types In Visual Basic Classic
This is the list of Graphics formats types ( image file extension ) that supported by Microsoft Visual Basic Classic.

Visual Basic Common Properties
The Left, Top, Width, and Height Properties; The ForeColor and BackColor Properties; The Font Property.

Common Dialog Control In Visual Basic Classic
These are Common Dialog Control Properties and Method; Common Dialog Control code sample In Visual Basic Classic.

Visual Basic 6 Menu Control Design Table
Visual Basic 6 Menu Properties: (Variable) Name, Caption, Mnemonic Letter/Access Key, Level, Shortcut/Accelerator Key/Keyboard Shortcut/Hotkey, Index, Checked, Enabled, WindowList, Visible, PopupMenu.

Visual Basic 6 Menu Control Design Output

Output from Visual Basic 6 Menu Control Design Table above.

<< back to Learn About Visual Basic Classic List

phpMyAdmin error - #1273 - Unknown collation: 'utf8mb4_general_ci' 1

Problem

After open (log in or visit) PhpMyAdmin on the localhost on my PC and then I get the message

Error

MySQL said:

#1273 - Unknown collation: 'utf8mb4_general_ci'

Solution

To delete only cookies on the Google Chrome:

hold down Ctrl+Shift+Delete on the keyboard.
remove all check boxes except for "Cookies and other site data" of course.
use the "Time range" drop down on top to select "Last hour" or other appropriate time range.
click "Clear data" button.

To delete only cookies on the Mozilla Firefox:

hold down Ctrl+Shift+Delete on the keyboard.
remove all check boxes except for "Cookies" of course
use the "Time range to clear:" drop down on top to select "from the beginning of time"
click "Clear browsing data" or "Clear Now" button.

Bibliography

https://support.google.com/chrome

https://support.mozilla.org/en-US/

Kamis, 27 Juni 2024

AlphaNumeric Character

Alphanumericals or alphanumeric characters are any collection of number characters and letters in a certain language.

There are either 36 ( A–Z and 0–9, case insensitive ) or 62 ( A–Z, a–z and 0–9, case-sensitive ) alphanumeric characters.

ASCII Code for AlphaNumeric Character from 48 to 57 ( 0–9 or Zero to Nine ), 65 to 90 ( A–Z ) and 97 to 122 ( a-z ).

Non AlphaNumeric Characters

Symbols : @ (“at” sign/mention symbol), $ (dollar sign/string notation), # (pound sign/hash mark/hash tag/crosshatch character)

Special characters :

' (single quotation mark)
! (exclamation mark)
& (ampersand)
() (parenthesis/round bracket)
* (asterisk/star)
, (comma)
. (period/dot)
/ (slash)
; (semicolon)
? (question mark)
[ ] (brackets/square bracket)
^ (caret sign)
_ (underscore)
{ } (braces/curly bracket)
‘ (apostrophe)
+ (plus sign)
– (hyphen/straight line)
= (equal sign)
<> (angle brackets/angular braces)
` (backtick character)
~ (tilde character)

An alphanumeric order or alphanumeric sort is a method of sorting data, often in the following order (based on ASCII (American Standard Code for Information Interchange) chart): punctuation mark, numbers, capital letters, lowercase letters, and symbols.

Bibliography

https://en.wikipedia.org/

https://theasciicode.com.ar/

https://www.commfront.com/

https://www.computerhope.com/

Rabu, 26 Juni 2024

Vertical Addition

In these picture is shown addition in vertical form.

math, mathematics, learn math, study math, math lesson

How To Check MySQL Version

To check MySQL Version Using the Command Line (Windows, Linux and macOS)

Open your Microsoft Windows Command Line / Microsoft Windows Command Prompt / Linux or macOS Terminal / Linux or macOS Shell / Linux or macOS Console / Linux or macOS Command Line.
Type this MySQL command:
mysql -V
then press Enter on keyboard.

The mysql -V (the uppercase V) command works on Linux, macOS, Windows, and other supported systems.

Open your Microsoft Windows Command Line / Microsoft Windows Command Prompt / Linux or macOS Terminal / Linux or macOS Shell / Linux or macOS Console / Linux or macOS Command Line.
or type this MySQL command:
mysql --version
then press Enter on keyboard.

Its output contains the MySQL the major version number, build date, and an optional suffix release copyright information.

For best practices and production purpose use the General Availability (GA) release because stable versions and are safe and reliably.

Bibliography

https://www.scalahosting.com/

https://www.devart.com/

https://dev.mysql.com/

Most Common UML Notation

Notes

Notes allow you to enter additional comments that are not captured in your diagrams. You can write anything you want in a note to explain your diagram, similar to a comment in code.
Notes are pictured with the folded rectangle notation.

Stereotypes

Stereotypes signify a special use or intent and can be applied to almost any element of UML notation.
Stereotypes modify the meaning of an element and describe the element's role within your model.
A stereotype sometimes has an associated icon, such as stick-figure actor symbol.
The stereotype is shown using guillemots at either end of the stereotype name, as in «stereotype_name». However, because guillemots require an extended character set, you can substitute them for angle brackets, as in <<stereotype_name>>.
There is no limit to the number of stereotypes with which an element can be associated; sometimes you may end up specifying more than one stereotype.
The UML specification defines a set of "standard" or predefined stereotypes. Some of the more useful standard stereotypes include:

utility: Represents a class that provides utility services through static methods, just as Java's Math class.
service: A stateless, functional component that computes a value; could be used to represent a web service.
subsystem: A large component that is actually a subordinate system of a larger system.

<< back to Study About UML Diagram

Unified Modelling Language ( UML ), uml modelling, uml diagram, uml chart, program design, software design, application design

Pentingnya Kebersihan Lingkungan (IPS)

Kebersihan lingkungan adalah aspek yang sangat penting dan tak terpisahkan dalam kehidupan manusia karena perlu dipahami oleh setiap siswa baik itu siswa laki-laki maupun perempuan (dalam postingan artikel ini selanjutnya akan disebut sebagai siswa) dalam mata pelajaran IPS (Ilmu Pengetahuan Sosial) dimulai dari SD (Sekolah Dasar) bahkan mata pelajaran lain sebelum SD – selanjutnya akan disebut sebagai SD saja. Memahami pentingnya kebersihan lingkungan tidak hanya berdampak positif pada kesehatan diri (masing-masing) dan lingkungan, tetapi juga mengajarkan siswa tentang tanggung jawab mereka dalam menjaga kebersihan tempat tinggal kita.

Menjaga kebersihan lingkungan sama artinya menciptakan lingkungan yang sehat, bebas dari kotoran, seperti debu, sampah dan berbagai bau yang tidak sedap. Dengan lingkungan yang sehat, kita tidak akan mudah terserang berbagai penyakit seperti demam berdarah (DBD), malaria, muntaber dan lainnya. Tidak hanya di bidang kesehatan, kebersihan lingkungan juga sangat berpengaruh terhadap kenyamanan, keindahan dan keasrian lingkungan yang nantinya bermuara pada kedamaian lingkungan. Semua ini dapat kita raih dengan melakukan perbuatan kecil dan sederhana, mulai dari menjaga kebersihan lingkungan di sekitar kita.

Cara memahami pentingnya kebersihan lingkungan dalam mata pelajaran IPS di SD dapat dilakukan melalui beberapa langkah berikut:

Belajar dari buku teks/buku sekolah baik itu buku sekolah cetak/buku sekolah digital/buku sekolah elektronik/buku paket pelajaran sekolah atau materi pembelajaran (selanjutnya dalam artikel ini akan disebut sebagai buku teks): Melalui pembelajaran di kelas, guru akan memberikan penjelasan mengenai sangat pentingnya kebersihan lingkungan. Buku teks juga akan mencantumkan informasi mengenai dampak buruk dari lingkungan yang tidak bersih atau kotor.
Observasi langsung: Guru dapat membawa siswa ke lingkungan sekitar sekolah atau rumah untuk melakukan observasi tentang kebersihan lingkungan secara langsung. Dalam hal ini, siswa dapat melihat dampak positif yang dihasilkan dari lingkungan yang bersih dan dampak negatif akibat lingkungan yang tidak terjaga kebersihannya.
Mengajarkan tentang daur ulang: Guru dapat memberikan penjelasan mengenai kegiatan daur ulang sampah kepada siswa. Dalam IPS, hal ini terkait dengan pengelolaan sampah yang baik dan penting dalam menjaga kebersihan lingkungan.
Melakukan kegiatan yang mendukung kebersihan lingkungan: Guru dapat mengajak siswa untuk melakukan kegiatan membersihkan lingkungan sekitar sekolah atau rumah. Dengan melakukan kegiatan membersihkan lingkungan tersebut, siswa akan memahami secara langsung betapa pentingnya menjaga kebersihan lingkungan dimulai dari lingkungan rumah siswa.

Cara menjaga kebersihan lingkungan

Kerja bakti membersihkan lingkungan.
Membersihkan halaman dan telajakan/pematang/trotoar di sekitar rumah.
Sampah yang dihasilkan rumah tangga selanjutnya kita pilah menjadi tiga, sampah organik, sampah non organik dan sampah botol atau pecah belah.
Perlu juga diatur jadwal untuk kegiatan kerja bakti membersihkan lingkungan kantor, toko dan sekitar rumah.
Hal yang tidak kalah penting adalah menanam tanaman. Tanaman mempunyai banyak fungsi yaitu sebagai penyaring debu, penyimpan air tanah, penyejuk dan pendingin alami. Selain itu tanaman juga dapat dijadikan sebagai taman yang akan memberikan suasana asri dan indah lingkungan sekitar kita.Dengan adanya pohon yang rindang, taman yang asri, otomatis kita akan menjadi nyaman dan betah di rumah maupun di kantor dalam melaksanakan tugas sehari-hari.

Kegiatan pembersihan lingkungan:

Pembersihan Sampah
Pembersihan Jalan
Pembersihan Taman
Pembersihan Drainase
Pembersihan Trotoar dan Median Jalan
Pembersihan Pasar
Pembersihan dan Pemeliharaan Sarana dan Prasarana lain.
Pengolahan Sampah

Melalui langkah-langkah tersebut, siswa diharapkan dapat memahami pentingnya kebersihan lingkungan dalam mata pelajaran IPS di SD. Selain itu, siswa dapat ikut menjaga kebersihan lingkungan dimulai dari lingkungan. Begitu pula mereka akan menyadari bahwa menjaga kebersihan lingkungan memberikan dampak positif bagi kesehatan, keindahan lingkungan, dan keberlangsungan hidup yang lebih baik.

VBA Excel Loop Through Columns

VBA Excel Loop Through Entire Columns ( One Column Multiple Rows )

'declare a variable called i of type Long.

Dim i As Long

'Loop through entire Rows

'enters the value 100 into the cell at the intersection of row 1 and column 1 (A) until the cell at the intersection of the last rows of the Excel worksheets and column 1 (A).

For i = 1 To Rows.Count

Cells(i, 1).Value = 100

Cells(i, 1).Font.Bold = True

Next i

Note:

worksheets can have up to 1,048,576 rows in Excel 2007 or later. No matter what version you are using, the code line above loops through all rows. Warning: It might hang up you computer, if you have too much data.
One/1 in Cells(i, 1) can change to column name, example: Cells(i, "A")

VBA Excel Loop Through Entire Columns Based On Certain Conditions

Next, we color all values that are lower than the value entered into cell D2. Empty cells are ignored. Add the following code lines to the loop.

'declare a variable called i of type Long.

Dim i As Long

'Loop through entire Rows

For i = 1 To Rows.Count

If Cells(i, 1).Value < Range("D2").Value And Not IsEmpty(Cells(i, 1).Value) Then

Cells(i, 1).Font.Color = vbRed

End If

Next i

Bibliography:

https://www.excel-easy.com/
https://courses.lumenlearning.com/

Show The Developer Tab Of The Microsoft Office Excel

Fungsi Menu Pada Microsoft Excel 1

Fungsi Menu Pada Microsoft Excel 2

Fungsi Menu Pada Microsoft Excel 3

Some Of Microsoft Excel Function

Contoh Rumus Excel 1

List All Enabled PHP Extension

How To Check PHP Version

Selasa, 25 Juni 2024

Number Place Value

Write this following large number in English Numeration and read it!

5.301.052 = 5.000.000 + 300.000 + 1000 + 50 + 2 read as five millions three hundred one thousand and fifty two.

NOTES

A large number is read by every 3-digit number grouped from right such as ones, tens, hundreds place with naming for the unit of one, thousand, million, billion and so on. For writing large numbers, we give space for every three-digits.

<< Back To Topics: Subject Topics Of Math

Bibliography

Mathematics For International Student;Michael Haese et. al.;Haese Mathematics

Primary Schools National Mathematics Textbook;Department of Education, Papua New Guinea with Japan International Cooperation Agency.

https://byjus.com/

https://www.k5learning.com/

place value, math, mathematics, counting, number, school, school lesson, school subject, school course

Senin, 24 Juni 2024

Latex Vertical Addition

These are Latex source code for Vertical Addition in Mathematics:

\documentclass{standalone}

\usepackage{tgbonum}

\begin{document}

\large{}

\begin{tabular}{c@{\,}c@{\,}c@{\,}c@{\,}c@{\,}c@{\,}c}

& & 1 & 1 & & 1 & \\

& & {\Huge 4} & {\Huge 5} & {\Huge .9} & {\Huge 3} & {\Huge 2} \\

& & {\Huge 1} & {\Huge 7} & {\Huge .4} & {\Huge 2} & {\Huge 6} \\

+ & & {\Huge 7} & {\Huge 3} & {\Huge .0} & {\Huge 3} & {\Huge 2} \\

\hline \\

& {\Huge 1} & {\Huge 3} & {\Huge 6} & {\Huge .3} & {\Huge 9} & {\Huge 0} \\

\end{tabular}

\end{document}

Output:

to learn Available document structure commands or top matter, click Document Class and Document Structure In Latex.
to learn specify the whitespace margin around the following page and Drawing Tikz Picture in Document Class Standalone, click Latex Document Class Standalone 1.

<< Back to Study About Draw In Latex

<< Back to Learn About Latex List 1

<< Back to Learning Latex RoadMap

to learn Font Size In Latex >

Bibliography

l,atex equation, math latex, latex math and science document example,

Vertical Addition ( math equation )
Number Line In Latex ( latex equation )
Circle Theorem Using Latex 1 ( latex equation )
Bentuk Aljabar 1 Dalam Bentuk Latex ( latex equation )
Latex Standalone Margin
Latex Standalone Unique Page Per Equation Without White Space
Post about latex equation
Line Break And Paragraph In Latex
Learn About Latex List 1
Bidang Datar 1
Simbol Matematika
Math Symbol 1
Istilah-istilah matematika dalam bahasa inggris 1
Garis
Besaran Dalam Fisika 1
Kamus IPA 1
Study About Microsoft Office 1
UML Diagram List

Punctuation

Apostrophe '

Colon :

Comma ,

Dash —

Ellipsis …

Hyphen –

Parenthesis, Bracket, Braces ( ) , [ ] , { }

Period/Full Stop .

Question and Exclamation ? !

Quotation “ ”

Semicolon ;

to learn Shorten Form, you can click Shorten Form (Contractions) List In English >

to learn Punctuation And Other Symbols In Unicode Character, click on Symbol And Syntax >

to learn Punctuation And Other Symbols In Unicode Character, click on Symbol And Syntax 2 >

to learn Punctuation In AlphaNumeric Character, click on AlphaNumeric Character >

Bibliography

https://www.lynchburg.edu/ ( university )

https://www.reading.ac.uk/ ( university )

english grammar, english structure, mark, apostrophe mark, colon mark, comma mark, dash mark, ellipsis mark, hyphen mark, parenthesis mark, bracket mark, braces mark, period mark, full stop mark, question mark, exclamation mark, quotation mark, semicolon mark, punctuation mark

AlphaNumeric Character

Symbol And Syntax

Symbol And Syntax 2

Microsoft Word Modern Equation Structures

Visual Basic KeyAscii

Parts of Speech dalam Bahasa Inggris

Parts of Speech Dalam Bahasa Inggris Ada Beberapa Macam :

Noun (Kata Benda)
Pronoun (Kata Ganti)
Verb (Kata Kerja)
Adjective (Kata Sifat)
Adverb (Kata Keterangan)
Preposition (Kata Depan)
Conjunction (Kata Hubung)
Interjection (Kata Seru)
Determiner (Kata Penjelas)
Article (Kata Sandang)

Common Dialog Control In Visual Basic Classic

These are Common Dialog Control Properties and Method:

Dialogue Box	Purpose/Property	Method
Colour	The Color property is used to determine which colour was selected.	ShowColor
Font	to display a list of fonts that are available.	ShowFont
Open	to display the dialog to open files.	ShowOpen
Print	to display the dialog to print files.	ShowPrinter
Save As	to display the dialog to save files. The FileName property is used to determine file name specified by the user.	ShowSave

Open And Save As Dialogue Box

CommonDialog1.Filter = "Bitmaps (*.BMP)|*.BMP"

'== Bitmaps (*.BMP) is display to user

'== *.BMP to filter the format file extension

CommonDialog1.DefaultExt = "BMP"

CommonDialog1.FileName

CommonDialog1.ShowOpen

CommonDialog1.ShowSave

CommonDialog1.InitDir

Colour Dialogue Box

CommonDialog1.Flags = &H1&

CommonDialog1.Color

CommonDialog1.ShowColor

Font Dialogue Box

CommonDialog1.FontBold

CommonDialog1.FontItalic

CommonDialog1.FontName

CommonDialog1.FontSize

CommonDialog1.FontStrikethru

CommonDialog1.FontUnderLine

CommonDialog1.ShowFont

Print Dialogue Box

CommonDialog1.CancelError = True '== Err.Number = 32755

CommonDialog1.ShowPrinter

commondialog, commondialogue, component

Minggu, 23 Juni 2024

Commonly Used HTML, CSS, JS Units

pixel (px), percent (%), em, and rem units.

Commonly use in website style ( HTML, CSS, JS ): font-size, padding, border, margin, width

Bibliography

https://developer.mozilla.org/en-US/

https://www.digitalocean.com/

https://www.w3schools.com/

Sabtu, 22 Juni 2024

How To Launch Command Prompt

How To Launch cmd.exe / The Command Prompt (cmd.exe)

Method 1 − Go to C:\Windows\System32 and double click on the cmd file.

Method 2 − Via the run command :

Open the Start menu and click All apps in the upper-right corner.
Scroll through the list of apps and click Windows Tools.
Click Run
Type cmd to run Command Prompt application.

How To Launch cmd.exe To open with administrative privileges,

Open the Start menu and click All apps in the upper-right corner.
Scroll through the list of apps and click Windows Tools.
Right Click Run and choose Run as administrator.
Type cmd to run Command Prompt application.

command line, terminal software, shell program

Bibliography

https://www.howtogeek.com/

https://www.minitool.com/

https://www.wikipedia.org/

Top Command Prompt

Comment In Batch, Registry, PowerShell, Bash File

Common Windows Run Commands 1

ER-Model Of A Database

The purpose of a database is to store information about certain types of objects or entities.

Entity Class = Table name.

Entity=a data / row of a table.

Entity Set = set of data / rows In table.

Attributes are used to include information that we want in the database. Attributes = Field, Columns

The Entity-Relationship Model Of A Database Sample

LIBRARY database

Books entity class.

ISBN attribute.
Title attribute.
Price attribute.

Authors entity class.

Author_Id attribute.
Author_Name attribute.
Author_Phone attribute.

Publishers entity class.

Publisher_Id attribute.
Publisher_Name attribute.
Publisher_Phone attribute.

Contributors entity class.

Contributor_Id attribute.
Contributor_Name attribute.
Contributor_Phone attribute.

Table Scheme

Syntax:

Table_Name ( Field_Name_1, Field_Name_2, ... )

Example:

Entities And Attributes List:

Authors (AuID#,AuName,AuPhone)

BookAuthor (ISBN,AuID)

Books(ISBN#,Title,PubID,Price)

Publishers (PubID#, PubName, PubPhone)

Contributors (Contributor_Id#, Contributor_Name, Contributor_Phone)

# is notation to primary key

to read about foreign key notation, click : Entity Relationship Diagram ( ERD ) 2 >

to read about DDL, DQL, DML, DCL and TCL Commands, click : DDL, DQL, DML, DCL and TCL Commands >

Next: Entity Relationship Diagram ( ERD ) 2 >

Bibliography

Introduction To Database Management System;Dr. Satinder Bal Gupta et. al.;University Science Press

Access Database Design & Programming;Steven Roman;O'Reilly

ERM, Entity Relationship Diagram, erd, data column, data row, program design, table sample, software design, application design

Kamis, 20 Juni 2024

Latex Package To Handle Graphic

These are ordinary latex Package list To Handle Graphic:

amscd package.*

amscdx package.

amsmath package.

argumentation package.*

bargraph-js package.*

blox package.

byrne package.

causet package.

celtic package.

chemfig package.

chemobabel package.

chemplants package.

float package.

graphics package.
graphicx package.*

grffile package.

incgraph package.

ms package.

pgf package.

pgfplots package.

pict2e package.

picture package.

tikz package.

tikz-3dplot package.

* not available on all latex Miktex or TexLive version. You must to installed separated.

Bibliography

Facebook Groups LaTeX Learning by Doing

Facebook Groups Learn-LaTeX

https://ctan.org/

https://web.mit.edu/ ( university )

https://www.cmc.edu/ ( university )

https://www.kwasan.kyoto-u.ac.jp/ ( university )

latex document formatting, latex table package, \usepackage{package_name}

Jumat, 14 Juni 2024

Keyboard Shortcuts For Navigating In Excel Cells

Keyboard Shortcuts For Navigating In Microsoft Office Excel Cells

To do this	Press
Move one cell to the previous cell in a worksheet	Shift+Tab
Move one cell to the next cell in a worksheet.	Tab key
Move one cell up in a worksheet.	Up arrow key
Move one cell down in a worksheet.	Down arrow key
Move one cell left in a worksheet.	Left arrow key
Move one cell right in a worksheet.	Right arrow key
Move to the edge of the current data region in a worksheet.	Ctrl+Arrow key
Enter the End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. If the cells are blank, move to the last cell in the row or column.	End, Arrow key
Move to the last cell on a worksheet, to the lowest used row of the rightmost used column.	Ctrl+End
Extend the selection of cells to the last used cell on the worksheet (lower-right corner).	Ctrl+Shift+End
Move to the cell in the upper-left corner of the window when Scroll lock is turned on.	Home+Scroll lock
Move to the beginning of a worksheet.	Ctrl+Home
Move one screen down in a worksheet.	Page down
Move to the next sheet in a workbook.	Ctrl+Page down
Move one screen to the right in a worksheet.	Alt+Page down
Move one screen up in a worksheet.	Page up
Move one screen to the left in a worksheet.	Alt+Page up
Move to the previous sheet in a workbook.	Ctrl+Page up
Open the list of validation choices on a cell that has data validation option applied to it.	Alt+Down arrow key
Move to the cell in the upper-left corner of the window when Scroll lock is turned on.	Home+Scroll lock
Exit the floating shape navigation and return to the normal navigation.	Esc
Scroll horizontally.	Ctrl+Shift, then scroll your mouse wheel up to go left, down to go right
To return to where the cursor is, when Scroll lock is turned on.	Ctrl-Backspace
Open the Go To dialog box.	F5

< to learn Microsoft Office Excel Graphical User Interface (GUI) : Microsoft Excel GUI Parts

navigate, navigation, navigates, navigator, user interface (UI), user experience (UX)

How To Check Gradle Version

<< How To Check Your Java Version

<< Set The JAVA_HOME variable

open Command Prompt
type
gradle --version
or
gradle -v
then press Enter on keyboard, to run gradle and display the version.

Bibliography

https://gradle.org/

https://www.javatpoint.com/

https://www.tutorialspoint.com/

build, build script, compile, tools, programming, coding, software development

Set The JAVA_HOME variable

Set The JAVA_HOME Variable In Microsoft Windows 11

<< Previous lesson: Default Java Path Environment

Let’s locate the directory where the JDK is installed on our system, and note down the path to this directory.
Open the Start menu and click All apps in the upper-right corner.
Scroll through the list of apps and click Windows Tools.
Click Control Panel.
Under View by, click Large icons to view a list of all Control Panel items, then select System.
In the System window, click on Advanced System Settings on the left sidebar.
In the System Properties window (Advanced tab):

Click the Environment Variables button.
Under the System Variables section, find JAVA_HOME.
Click Edit to modify the existing variable, or New to create a new one.
In the Variable Name field, enter JAVA_HOME.
In the Variable Value field, enter the path to our JDK installation directory (e.g., C:\Program Files\Java\jdkX.X.X_XX).

In the System Properties window, select the Path variable under the System Variables section. Click Edit, and add %JAVA_HOME%\bin to the list of paths if it’s not already there.
Click OK to apply the changes and restart the computer to ensure the changes take effect.

Set The JAVA_HOME Variable Via The Command Line

If you would prefer to set the JAVA_HOME (or JRE_HOME) variable via the command line:

Open Command Prompt (make sure you Run as administrator so you're able to add a system environment variable).
Set the value of the environment variable to your JDK (or JRE) installation path as follows:
setx /m JAVA_HOME "C:\Program Files\Java\jdkXX.X.XX.X"
Close and start Command Prompt window again to reload the environment variables then use the following command to check the it's been added correctly.
echo %JAVA_HOME%
You should see the path to your JDK (or JRE) installation.

NOTES: X is version based on your Java installed version.

Bibliography

https://support.microsoft.com/en-us

https://www.baeldung.com/

https://www.groovypost.com/

install, setup, installation

Different Activities in Android Programming

These are activity in Android Programming:

MainActivity
AppCompatActivity
FragmentActivity
No Activity.
Basic Activity.
Bottom Navigation Activity.
Empty Activity.
Fullscreen Activity.
Google Admob Ads Activity.
Google Maps Activity.
Login Activity.
Primary/Detail Flow
Navigation Drawer Activity
Settings Activity
Scrolling Activity
Tabbed Activity
Fragment + ViewModel
Native C++

Bibliography

https://www.inixindo.id/

https://www.naukri.com/

https://developer.android.com/

Android Activity LifeCycle

An Activity is an application component that provides a screen with which users can interact in order to do something, such as dial the phone, etc.

Android App Activity Lifecycle

When you launch your application, the following methods are executed in order:

onCreate
onStart
onResume

At this point, the activity is visible to the user and they can interact with it.

In our example, we have a button in Activity A that allows the user to navigate to Activity B.

When the user clicks the button, the following methods are executed:

onPause (in Activity A)
onCreate (in Activity B)
onStart (in Activity B)
onResume (in Activity B)

Now, Activity B is visible to the user and they can interact with it. Activity A is in the paused state.

If the user presses the back button, the following methods are executed:

onPause (in Activity B)
onStop (in Activity B)
onRestart (in Activity A)
onStart (in Activity A)
onResume (in Activity A)

Now, Activity A is visible to the user again and they can interact with it. Activity B is destroyed.

If the user presses the back button again, the following methods are executed:

onPause (in Activity A)
onStop (in Activity A)
onDestroy (in Activity A)

Now, both Activity A and Activity B are destroyed and nothing appears on the screen.

Bibliography

https://blog.stackademic.com/

https://developer.android.com/

https://medium.com/

https://www.tutorialspoint.com/

Kamis, 13 Juni 2024

Forming Noun In English

Here are all the rules which will help you change a verb, adjective, and common noun into a noun.

Add '-al' to verbs
Add '-ance' or ‘-ence' to verbs
Add '-ment' to verbs
Add '-ness' or '-ess' to verbs
Add '-tion' or '-sion' or '-ion' to verbs
Add '-ation' or '-cation' or '-ition' to verbs
Add '-t' or '-th' to verbs
Add '-y' to verbs
Add '-er' or '-or' or '-ist' or '-ar' or '-ant' or '-int' to verbs
Add '-age' to verbs
Add '-ure' or '-ture' or '-ature' to verbs
Add '-ing' to verbs
Add '-ce' to adjective
Add '-y' or '-ty' or '-ity' or '-ry' to adjective.
Add '-ness' to adjective.
Add '-cy' to adjective with last letter is '-t'.
Add '-hood' to common noun.
Add '-ship' to common noun.
Add '-cy' to common noun.
Add '-an' or '-ian' to common noun.
Add '-let' to common noun.

Bibliography

https://myenglishgrammar.com/

https://leverageedu.com/

https://www.uefap.com/

suffix, grammar, part of speech, english lesson, derivation noun, word formation, vocabulary building

Cari Blog Ini

Sabtu, 29 Juni 2024

Related Post

Jumat, 28 Juni 2024

SQL Reference Sheet free download in PDF format.

Download ( studydrive )

Related Post

Related Post

Problem

Solution

Bibliography

Related Post

Kamis, 27 Juni 2024

Non AlphaNumeric Characters

Bibliography

Rabu, 26 Juni 2024

Related Post

Bibliography

Related Post

Notes

Stereotypes

Related Post

Related Post

VBA Excel Loop Through Entire Columns ( One Column Multiple Rows )

Note:

VBA Excel Loop Through Entire Columns Based On Certain Conditions

Bibliography:

https://www.excel-easy.com/https://courses.lumenlearning.com/

Related Post

Selasa, 25 Juni 2024

NOTES

Bibliography

Related Post

Senin, 24 Juni 2024

Output:

Bibliography

Related Post

Bibliography

Related Post

Open And Save As Dialogue Box

Colour Dialogue Box

Font Dialogue Box

Print Dialogue Box

Related Post

Minggu, 23 Juni 2024

Bibliography

Sabtu, 22 Juni 2024

How To Launch cmd.exe / The Command Prompt (cmd.exe)

How To Launch cmd.exe To open with administrative privileges,

Bibliography

Related Post

The Entity-Relationship Model Of A Database Sample

Table Scheme

Bibliography

Related Post

Kamis, 20 Juni 2024

Bibliography

Related Post

Jumat, 14 Juni 2024

Keyboard Shortcuts For Navigating In Microsoft Office Excel Cells

Related Post

Bibliography

Related Post

Set The JAVA_HOME Variable In Microsoft Windows 11

Set The JAVA_HOME Variable Via The Command Line

Bibliography

Related Post

Bibliography

Related Post

Android App Activity Lifecycle

Bibliography

Related Post

Kamis, 13 Juni 2024

Bibliography

Related Post

Various Other Posts

https://www.excel-easy.com/
https://courses.lumenlearning.com/