Wednesday, 19 September 2018

5 Most Popular AI Programming Languages to Learn by 2019

So much changes is taking place in the field of programming.

Easy to Learn and Free
1. Python
2. R Programming
3. MatLab Script
4. Java
5. Prolog
Where Do I Start


The shift is now towards Automation, Artificial Intelligence and Machine Learning. This  I could tell you because in my 20 years of experience as a programmer, so much have change.
Languages I started with in 1998 like COBOL, FORTRAN and BASIC are not very useful to me at this time. But this time, the change is happening very fast as the shift is towards AI programming.


Easy to Learn and Free

The interesting thing which I would like to let you know is that the new AI programming, are quite easy to learn, at least you don't have to go through much the difficult learning process we passed through in our time. Additionally, the tools you need to learn this programming languages are free. You don't need to pay or licences for the compilers (IDEs or editors)

There are three languages you need to start to learn.




1. Python

Python is one of the most popular AI programming languages and currently being used in various colleges and universities in AI-related courses. Python is very easy to learn and lightweight as well. So you can set up Python in your system in few minutes.
Python can be used to write numerical programs and can be used to build web applications as well by using Django web framework
Python has support for object oriented programming, procedural programming as well as functional programming.
If you want to get started, these are some tutorials for beginners




2. R Programming Language

R is very useful in the area of Data Science in the analysis of data sets in Big Data analysis and other areas of AI Programing and Machine Learning.
R programming language can be used to produce graphical plots of relations and to develop machine learning models. Another interesting factor about R is the availability of a robust IDE called R-Studio which you can download for free.




3. MatLab Scripting

MatLab is actually a tool for Mathematics, Data Analytics, Machine Learning and various areas of AI such as fuzzy logic and neural network.
But the important aspect of MatLab is that it allows you to write scripts which can run in its built-in compiler and allow you to create plots and visual representation of your model using the Simulink Toolkit which is part of MatLab.
The downside of MatLab is that you do need to pay to get the application, I don't think there is yet a free version of MatLab


4. Java (JavaScript, AngularJS)

While Java is a general object-oriented programming language, it is also a good choice for AI Programming. This is especially true if you have some knowledge of Java.
Java provides a number of benefits which includes the following:
  • Easy to use
  • Free development tools
  • Incoporates Swing and AWT Toolkits (for GUI)
You can get started with Java with these tutorials for beginners




5. Prolog

This language has been around of a while and it can be considered the only programming language specifically design for AI. While it would not be the most popular at this time, I added it to my list as it has the benefit of being easy to learn and helps you improve your knowledge of AI programming.


Where Do I Start

If you are already a programmer, then you could start by focusing on the core AI programming Languages. If you are a beginner then you can start by taking the beginner courses below.
One thing that helped many programmers is getting involved in mini-programming projects such as Developing a Simple Calculator. I made a step by step for this which is very easy to follow and fee free to leave me a comment if you have any challenges.







Saturday, 15 September 2018

My Research Tour Across Europe(Day 5) - Home at Last! - Back From Serbia to Budapest

Hey folks!
Still on my Research tour. Guess what? Today would be exceptional. I'm waking up in Serbia today, and hopefully would be spending the night in Budapest, hundreds of kilometres away. Such is the life of a researcher.
Just as you know, I would first go about breakfast.

1. Today's Breakfast
I had a simple breakfast as usual. I wish you could join me!


2. Packing for Departure
I would have done this the previous night, but I'm doing it now since I have some time.


3. At the Subotica Railway Station, Serbia
This is the same railway station I arrived. This  are some of the pictures of the train.

4. A Beautiful Train Ride
They call it railJet and it’s really a rail jet because you have the same feeling as in an air plane.
Air transportation, they say, is the safest means of transportation. But we all know that is not true. It’s the rail. This would be a discussion for a different time.



