Access 2016 Intermediate

Access 2016

Lesson 7 – Using Advanced Database Features

9. Select . 10. Select the table containing the source data.

11. Select

.



Step-by-Step

Link to an Access table.

Steps

Practice Data

1. Select the External Data tab. The External Data tab appears.

Click External Data

1. In the Import & Link group, select the New Data Source button. A drop-down list appears. 2. From the drop-down list select From Database . A list of file options appear. 3. From the file options list, select Access . The Get External Data – Access Database dialog box appears. 3. Select the drive where the source data is stored. A list of available folders appears. 4. Open the folder where the source data is stored. A list of available folders and files appears. 5. Select the file containing the source data. The file is selected. 2. Select Browse . A list of available drives appears.

Click

Click From Database .

Click

Click

Click the student data drive

Double-click the student data folder

Double-click EXTERNAL.ACCDB

6. Select the desired link option. The desired option is selected

Click

Link to the data

source by creating a linked table

OFFICEPRO, Inc.

Page 123