To Activities

LSP 121 -- Activity 11

Access Reports

Use the database real-estate.accdb to create an Access Report that contains information about real estate agents and the properties that they are listing.

1. Create a query that involves tables Agents, AgentListing, and Listings. Show the variables Last Name, First Name, Phone Number from the Agents table, and City, Address, Frame Type from the Listings table. Sort by Last Name, First Name, City, and Address.

2. Name the query "Agent Listings Information."

3. Select Create >> Report Wizard in the Reports Group.

4. In the Report Wizard, select Query: Agent and Listings Information from the Tables/Queries dropdown menu and move all of the fields from the Available Fields box to the Selected Fields box. Click Next.

5. Select by Agents as an answer to "How do you want to view your data?" Click Next.

6. Do not add any grouping levels. Click Next.

7. Sort the detail records by City in ascending order.

8. Choose Stepped as the Layout Portrait and Landscape as the Orientation. Click Next.

9. Set the report title to Agent Listings Information.

10. Close the report.

11. View Reports in the Navigation Pane.

12. Right click on Agent and Listings Information >> Export >> PDF or XPS. Save the report as a PDF file: a10-Smith-Chen-Suarez.pdf, where you replace the names with the members of your group. Click Publish.