Access Import/Export

Process of creating a copy of data from a database that will be stored and used outside of the database

• link
• import
• delimiter
• export

A character that separates fields in a delimited file and does not appear in the field values, such as a tab, semicolon, comma, or space

• delimiter
• export
• link
• delimited file

 Process of bringing in data from an external source that you want to store in your database

• import
• transfer
• xml
• export

The details of an import or export operation that contain all the information Access needs to repeat it without user input

• table
• query
• report
• specification

 A text file where each record appears on a separate line and the width of each field remains consistent across records

• rows
• joins
• table
• fixed-width file

Which tab contains the import and export commands?

• File 
• Home
• External Data
• Database Tools 

What is the process of transferring data from an Microsoft Access database for use in another application called?

• Exporting 
• Importing 
• Pasting 
• Distributing 

The Import Spreadsheet Wizard will provide an option for the user to define a/an ___________ key for the new table, which will uniquely identify the record in your table.

• encryption
• normal
• primary
• car

Before importing a file, all unnecessary blank columns and rows should be ___________.

• Assigned a data type 
• Deleted
• Moved to the end of the table 
• Kept 

Which file type places each record on a separate line and uses a special character to separate fields?

• Bound 
• Defined 
• Delimited 
• Isolated