All of the following statements are TRUE about connecting to an Access database EXCEPT:
A) You can copy and paste data from an Access table into a blank Excel worksheet.
B) Within Access, users have the option of exporting tabular data into an Excel format.
C) For longer-term projects, a permanent connection between an Access database and the Excel application can be created by using the Access Data Connect feature.
D) Live data from a permanent connection can be imported as a simple table, or even a PivotTable report or PivotChart.
Correct Answer:
Verified
Q24: All of the following statements are TRUE
Q25: To change the text string jaMEs sMITh
Q26: If cell A2 contains the string "Excel
Q27: All of the following statements are TRUE
Q28: When a primary key from one table
Q30: To remove any nonprinting characters from a
Q31: _ are functions that manipulate data to
Q32: You can import tables and queries from
Q33: To change the word apple with orange
Q34: To remove all spaces from text except
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents