Joomla Framework or Joomla! CMS for my need sales order/invoicing Report

Quation Form Joomla Group From Facebook
Access

Joomla Framework or Joomla! CMS for my need sales order/invoicing Report

Postby Access » Tue 15 Oct 2019 5:02 pm

Joomla Framework or Joomla! CMS for my need ? I have a sort of complex perfectly working MS Access database that I'd like to "convert" the Access db into an online application. I'd like to use the Joomla tables for users and its user permissions features and other "built-in" features rather than start from scratch.
The Access db is mainly for sales order/invoicing (using the tables customers, orders, order details) and members' transactions (small of amount of cash deposits, withdrawals, etc... using the tables customers, transactions, transaction details).
For the reports, It has mostly simple Select queries with Joins and also a few Union queries.
What I want for the online thing is some sort of simple data entry form for invoicing/sales order and banking transactions and custom reports through sql queries viewable, exportable and printable.
Can your recommend an extension to create a custom component/reports? Or should I dive into Joomla Framework? Thanks in advance.