5. At the Keleti Payaudvar Railway Station in Budapest, Hungary
Disembarking from the train, it's been an interesting 3-hour train-ride from Serbia to Budapest


6. Home at Last
Would you not believe it! I'm back to my lonely home. Sure, cute little but lonely home really.



7. Preparing Welcome Dinner
After a long trip, I deserve a welcome-home treat. So I’ll take a special meal tonight. I think I have some stuff in the fridge. But for the first time in my stay in Europe, I’ll be having a bottle of wine in my fridge.




My Research Tour Across Europe(Day 3) - SISY2018 Conference Day 2 in Subotica, Serbia

This is the second day of the conference and actually 'my day'. Guess what? I'm in the program today and would talk about my paper: "Performance Analysis of the Microsoft .Net and Java-Based Implementations of REST Web Services"




The program today starts at 9:00 and I need to be there in time. But as you know,  I need to look for a breakfast and then we had a good lunch in Hotel Galleria.

This is Prof. Imre J. Rudas of the Obuda University, Budapest Hungary, receiving some souvenir.




1. At the Subotica Tech
This is where the program would take place for today and since I've not been here before, I left home a little earlier though the venue is just a few minutes walk from my hotel room


2. Highlights of Session on Intelligent Robotics
What I enjoyed most in this part is the presentation by a professor from the Obuda University. He gave about 30 minutes presentation on the theme: Modbus-OPC-UA Wrapper using Node.RED and IoT-2040 with application in the water industry.

3. Highlights of Session on Intelligent Mechatronics and Intelligent Manufacturing Systems
The question is: What is Mechatronics? Mechatronics is a multidisciplinary field of engineering which combines

4. Highlights of Session on Informatics
This is the  session I did my presentation and that is me defending my 4-month-long work. I also made some mew friends here. But there were some preceding presenters also did a very good job.

For example, the first presenter, spoke on the theme: 'Magic Dashboard: Software System for Real-Time Development Tool Tracking'. He explained that this system would be used to gather data from a variety of project management data sources. They used tools such as Go, ReThinkg, Gin and Viper. They further did a demo on how the system works.



The second presenter spoke on the theme: 'Diaspora Mapping and Collaboration Platform for Expatriates'. They  did a demo using data from SzekelyData. I don't know what that is.

The third guy presented on 'Mobile Application for Daily Challenge Management'.  He explained that the challenges to be managed should meet three different criteria.
  • Measurable
  • Finite
  • Scalable
The fourth presenter,  a team of two presented on the team: 'Taboo: Chord Sheet Editor and Manager Web Application'. This is a system that could be used to create sheet music chords from a piece of music. They did a demo using  Eric Clapson's Wonderful Tonight and show how you can generate the chord sheet using their application.

The fifth presenter made a presentation on a software system they developed under the theme: 'EKETour - Software Platform for Organizing Tours'.





My Research Tour Across Europe(Day 4) - SISY2018 Last Day of Conference in Subotica, Serbia



Today, Saturday, 15th September 2018 is the last day of the Conference in Subotica Serbia.
The program would conclude quite early and then we would go for lunch in some local place.

During the Session on Conceptual Intelligence, my friends Tamara Katic and Nemanja Milicevic presented a paper with title: 'Comparing Sentiment Analysis and Document Representation Methods of Amazon reviews.

Beautiful Tamara and Nemanja, both from the University of Novi Sad, Serbia.
Novi Sad is like the second most popular city in Serbia after Belgrade.



This is me at the reception of the Subotica, Tech

In this pics is a friend of mine, Silviu-Iulian Toc of the University Politehnica Polisoara, Romania. He presented a paper on Friday during the session on Intelligent Mechatronics and Intelligent Manufacturing Systems. The title of his paper is: 'Modbus-OPC UA Wrapper using Node-RED and IoT-2040 with Application in Water Industry'. He did quite well as the presented with Adrian Korodi of the same school.

We went to some local place for lunch along Kelebia road.



