Skip to content
Sign in
Artwork for Computer Learning Zone
Computer Learning Zone · Wednesday · 3 min

Microsoft Access SQL Quiz: What SELECT Asterisk and Other Clauses Mean

Test your Microsoft Access SQL knowledge with five quick questions about the building blocks of SELECT queries. The focus includes what SELECT * means, how WHERE filters records, and why ORDER BY affects row sorting rather than the order of returned columns. You will also look at a common combo box Row Source detail: the fields listed after SELECT determine the column sequence. Plus, learn when table-name prefixes and square brackets can be safely removed to make a simple query easier to read. A short challenge for Access users who want to be more comfortable reading and writing SQL without letting their SELECT statement disappear into the cloud.

0:00-3:12
Play in

transcript

No transcript — this publisher did not publish one.

show notes

Test your Microsoft Access SQL knowledge with five quick questions about the building blocks of SELECT queries. The focus includes what SELECT * means, how WHERE filters records, and why ORDER BY affects row sorting rather than the order of returned columns.

You will also look at a common combo box Row Source detail: the fields listed after SELECT determine the column sequence. Plus, learn when table-name prefixes and square brackets can be safely removed to make a simple query easier to read.

A short challenge for Access users who want to be more comfortable reading and writing SQL without letting their SELECT statement disappear into the cloud.

more episodes

All episodes