Understanding Databases – Reports

Understand that a report is used to print from a table or query

1 Reports

Reports are used to extract data from a table or query, by exporting to a printable text file.

It can be saved and run again if more reports are created or data is modified.

Because database reports simplify and filter the records contained in tables or queries and displays them in an efficient way, they are useful for analysing data.

For example, an airline flight booking database might produce a report to list the names of people on a certain flight.

Running a report like this will remove extra data that may not be relevant to the required report, such as cost of flight, age of customer, etc.

Other reports could be created from the same query, such as a report listing special requirements of passengers, i.e. disabilities, dietary requirements, etc.