reporting is easiest in access itself as it provides templates but here is a simple example using OLEDB in VB .Net 2010 to open and read an access database joining two tables together.
the example is a database for a french client so the names are in french, i just created a form with a tetbox on it with scroll bars and multiline set to true but you can handle the data as you like.
you can access fields either by name or by column index (zero based).
put Imports System.Data.OLEDB at the top of the class
Using conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\My Documents\DOWNLOAD\GESTION.mdb")
Using cmd As New OleDbCommand("SELECT Produits.*,Fournisseurs.Ville FROM Produits LEFT JOIN Fournisseurs ON Fournisseurs.NomFournisseur=produits.Fournisseur", conn)
Dim rd As OleDbDataReader
Try
conn.Open()
rd = cmd.ExecuteReader
Do While rd.Read
TextBox1.Text += rd(1) + " : " + rd("Ville") + vbCrLf
Application.DoEvents()
Loop
rd.Close()
Catch ex As Exception
MsgBox("Cannot Access DB." + vbCrLf + vbCrLf + ex.Message)
End Try
conn.Close()
End Using
End Using