Which of the following expressions in Access Query Design View creates a computed field named MonthlySalary using a value from the Salary field?
A) MonthlySalary = [Salary / 12]
B) MonthlySalary: [Salary] / 12
C) Salary / 12 = [MonthlySalary]
D) MonthlySalary: "Salary" / 12
Correct Answer:
Verified
Q29: Based on the following notation, which relational
Q30: If you use _ criteria, each criterion
Q31: A _ in a record is the
Q32: What type of query could you run
Q33: For a one-to-many relationship in the Access
Q35: In relational algebra, what command is used
Q36: What do you call the field used
Q37: You can create compound criteria (conditions) in
Q38: What type of functions are Count, Sum,
Q39: Which of the following is a technique
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