In MS Access, what type of query can combine fields from multiple tables by matching data across shared key rows, without altering the underlying raw data? MCQ with Answer and Explanation
In MS Access, what type of query can combine fields from multiple tables by matching data across shared key rows, without altering the underlying raw data?
A. Select Query
B. Delete Query
C. Append Query
D. Update Query
Answer: Option A
Solution (By JKSSB Mock Tests)
A Select Query extracts and displays information from one or more tables based on user-defined criteria without modifying the source data records.
Which of the following functions in MS Excel searches for a specific value in the leftmost column of a table array and returns a value in the same row from a specified column?
Explanation:
VLOOKUP stands for Vertical Lookup. It searches down the leftmost column of a range for a key and returns a value from the specified column in that row.
No comments yet. Be the first to start the discussion!