Question

Questions about Access and Microsoft Excel. Trying to refresh my memory. NOT school work



1. What allows you to connect to data in another program without importing it so you can view and edit the data in both the original program and in the Access file? (1 point)
Linking
Exporting
Wizard
Importing
2. Which of the following is a way of importing data into Access from Excel? (1 point)
Copy data from a worksheet and paste it directly into an Access datasheet
Import a worksheet into an Access database
Load an Access datasheet into Excel using the "Analyze it with Excel" command
All of the above
3. When importing the contents of an Excel worksheet into a new or existing Access database, what will Access do with the source file? (1 point)
Delete it
Not change it
Modify it
None of the above
4. How many worksheets will Access allow you to import at a time? (1 point)
Two
Three
One
As many as you want
5. When importing Excel data into Access, Access will treat which row as field names? (1 point)
First row
Last row
Designated row
None of the above
6. When will Access import pictures or images from Excel? (1 point)
Never
Always
When commanded
When specially formatted
7. Which will Access import from Excel: mathematical formulas and/or their solutions? (1 point)
Mathematical formulas
Solutions to mathematical formulas
Both A and B
Neither A or B
8. In what forms can you export data from Access to Excel? (1 point)
Table
Report
Query
All of the above
9. To check to see that a table was linked properly, look for strings that start with what character? (1 point)
$
@
#
*
10. How many characters will Access display when you link files from Excel? (1 point)
155
200
250
255




My answers:

1. What allows you to connect to data in another program without importing it so you can view and edit the data in both the original program and in the Access file? (1 point)
Linking-
2. Which of the following is a way of importing data into Access from Excel? (1 point)
All of the above-
3. When importing the contents of an Excel worksheet into a new or existing Access database, what will Access do with the source file? (1 point)
Modify it-
4. How many worksheets will Access allow you to import at a time? (1 point)
One-
5. When importing Excel data into Access, Access will treat which row as field names? (1 point)
None of the above-
6. When will Access import pictures or images from Excel? (1 point)
When specially formatted-
7. Which will Access import from Excel: mathematical formulas and/or their solutions? (1 point)
Both A and B-
8. In what forms can you export data from Access to Excel? (1 point)
Report-
9. To check to see that a table was linked properly, look for strings that start with what character? (1 point)
@-
10. How many characters will Access display when you link files from Excel? (1 point)
250

Answer 1

not school work but it still has (1 point) lol... sounds legit xD

Answer 2

@Agent_Sniffles x)

Answer 3

Yeah the only reason it has (1 point) is because it is an old practice test. I did this in a computer class a couple years ago