Ask your own question, for FREE!
Computer Science 17 Online
OpenStudy (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

OpenStudy (jagatuba):

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

OpenStudy (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

OpenStudy (rea201):

@jagatuba

OpenStudy (anonymous):

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

OpenStudy (rea201):

Ok thanks

Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!
Latest Questions
MakaylaChuck23: Help wats this
4 hours ago 2 Replies 0 Medals
MakaylaChuck23: uh oh
7 hours ago 1 Reply 0 Medals
Treeko: Pics I took w my friend !
8 hours ago 6 Replies 2 Medals
Aliciaa: Is anyone elses QC going wack? Mine keeps freezing and stuff
7 hours ago 26 Replies 1 Medal
autumnp: does anyone have bandlab?
9 hours ago 4 Replies 0 Medals
Jeromeccv: Art for @vanessad123
6 hours ago 49 Replies 4 Medals
ohhhhhhhhhhhhhh: how do i slim my waist fast
9 hours ago 4 Replies 1 Medal
Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!