Microsoft Access Test

Microsoft Access linkedin Quiz answers

What kind of query will display data with both column headers and row headers?

• select
• spreadsheet
• simple
• crosstab

Microsoft Access linkedin Quiz

When you designate a field as a table's primary key, what change is automatically made to the field's properties?

• The IME Mode property is set to On.
• The Allow Zero Length property is set to No.
• The Indexed property is set to Yes (No Duplicates).
• The Required property is set to Yes (Key Values).

Microsoft Access linkedin assessment

What program flow function evaluates a condition and either returns a truepart or a falsepart?

• Choose()
• Switch()
• IsError()
• IIf()

linkedin Microsoft Access assessment answers

What is the Access string operator that joins, or concatenates, text strings together?

• +
• !
• #
• &

linkedin Microsoft Access Quiz

What is the most common relationship type between two tables?

• referential integrity
• inner join
• primary key
• one-to-many

Microsoft Access linkedin learning

linkedin learning Microsoft Access