Creating Report Types

[jtart2]

Can someone tell me how to create "Report Types".  I would like to create/view a report of all the contact lenses ordered for a given day or given patient.

Also, can the Mysql database be connected to with other software, e.g. MS Access, LibreOffice Base, etc?

I'd like to be able to create my own queries on the database.

Thanks.