Basic Access Queries Quiz

What is the primary purpose of creating a query in Microsoft Access?

• To store data

• To retrieve and analyse data

• To print data

• To delete data

Which of the following is a field in a table?

• A row

• A column

• A cell

• A database

What is the function of criteria in an Access query?

• To sort data

• To filter data

• To create tables

• To delete records

How can you sort query results in ascending order?

• By using the 'Sort Descending' option

• By using the 'Sort Ascending' option

• By using the 'Filter' option

• By using the 'Group By' option

Which of the following criteria would you use to filter records where the 'Age' field is greater than 18?

• Age < 18

• Age = 18

• Age > 18

• Age <= 18

What is the result of applying a filter to a query?

• It deletes records

• It hides records that do not meet the criteria

• It changes the data type of fields

• It duplicates records

Which of the following is NOT a valid data type for a table field in Access?

• Text

• Number

• Image

• Date/Time

What is the purpose of the 'Design View' in Access?

• To enter data into tables

• To create and modify the structure of tables and queries

• To print reports

• To delete databases

Which of the following is a valid criterion to filter records where the 'Name' field starts with 'A'?

• Name = 'A*'

• Name LIKE 'A%'

• Name > 'A'

• Name < 'A'

How do you save a query in Access?

• By clicking 'File' and then 'Save As'

• By clicking 'Home' and then 'Save'

• By clicking 'Design' and then 'Save'

• By clicking 'File' and then 'Save'