Some ancient fireplace I saw at the place, I've not seen this before

One thing I could remember is that a home-made wine called 'Palinka' was served.


7. A Review of the Conference
It’s been three long days of conference and now I’m just thinking to myself: ‘what have achieved, being here?’.
Sure I’ve achieved so much. These are just some of them:
  • Of course I presented my paper
  • I added a new country to the list of countries I've been to, Serbia
  • Connected with scholar from different universities including: Budapest University of Technology and Economics, Obuda University, Simon Fraser University, Vancouver, Subotica Tech and other





Friday, 14 September 2018

Dinner at the 16th IEEE International Symposium on Intelligent Systems and Informatics in Subotica, Serbia



The dinner was held in Hotel Galleria, a classy hotel in the city center of Subotica Serbia.
These are some of the sights and sounds.

At the dinner table. Opposite me is Prof. Liljana Trajkovic of the Simon Fraser University, Vancouver, Canada



Two persons to my left is Prof. Sonja Ristic of the University of Novi Sad, Serbia. After her is Levente Kovacs, the IEEE, Hungary, Serbian chair

A photograph with renown Professor of robotics Peter Odry of the Obuda University, Hungary.
Prof. Peter Odry and his students build the Szabad(ka) II Robot



Me and my friends Tamara and Nemanja at the Dinner in Subotica
Me with Prof. Ljiljana Trajkovic




My Presentation in SISY2018 Conference in Subotica Serbia

The event was the 16th IEEE International Conference on Intelligent Systems and Informatics.

From Left to Right: Prof. Peter Krammer of Institute of Informatics, Slovak Academy of Sciences, Blatislava, Slovakia; Kindson Munonye of the Budapest University of Technology and Economics; Prof. Laszlo Horvath of the Obuda University.


Prof. Laszlo Horvath spoke on 'Contextual Modelling of Engineering Structures while Prof. Peter Krammer spoke on 'Enhanced Data Modelling Approach With Interval Estimation'

This are the highlights of my presentation:
Starting my presentation.
My new friends Tamara and Nemanja helped me take pics while during my presentation.

Research Objectives
The research would establish the performance trade-off of the .Net and the Java-based REST API implementation with respect to various parameters
  • Information system development time could be reduces
  • Well-defined basis for feasibility and performance
  • Right choice of API implementation technology

REST API Specification
  • Resource Identification via resource-based URIs
  • HTTP Methods
  • HTTP Status Codes
  • HATEAOS Compliance

Evaluation Criteria
  • Response Time
  • Code Complexity
  • Execution Speed
  • Throughput
  • Cost



REST Architecture
Explaining My Model by the REST Architecture

The REST Architecture for Mobile Services Application
Conclusion
Java-based APIs would be suitable for B2B scenarios such as Online Transaction Processing (OLTP) applications that periodically transfer data across data stores
APIs developed using the .Net Framework for OLAP scenarios requiring frequency and successive updates
Since data-driven applications are created using modular approach, each module could be developed based on requirements

Limitations of  the Study
  • Use of Generated Data
  • Focus of only response time
  • Limited Data Size
  • Simulated Environment




My Research Tour Across Europe(Day 2) - SISY2018 Conference Day 1 in Subotica, Serbia



This is the first day of the conference.
But guess what, the programs starts by sometime by noon! So I have some time to make this write up for you and maybe let you know what the day's activities would look like. And sure I have get to the venue early.
First, I need to look for a breakfast.


2. The Sights and Sounds of Serbia
Before now, I use to associate Serbia to the First World War. But right now, I am on ground and could not see anything that relates this beautiful city to any kind of violence as everywhere is quite peaceful. Take a look at some of the shots.



3. At the City Hall
This is the City Hall, where the first part of the program would take place. So I did the necessary registrations here

