How To Create Multi-Table Reports In Access 2010


show more Creating multi-table reports provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Creating multi-table reports

You can also make reports using more than one table as a source. We'll make a report listing information about our SalesReps, and their customers. Click on the Create tab and then on the Report Wizard button. From the dropdown, select the Sales Reps Table. Click on the EmpID and the arrow to move it over, LastName and FirstName, then drop down the table selector again and scroll up to Customers. From here, choose CustID, the Company, their State, and scroll down a little bit to Type.value, which will tell us if they are a retail establishment or a restaurant, and click Next.

Access automatically recognizes the one -to-many relationship between SalesRep and Customers, so it groups the report for you. On the next screen, we can also add another group. Go ahead and choose Type.value and move it over. That will group all of the restaurant customers and all of the retail customers. Click Next, drop it down, and let's sort by the Company Name. Click Next again. We're going to lay out ...

Creating multi-table reports
Video duration: 1m 46s 3h 30m Beginner

Viewers:

Creating multi-table reports provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...