MS Access Quiz

What is an action query in MS Access?

• A query that changes or manipulates data

• A query that only displays records

• A query that deletes the database

• A query that backs up records

Which type of action query is used to remove records from a table?

• Append Query

• Delete Query

• Update Query

• Make Table Query

What does an update query do?

• Changes existing records in a table

• Deletes selected records

• Copies records to another table

• Creates a new table

Which type of query creates a new table based on existing data?

• Append Query

• Make Table Query

• Crosstab Query

• Delete Query

What is a calculated field in a query?

• A field created by using expressions to perform calculations

• A field used to store images

• A primary key field

• A field that stores only text data

Which of the following is an example of a calculated field expression?

• [Quantity] * [UnitPrice]

• SUM([UnitPrice])

• UPDATE TotalPrice SET Quantity

• DELETE FROM TotalPrice

What is the purpose of the Expression Builder in MS Access?

• To create formulas and expressions

• To delete tables

• To rename databases

• To insert images into reports

How can a calculated field be formatted to display percentages?

• By changing the field properties in Design View

• By renaming the field

• By adding more tables to the query

• By using the DELETE function

What is the purpose of a macro in MS Access?

• To automate repetitive tasks

• To delete large amounts of data

• To create new queries automatically

• To generate new tables

Which of the following is an example of a macro action?

• OpenForm

• OpenDatabase

• FormatTable

• PrintDatabase