4.  Registration and Opening Ceremony
Just a formal process of registering the attendees. We receive our badge and conference pack containing a flash drive and the booklet. Was kind of boring though but it’s part of the initial procedures. I made some friends here.
Professor Levente Kovacs made a speech highlighting the benefit of the conference. He mention that SISY  is a global conference organized in different countries including Africa, Asia and the Middle East.
Imre Rudas made some opening remarks as well.



5. Hightlights  of Plenary Session I (Prof. Philip Chen)
Professor Philip Chen of the University of Macau spoke on the theme: Board Learning System and Its Structural Variation.

He spoke about flat neutral network which helps to eliminate multiple layer neural network. Using so much technical jargon, he explained how the weight can be obtained for flat neutral network. I could clearly see that many of the attendees quickly became bored. He continued anyway and kept speaking and the screen was always filled with cryptic formulas.

He mentioned that Moore’s Pseudo-inverse or gradient descent can be used to obtain solution. Then the mentioned something on sparse-coding, but the explanation was not quite clear to me. 
He also discussed the concept of Broad Learning difference from Deep Learning as well as incremental learning where the following parameters were used.
  • 60000 training samples 
  • 10000 learning samples 
  • Manifold Learning 
How to deal with noisy data - by normalization 



The session chair, Prof. Imre Rudas then asked him: In one sentence, 
Deep Learning: A neutral network that tries to map the inputs to the output using multiple hidden layers

6. Highlights of Plenary Session II (Prof. Ljiljana Trajkovic)
Prof. Ljiljana Trajkovicj of the Simon Fraser University, Canada spoke extensively on 'You and Your Career'.

She started by talking about her career history. She works in the Communications Laboratory at Simon Fraser, Vancouver, British Columbia, Canada.
She spoke about the role of education in our lives and careers. She encourages the audience to try to do their best.

This presenter has a very rich academic and research profile including:
  • Member of Technical staff in AT & T Bell laboratories
  • Research Scientist in Bell Communications Research
  • Visiting prof. at UC Berkeley
  • Prof. Simon Fraser University
Did so much work in communication network including:
  • Modelling and analysis of computer networks
  • Analysis of complex systems and network
She has been a lecturer in nine different subjects in Communication Networks as well as Circuit and Systems
She referenced another presentation with the title 'You and Your Research' and emphasized the need for good preparation so that if the opportunity comes, then you can seize it.

She emphasized the need to develop very good communication skills
She highlighted 5 factors most influential people adopt to rise to the top according to 204 British CEOs
Some of them are:
  • Ability to work with a variety of people
  • Responsibility in in important tasks
  • Need to achieve results
She the talked about IEEE as a non-profit Organisation governed by US laws
IEEE as of the time of this conference has 374,778 members including 41,677 graduate students
She encourages everyone to join professional organization including Young professional organization and Women in Engineering

7. Highlights of Plenary Session III (Prof. Sonja Ristic)
Prof Sonja Ristic spoke on Model- Driven and Domain Specific Language Paradigms in Information System (Re)Engineering Projects
She started by talking about herself. She is a professor in the University of Novi Sad, Faculty of Technical Science.
She say ‘a model is worth more than a thousand words ‘
She highlighted that there are different kinds of people, six categories:
  • Problem solvers
  • Dreamers
  • Researchers
  • Innovator
  • Creator
  • Tester


She talked about Software Engineering as a relatively young field. Also mentioned that software engineers are impatient an often times does not design along with users.
She says that software is abstract while real world is concrete but the says that this statement is not completely factual
She focused on Model-Driven Paradigm
She the mentioned and discussed Multi-Paradigm Information System design tool
She the summaries by highlighting Architecture Driven Modernization mentioning 9 key points:
Model-Dirven paradigms
...
...
She makes a strong statement ‘Engineers must be Responsabile’
If a builder builds a house and does not construct it properly and the house collapses and kills someone, the the builder must be put to death

Article 229 of the code of Hermurabi


