Case Based Critical Thinking Questions
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
Correct Answer:
Verified
Q42: _ perform arithmetic operations on selected records
Q44: The _ aggregate function returns the average
Q49: Which query wizard allows the user to
Q53: The _ button in the Sort Filter
Q55: Case Based Critical Thinking Questions
Carlos has developed
Q55: It is a good idea to _
Q57: Which type of query would show results
Q58: Case Based Critical Thinking Questions
Marie works for
Q59: An input mask may be created for
Q61: Matching
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