Most databases store data in "Tables" which are pretty much like the tables you might see in a book. The columns, or "fields", all contain the same sort of data, such as the date of a sale. The rows or "records" each contain a collection of data that represent one thing or event, such as one supplier.
A report normally takes one or more related tables, connects them together and filters out unwanted rows so as to give you the data that's perfect for your needs.
"Who bought M10 bolts last month?"
We'd need to link customers with their orders, filter out purchases that did not involve M10 bolts and deduplicate (you don't want to know about 17 different lengths of bolt on different days!)- DBDesigner makes it easy to do reports like that. If they are easy, you'll want lots of them!
