Lesson 7 - Using Advanced Database Features
Access 2016
Steps
Practice Data
3. Select OK .
Click
The Select New Location of
dialog box opens.
4. Select the drive where the file is stored. A list of available folders appears. 5. Open the folder where the file is stored. A list of available folders and files appears. 6. Select the name of the file containing the linked table. The file is selected. The Select New Location of
dialog box closes, and a Linked Table Manager message box informs you that all linked tables have been successfully refreshed. 7. Select Open .
Click the student data drive.
Double-click the student data folder
Click WORLDLNK.ACCDB
Click
8. Select OK .
Click
The Linked Table Manager message box closes.
9. Select Close .
Click
The Linked Table Manager dialog box closes.
E XPORTING D ATA
Discussion
You can export data and database objects to a variety of supported databases, programs, and file formats. For example, export data to another program (such as dBASE or Excel), to ASCII text, or to an HTML data table. You can also export most database objects from a Microsoft Access database to another Access database. The process of exporting data and database objects is very similar to copy and paste.
The following table lists some of the data formats to which you can export:
Page 126
OFFICEPRO, Inc.
Made with FlippingBook - professional solution for displaying marketing and sales documents online