In MS Access, which data type is used for long text (up to 1 GB) and formatted text? MCQ with Answer and Explanation

Explanation:
Print Layout view displays the document with margins, page breaks, headers, footers, etc., as it will appear when printed. Read Mode is optimized for reading, Web Layout for web pages, Draft shows minimal formatting.

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.

Explanation:
Ctrl + Shift + L is the native keyboard shortcut to instantly apply or remove the dynamic AutoFilter toggle sorting keys on the active data range headers.