Microsoft Access Queries

What is the symbol for greater than?

• ^

• <

• >

• *

The first step for carrying out a query is to go to Create and then select?

• Query Wizard

• Query Design

• Query Now

• Run

If I wanted to search a database for all countries that start with the letter L, what would I put in my query?

• *L

• *L*

• L*

• L

Ascending means...

• A to Z / Smallest to Larget

• Z to A / Smallest to Largest

• A to Z / Largest to Smallest

• Z to A / Largest to Smallest

I want to run a query to find out who is aged over 11 but under 18, what would I put as the criteria?

• 12 - 17

• between 12 and 17

• over 11 but under 18

• between 10 - 20

What is the symbol for less than?

• >

• -

• <=

• <

What would it be could if I wanted to put things in order of surname?

• Finding

• Arranging

• Sorting

• Searching

I want to show all subjects in school with the exception of Music and Art. What would I type in criteria for subject?

• exclude Music and Art

• not Music or Art

• not Music and not Art

• except Music and Art

If you were creating a query to find out what tickets are priced at £10, what would you put in criteria?

• Ten

• 10

• £10

• priced at £10

How many fields are in this photo?

• 6

• 10

• 5

• 17