NEW
Font size
S
M
L
XL
WorksheetsAccess - Lesson 14
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
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
2.
Which tab contains the import and export commands?
a)
File
b)
Home
c)
External Data
d)
Database Tools
3.
Which is not a file type that may be imported into Microsoft Access?
a)
Text files (TXT)
b)
HTML files (HTM or HTML)
c)
Microsoft Publisher files (PUB)
d)
Microsoft Excel files (XSLX)
4.
Up to how many source columns can Access import?
a)
100
b)
225
c)
550
d)
1010
5.
Mary needs to export the table of FBLA members from the Southeast Region database to a document that does not allow editing. Which format should she use?
a)
DOC
b)
PDF
c)
RTF
d)
TXT
6.
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
7.
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
8.
Which of the following messages displays when an import operation has failed?
a)
Syntax error
b)
Couldn’t find network path or user name
c)
An error occurred trying to import file
d)
Couldn’t decrypt file
9.
If fields in the import file contain an assortment of data types, the wizard will usually suggest using the ___________ data type during import operation.
a)
Short Text
b)
AutoNumber
c)
Date
d)
Number
10.
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
Reset
