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?
Explanation:
A Select Query extracts and displays information from one or more tables based on user-defined criteria without modifying the source data records.
In MS Access, which join type in a Query design screen extracts all records from Table A and only those records from Table B that have matching key values?
Explanation:
A Left Outer Join includes all records from the left table (Table A) and matching rows from the right table (Table B). If no match exists, NULL values appear on the right side.
No comments yet. Be the first to start the discussion!