Rea201
  • Rea201
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
Computer Science
schrodinger
  • schrodinger
I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.

Get this expert

answer on brainly

SEE EXPERT ANSWER

Get your free account and access expert answers to this
and thousands of other questions

jagatuba
  • jagatuba
You need to at least mark the answers that you think are correct.
Rea201
  • Rea201
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
Rea201
  • Rea201

Looking for something else?

Not the answer you are looking for? Search for more explanations.

More answers

anonymous
  • anonymous
1 is right 2 is right 3 is wrong 4 is right rest are wrong
Rea201
  • Rea201
Ok thanks

Looking for something else?

Not the answer you are looking for? Search for more explanations.