Database - Queries with multiple tables

A query can be created to locate information across several tables

• TRUE

• FALSE

A calculated field can be created by combining one or more fields together with one or more operators in an expression.

• TRUE

• FALSE

Which brackets are used on fields that are combined for a calculated field?

• ( )

• { }

• < >

• [ ]

What row is used to sort data in a query result?

• Show

• Sort

• Or

• Arrange

When creating a calculated field, the name if the field should be followed by a_________

• Comma

• Fullstop

• semicolon

• Colon

Date ( ) is an in-built function in Microsoft Access that is used to?

• display yesterday's date

• display the date of today

• display the date of birth

• display the creation date