Quantcast

Got Homework?

Connect with other students for help. It's a free community.

  • across
    MIT Grad Student
    Online now
  • laura*
    Helped 1,000 students
    Online now
  • Hero
    College Math Guru
    Online now

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

Rea201 Group Title

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

  • one year ago
  • one year ago

  • This Question is Closed
  1. jagatuba Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    You need to at least mark the answers that you think are correct.

    • one year ago
  2. Rea201 Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    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

    • one year ago
  3. Rea201 Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    @jagatuba

    • one year ago
  4. kag Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    1 is right 2 is right 3 is wrong 4 is right rest are wrong

    • one year ago
  5. Rea201 Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    Ok thanks

    • one year ago
    • Attachments:

See more questions >>>

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...

23

  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.