9. Back to Hotel Room
Yeah! I’m back to my nice hotel room looking back at the day’s activities. That is me just relaxing as I already had more than enough at the banquet. So I never bothered calling the kitchen

10. Nice Supper and a Good Night Rest!







Thursday, 13 September 2018

My Research Tour Across Europe(Day1) - Budapest to Serbia and Back to Budapest!

The Conference is the 16th International Symposium on Intelligent Systems and Informatics and I have been scheduled to attend. It holds in the city of Subotica in Serbia from 13-15th of September 2018. It is titled SISY2018

Let me tell you about this epic trip.
I would also tell you how the Serbian police refused me entry into Serbia and sent me back to Budapest, Hungary.


Leaving Home
It was a beautiful Wednesday, morning and the weather forecast for the day was quite good at a temperature or about 20 degrees.
I took my breadfast of rice and egg source and took off to the busy Keleti Train Station
This is my little home and I'm all ready to go.
This is my little home and I'll really miss playing my keyboard


This is me and sure I'm all ready to leave so let's make it to the train station.

The Keleti Payaudvar railway station is quite busy and I'll be catching a train by 11:57.
I hopped into the train an I have a room all to myself. And to tell you the truth, this is my first time making an international journey by train,


Just a little about Budapest, this tram car is said to be the longest tram-car in the world. I've not confirmed it though.
Longest Tram Car in the World- Budapest Tram 4-6
I would also show you around on the smooth ride so far from Budapest to Serbia. I took some pictures of some towns along the line.


The initial part of the train ride before thing started going wrong



Stepped  outside my cabin  


With some friendly passenger travelling to Serbia


Sleeping baby in the cabin, I could not speak so loud as I don't want to wake up the sleeping child.

Then I'm Refused Entry into Serbia
First, I was not with the original of my Hungarian residence permit. So when we got to the Hungarian border town of Kelebia, the border police requested for my document, so I explained I'm not with the original so I provided a copy. They accepted, and after some check in their office, they could see my records were ok. So they stamped my passport and we moved on.


Then we entered Serbia at the border police checkpoint. They asked for the same thing, I explained that I just have a copy. The policeman says he needs to original and I pleaded that he should check their database for my records. This did not work and he insisted that I would not enter the country and must go back to get the original document. All effort by his assistant failed and all of a sudden, I'm on a train going back to Budapest after touching Serbia.

 Its so sad that I need to go all the way back just to get the original of a document.


This  is so sad
I arrive Budapest at about 9 pm. I prepare some rice and egg source and got a little chicken from the fridge. Took my supper, slept off and was ready for the next day

When I did some little finding, I figured out that:
  • Serbia is not a member of the European Union
  • Serbia is not one of the Shengen Countries
So I get the point now. They don't have access to international records of citizens of the EU countries
This is the end of the First Day, I would provide you with update for each day. Thanks for reading

Thanks to the my supervisor Dr. Peter Martinek and thanks to the organizers of The Conference, 16th International Symposium on Intelligent Systems and Informatics- SISY2018



Sunday, 9 September 2018

Data Structions and Algorithms Tutorial 1 - Introduction to Algorithms

This is a series of tutorial on Data Structures and Algorithms for Computer Science/Engineering students.
After taking this tutorial you would be able to write any algorithm as well as write the program in any programming language.

What we are going to cover in Tutorial 1:
  1. What are Algorithms?
  2. Defining the Sorting Problem
  3. Factors Determining Choice of Algorithm
  4. Applications of Algorithms
  5. Characteristics of Algorithms
  6. What are Data Structure?
  7. What is NP-Complete Problem?
  8. Parallelism
  9. Final Notes


1. What is an Algorithm


An Algorithm is defined as "a well-defined computational procedure that takes as input a value or set of values and then produces a value or set of values a its output".
In other words, an algorithm is a sequence of steps taken to process a given input to produce an output.
We can also describe an algorithm as a procedure for solving computational problems

2. Sorting Problem Example


