You can import data from an Excel workbook into Access using all of the following methods EXCEPT ________
A) creating a link to a worksheet from an Access database
B) saving the workbook as an Access database from within Excel using the Save As feature
C) importing a worksheet into a new or existing Access table
D) copying the data from an open worksheet and pasting it onto an Access datasheet
B
You might also like to view...
Case 15-1 Frank, a business analyst at Pro-White Technologies, deals with vast amount of data and analysis. Since Frank uses Excel worksheets for most of his work, he uses several advanced functions of Excel that eases and speeds up his work. Frank fills eight columns and over a thousand rows of text in an Excel worksheet. He wants to collate the text in three of the columns in a single column. Frank enters the first two cells manually and then uses the Flash Fill function. Flash Fill suggests a pattern that is not the pattern Frank requires. To reject the suggested pattern, Frank should press the _____ key.
A. ?Alt B. ?Ctrl C. ?Esc D. ?Shift
COGNITIVE ASSESSMENT What is the term for an electrical channel within the circuitry of a computer than can transfer 8 bytes of data at a time?
A. 32-bit bus B. 800 MHz circuit path C. 64-bit bus D. system channel port (8-byte)