it has 3 tables customer , dvd and rentals
the customer table shows their personal details
the dvd table shows the name of the dvds and genre
the booking shows the customer id , barcode of dvd and date rented.
i need to make a query in access, but do not know what to make it about. can anyone help