Case Based Critical Thinking Questions
Case 5-2
Marie works for a busy pediatrician's office. The practice has a sophisticated database for all records and information that pertain to the practice. The doctor for whom she works is participating in an academic study, and she needs a report that lists the patient's name, date of birth, and the names of parents or guardians. The doctor would like to see the patient's full name in the format Lastname, Firstname even though they are separate fields in the database. She would also like to see the data for the fields Mother, Father, and Guardian, regardless of whether or not data is actually entered in those fields. Based on the doctor's requirements for the report, Marie must create a query on which to base the report.
?
Marie creates the following expression as a new field in the query that she will use to create the report requested by the doctor PatientName: [LastName] & ", " [FirstName]. This expression is an example of ____.
A. IsNull
B. concatenation
C. nonnull
D. an expression using a logical operator
Answer: B
You might also like to view...
The schedule in the Sound Byte suggests running the system tools in the order ________
A) Disk Defragmenter, Error-checking, and Disk Cleanup B) Disk Cleanup, Error-checking, and Disk Defragmenter C) Error-checking, Disk Cleanup, and Disk Defragmenter D) Error-checking, Disk Defragmenter, and Disk Cleanup
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
A. Formula Finder B. Range Finder C. Calculation Finder D. Function Finder
Web browsers will recognize multiple line breaks typed in the body of an HTML document, and will insert spaces for each one.
Answer the following statement true (T) or false (F)
Most spreadsheet programs allow multiple worksheets to be saved together in a single spreadsheet file, called a(n) workbook. _________________________
Answer the following statement true (T) or false (F)