The goal of this thesis was to learn how to create a functional Android application that uses SQLite database. The application that was created for the thesis was designed during the Digital Service Development -course. It was made for the learning and rehearsing of Japanese characters, kanji. The client of this work was Häme University of Applied Sciences to whom the application was made for as an example to be used in teaching. The example application was designed as a quiz application that could be easily modified by changing the database.

The theoretical section of this work handles the basics of Android programming since there was no previous experience in it. The SQLite database engine is also handled in this section. The theory was gathered mainly from Android Developers -site and from Jukka Harju’s Finnish book about the basics of Android programming. The theory for the SQLite database was mainly from SQLite’s homepage. This was all put in action in the practical section of the thesis where the application was created.

Android turned out to be rather easy to learn for a beginner and there was comprehensive documentation about it. The use of Google’s own application Android Studio was also very user-friendly and easy to learn. Especially creating the user interface was quite effortless.

The development of this application is planned to continue even after this thesis. The features planned to be implemented in the application next include a studying section, more exercises and the possibility to create your own lists of kanji for the rehearsing section.