Access 2016 Intermediate

Access 2016

Lesson 7 – Using Advanced Database Features



Procedures

1. Select the External Data tab on the Ribbon .

2. In the Import & Link group, select the New Data Source button

.

3. From the drop-down list, select From File then select Text File

.

4. Select the Browse button . 5. Select the drive where the source data is stored. 6. Open the folder where the source data is stored. 7. Select the file containing the source data.

8. Select . 9. Select the appropriate data format.

10. Select . 11. Select the appropriate delimiter. 12. Select the First Row Contains Field Names option, if applicable.

13. Select

.

14. Modify field options as desired and select

.

15. Select the desired primary key option.

16. Select . 17. Enter the desired table name.

18. Select

.

19. Select

.



Step-by-Step

From the Student Data directory, open ADVDAT1.ACCDB . Import data from an external data source into the current database.

OFFICEPRO, Inc.

Page 119