Create new reports for What SUP (use the Ch9-02 file)
a. Create and print a report for What SUP that lists the supplier ID, supplier name, and city from the supplier table. (Use the supplier table to locate field names.) The report should have no grouping, be sorted by supplier ID in ascending order, and be formatted in a tabular layout with portrait orientation. Save the report as Suppliers by Supplier ID. Make sure all field information is visible.
b. Create and print a report for What SUP that lists the supplier name, contact name, contact title, and phone number from the supplier table. (Use the supplier table to locate field names.) The report should have no grouping, be sorted by supplier name in ascending order, and be formatted in a tabular layout with portrait orientation. Save the report as Suppliers by Supplier Name. Make sure all field information is visible.