Access 2016 Intermediate

Access 2016

Lesson 7 – Using Advanced Database Features

Application

Supported Version or Format

Microsoft Access database

Access 2.0, 7.0/95, 8.0/97, 9.0/2000, 10.0/Access 2002, Access 2003, 2007, 2010, 2016

dBase

III, IV and 5, (Requires Borland Database Engine 4.x or later)

Paradox, Paradox for Windows

3.x, 4.x, 5.0, 7.0 and 8.0 (Requires Borland Database Engine 4.x or later) 3.0, 4.0, 5.0, 7.0/95, 8.0/97, 9.0/2000, 10.0/Excel 2002, Excel 2003, 2007, 2010, 2016

Microsoft Excel

Microsoft Word, Rich Text Format

All

Lotus 1-2-3

wk1 and .wk3

Delimited text files

All

XML document

All

NOTE When exporting database objects to another database, only export one object at a time. If you need to export multiple objects to a database, it may be more efficient to open the database to which you want to export and import the objects. When you export an object to another database, it might be helpful to export all related objects to ensure full functionality. For example, a report is usually based on a query, and a query is based on one or more tables.



Procedures

1. Select All Access Objects on the Navigation Pane, if necessary. 2. Select the database object you want to export. 3. On the Ribbon select the External Data tab. 4. Select the desired export button in the Export group. 5. Select 6. Select the drive where the file to which you want to export is stored. 7. Open the folder where the desired file is stored.

OFFICEPRO, Inc.

Page 127