When choosing between Access and Excel, it is best to use Access in all of the following circumstances EXCEPT:
A) you require multiple tables to manage data.
B) multiple users need to work with data simultaneously.
C) you are managing a large quantity of data.
D) you need to create complex charts or graphs.
D
You might also like to view...
The functions pow(), sqrt(), and fabs() are found in which include file?
a. cstdlib b. cmath c. iostream d. regular
Case 18-3 Anna, the manager of a general store, uses Microsoft Access 2016 to maintain product information. She uses multiple criteria to retrieve specific details about products. She combines two or more conditions to filter the records based on her requirement. Anna types Like "a*" in the Criteria row in the ProductName column and 25 in the same Criteria row in the RetailPrice column. In this case, the query datasheet, created by Anna, will include the records for products witha ProductName field value that:
A. ?begins with "a" or a RetailPrice field value not equal to 25. B. ?ends with "a" or a RetailPrice field value equal to 25. C. ?ends with "a" and a RetailPrice field value not equal to 25. D. ?begins with "a" and a RetailPrice field equal to 25.
What is the proper format of an external reference to a workbook or worksheet thats name contains spaces; source and destination files are in the same folder?
A) Worksheet'!Cell B) [WorkbookName]Worksheet!Cell C) '[WorkbookName]Worksheet'!Cell D) ''[WorkbookName]Worksheet''!Cell
Which of the following is considered to be the oldest computer backup medium?
A) Large hard drives B) Tape C) Core memory D) Floppy disks