How can we use an algorithm to solve a sorting problem? We can do that in three steps:
Step 1: Determine the input
Step 2: Determine the output
Step 3 Define the relationship

In this case we have:
Input: A sequence of Numbers (a1, a2, ... , an)
Output: A reordering of the input sequence (a1, a2, ... , an)
Relationship: The reordering is such that a1' is ≤ a2' ≤ ... ≤ an'

3. Factors Determining Choice of Algorithms


An algorithms may be able to solve the given problem. In that case, we say it is correct. But that does not mean it is the algorithm of choice for the problem
The following factors determine the choice of algorithm to use for particular problems:
  • The number of items to be sorted
  • Any constraints on the value of the items
  • The architecture of the computer to be used
  • Type of storage device (eg memory, disk, tape etc)

4. Applications of Algorithms


Why are algorithms so important in computing and problem solving? This is because it applies to a wide array of areas. Let's look at some areas:

In DNA Data Storage and Analysis: the human DNA contains 100,000 genes and is made up of 3 billion chemical base pairs.
This this data needs to be stored for hundreds of millions of people such that when DNA tests are carried out on someone, the persons DNA data could be compared to the stored record. To achieve this storage and comparison, complex algorithms are used to develop the required tools.

Internet Traffic: How long does it take to search through your computer for a particular file if you have only the name or just part of the name? Now think of the internet with millions of millions of petabytes of data located in countless number of disks in datacentres around the globe. Sophisticated algorithms make is possible to perform this search in the shortest possible time. So next time you visit Google to do a search and get results in few seconds, you should be appreciate the amount of work we Computer Scientists have put into place!

E-commerce: Complex algorithms are used to manage large volume of transactions online on E-commerce sites. This includes managing millions of credit card information and data transfer between banks and other organizations while maintaining privacy requirements.

Resource Allocation: In the manufacturing process and other industries, there is need for scarce resources to be allocated in the most beneficial manner in order to minimize cost of production and to maximize profit. This is achieved using algorithms behinds the information systems used in managing the processes.

Other Application: Other application areas of algorithms include:
  • Finding shortest distance between two locations
  • Finding a convex hull of a set of points
  • Finding sequences in a large number of dataset etc

5. Characteristics of Algorithms


There are two main characteristics of algorithms you need to know:
  • Algorithms have more than one possible solutions
  • Algorithms have practical applications

6. What are Data Structures


A data Structure is an arrangement for  storing and organizing data to enable easy access and operations. By now you should be familiar with a number of data structures. The simple ones includes Arrays, Lists, Queue, Stack and Linked list. Others are Dictionary and Hash tables. We would examine all of this in subsequent posts.

7. What is an NP-Complete Problem


NP-Complete problem is a term in algorithms used to refer to a problem  that has no efficient solution. There may be algorithms written but the solution cannot be described as efficient.
This concept is important because if a problem is proven to be an NP-Complete problem, then you need not spend the time trying to develop an efficient algorithm.

8. What is Parallelism


This applies to processors such that a number of processors work simultaneously to perform an algorithmic operation. You may be familiar with terms like dual-core, quad-core etc as it applies to CPUs in the modern computer systems.
This concept is important to know because to design an efficient algorithm, we need to have the concept of parallelism in mind.

9. Final Notes


I hope that this introductory note on Data Structures and Algorithms is clear enough. I would try to keep this tutorial simple and clear. I would also be interacting as we would be implementing out algorithms in different programming languages and actually running them on the computer. I would give a step-by-step of every algorithm and program we would write.

Thanks for reading. Do leave a comment if you have any need to.


This Series of Tutorials is based on this course: "Advanced Data Structures and Techniques for Analysis of Algorithms(BMEVISZD05)" offered as a PhD course in Budapest University of Technology and Economics.

Monday, 3 September 2018

Introduction to Machine Learning in .Net (Beginner to Expert)

