You have a database containing customer information, including orders, for a small retail store where you work. The database is relational and the database designer organized the tables so that the columns contain only single pieces of information. For example, the names of customers take up to three fields (First, Middle, and Last Name). Naming conventions in the database use uppercase characters for each word in a field name. Describe how you can create a report that lists the Names of customers and their phone numbers, grouped by the City in which they live.

Question

What will be an ideal response?

Answer 1

Open the database, click the Create Tab, and then click the Report Wizard button. Click the Tables/Queries list arrow, click the Table: Customers, click Last Name in the Available Fields list, then click the Select Single Field button, click First Name in the Available Fields list, then click the Select Single Field button, click City in the Available Fields list, then click the Select Single Field button, click Phone Number in the Available Fields list, and click the Select Single Field button. On the Grouping screen click on the City Field and then click the Select Single Field button and Click the Next button, and then click Next on subsequent screens, verifying that the Preview the report option button is selected, and finally click Finish.