Integrate Fields that Already Exist from Other Tables


show more Adding existing fields from other tables 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 ...

Adding existing fields from other tables

Scroll down to the bottom of your Navigation Pane and double-click on your Orders by Customer. Since I'm looking at a list of every customer's orders, it will be helpful to see who their SalesRep is. Access allows you to add existing fields from other tables to any report. Go up to the Views, and toggle over to the Layout View. If you still have Group, Sort, and Total open from our previous lesson, click on this button right here to close it. Go up to the Report Layout tools, and make sure you're on the Design tab, and then click on this Add Existing Fields button, and it will open up.

Now I'd like to know who the SalesRep is, but they're not on this list. Click here for Show all tables. Some of the tables will show up here; others may be down here. We want to know who the SalesRep is for each customer. Click on SalesRep, and then drag it over to the left, to this box right here. It creates a SalesRep label and the field itself. Let's change the appearance of this l...

Adding existing fields from other tables
Video duration: 1m 59s 3h 30m Beginner

Viewers:

Adding existing fields from other tables provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...