8) The process of transferring data from one computer system to another is referred to as ________.
A) auto transfer
B) import/export
C) buffer overrun
D) reallocation
9) Which of the following statements is true of delimited files?
A) Microsoft Access can import only tab-delimited files.
B) Delimited files cannot be imported by Microsoft Excel.
C) A comma-delimited file has data that contains commas.
D) Field values in a tab-delimited file are separated by tabs.
10) Which of the following is true about the import/export of data from Microsoft Access to Microsoft Excel?
A) Data can only be transferred by exporting the data into a text file and then importing that text data.
B) Delimited text files cannot be imported into both Microsoft Excel and Microsoft Access.
C) The import/export process in both Microsoft Access to Microsoft Excel maintains an active connection to the source of the data.
D) Data must be re-imported to Microsoft Excel in order to remain up-to-date if the source data in Microsoft Access is modified.
11) Delimited text files can be imported to Microsoft Access by selecting the ________ tab.
A) Home
B) Create
C) Database Tools
D) External Data
12) Which of the following shows the correct sequence of steps for importing Microsoft Access data that has been stored in a text file into Microsoft Excel?
A) Insert tab → Get External Data → From Access
B) Edit tab → Get External Data → From Access
C) File tab → Get External Data → From Text
D) Data tab → Get External Data → From Text
13) Import/export is the process of transferring data from one computer system to another.
14) In Microsoft Excel and Microsoft Access, import/export maintains an active connection to the source of the data.
15) If users change the Microsoft Access data, the imported data in Microsoft Excel will be out-of-date until it is re-imported.
16) While saving data in text files, commas cannot be used to separate field data if the data itself contains commas.
17) Delimited text files cannot be imported into either Microsoft Excel or Microsoft Access.
18) To import data into Microsoft Excel, open Excel, click the Data tab, and in the Get External Data section of that ribbon click From Text.
19) Data can be exchanged between Microsoft Excel and Microsoft Access by exporting the data into a text file and then importing that text data.
20) To exchange data between Microsoft Excel and Microsoft Access, the data must be imported into a text file and then exported.