NEW
Font size
S
M
L
XL
WorksheetsAccess Import/Export
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
Process of creating a copy of data from a database that will be stored and used outside of the database
a)
link
b)
import
c)
delimiter
d)
export
2.
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
a)
delimiter
b)
export
c)
link
d)
delimited file
3.
Process of bringing in data from an external source that you want to store in your database
a)
import
b)
transfer
c)
xml
d)
export
4.
The details of an import or export operation that contain all the information Access needs to repeat it without user input
a)
table
b)
query
c)
report
d)
specification
5.
A text file where each record appears on a separate line and the width of each field remains consistent across records
a)
rows
b)
joins
c)
table
d)
fixed-width file
6.
Which tab contains the import and export commands?
a)
File
b)
Home
c)
External Data
d)
Database Tools
7.
What is the process of transferring data from an Microsoft Access database for use in another application called?
a)
Exporting
b)
Importing
c)
Pasting
d)
Distributing
8.
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.
a)
encryption
b)
normal
c)
primary
d)
car
9.
Before importing a file, all unnecessary blank columns and rows should be ___________.
a)
Assigned a data type
b)
Deleted
c)
Moved to the end of the table
d)
Kept
10.
Which file type places each record on a separate line and uses a special character to separate fields?
a)
Bound
b)
Defined
c)
Delimited
d)
Isolated
Reset
