Exam 77-420 Microsoft Excel 2013 1. Create and Manage Worksheets and Workbooks 1.1 Create Worksheets and Workbooks: Add Worksheets to Existing Workbooks

Get External Data: Many Tables 2. What Do You See? You will be prompted to select a Record Source. The list includes Tables and Queries. Tables are at the bottom of the list.   Do This, First: Enable the Selection Click on Enable selection of multiple tables. There should be check boxes to the left of the Queries and Tables. OK Try This: Select Multiple Tables Select a Table: tblSpecialty. Select another Table: tblType. Click OK. Keep going, please... Data->Get External Data->From Access