My name is Kindson The Genius and today, I would introduce you to Machine Learning using .Net. Yes, .net C# programmer can now develop Machine Learning models using the .net framework in visual studio.


In this series of tutorials, I would show you exactly how to do this. We would cover the following:

  1. What is Machine Learning
  2. Machine Learning in .Net
  3. How to Set up ML.Net in Visual Studio

You will also be happy to know that Machine Learning is a very clear and easy to follow topic very much unlike the sound of the name.




1. What is Machine Learning?

Maching Learning is simply a situation where the computer examines a dataset and then use the information to make prediction.
This is the same thing we do everyday, but this time we want the compute to do it simply because it would be faster.

Take an example
Take a look at the table below. The color of the fruit and the weight is provided, and then the last column contains the type of fruit.


In the last record, what do you think would be the type of fruit? You guess right! It would be Grape. The reason follows from the  previous records.
Since grapes in the previous records have a weigh of about 8 to 10 and has a color of green, therefore this must be grape.

Now the color and the weight are called features. The Fruit is called the Class in machine language terms. In this case, there are two classes: Apple and Grape and also two features: Color and Weight.

This is what machine learning is all about: examine the features and determine the class.

This is a typical example of Classification, a branch of machine learning. The other branches are Regression and Clustering.




2. Machine Learning in .Net

Microsoft have provided a package called ML.net that can be added to Visual Studio and used to solve Machine Learning Problems.

To create machine learning problem, there are four steps to follow:

Step 1: Create a new Project
Step 2: Add your data into the project
Step 3: Train the model (the system examines your data to understand it)
Step 4: Make prediction on new data

This are the basic steps we would follow in Tutorial 2 to create a model and use it to make prediction.

3. How to Set up ML.Net

Before you continue to Tutorial 2, do the following:
Create a new Solution in Visual Studio
Add ML.Net Package to your Solution from the Nugget Manager
Download the dataset to your computer from this link
Save it as flowers.txt

Now you are all set, so we proceed to Step 2.





Sunday, 2 September 2018

How to Connect Netbeans to MS Access Database and View Data

In this lesson, you will learn how to connect Netbeans IDE to Microsoft Access database and used MS Access as your data-source in  your Java Project.



Step 1: Create a database in Microsoft Access
You already know how to do this. To be able to follow this lesson:
Name the database LessonDB
Create a table and Name it tblStudents
In the table create four columns
  • ID
  • Firstname
  • Lastname
  • Department
If you have done this correctly, your design view in MS Access would look like shown below:


Add some random data into the table in Access. Say about 5 rows or more. We would be able to open and view this data in Netbeans
For me after adding data to the tables, I have the content of the table as shown below:


Step 2: Create an ODBC datasource
 Go to Control Panel > Administrative Tools > ODBC Data Sources
Click on System DSN.


Click on Add. It displays the Create New Data Source window

Choose Microsoft Access Driver(*.mdb, *.accdb).
Click on Finish. Another window opens up

Help!!!! I could not see any drivers listed!!!!
 The reason for this is that your Operating System is 64 bit while the MS Access is 32 Bit.
Solution
Open the Windows Directory in your C drive and notice this two folders
Inside the they SysWOW64, you will find odbcad32. Open it and continue from there. Add a shortcut to it for easy access.


Now that you have solved that problem, let's continue.

Click on Select, and find the MS Access database we created previously.
Click on OK. This would take you back to the database selection window
Enter a name for the database. For me I used same name LessonDB. (Make sure that MS Access application is closed, otherwise, you can't complete it)
Click on Ok to finish.





Step 2: Create and Application in Netbeans. You already know how to do that.

Click on the Services tab at the left hand side of the screen.
Expand Databases > Drivers
Right-click on ODBC-JDBC Bridge and click on Connect-Using... as shown
It displays the New Connection Wizard dialog box.
Replace the <DB> with the name of the datasource  you created. For me it is LessonDB