Microsoft Access troubleshooting and expressions

When establishing a relationship between two tables, how would you fix this error?

• Change the ArtistID data type in each table so they are both numbers

• Add an additional Artist ID field in another table

• Link both primary keys in each table

• Ensure that Enforce Referential Integrity is ticked.

I attempted to delete a relationship between two tables, but I got this error. How do I fix it?

• Close the open tables then try again

• Restart the computer

• Ask my friend whether they are using my database at the same time

• Close any conflicting programs

When attempting to run my query, I get this error message. How do I fix it?

• Close the open tables and try again

• Check my query expressions

• Remove unnecessary tables from my query

• Add additional criteria to my query

I made a query with the Gallery name and Artist Surname. When I run the query, this unexpectedly pops up. What's happened?

• The ArtistSurname field is spelt incorrectly

• The expression contains a logic error

• I need to add a primary key to the query because the fields are in different tables

• I need to save the query before running it

A calculated field displays "profit" when predicted sales are £1,000 or more. Otherwise it displays "loss". What have I used in my expression?

• IF([PredictedSales] > 1000, "profit", "loss")

• IIF([PredictedSales] > 1000, "profit", "loss")

• IF([PredictedSales] < 1000, "profit", "loss")

• IIF([PredictedSales] > 1000, "loss", "profit")

Answer explanation

IIF is used in expressions instead of IF.

The first part is the condition [PredictedSales] > 1000

The second part is what displays if the condition is true.

The final part is what displays if the condition is false.

IIF(condition, true, false)

There is going to be a 50% off sale. A calculated field displays 50% of an item's price. What is the expression?

• SalePrice: [ItemValue] * 0.5

• SalePrice: [ItemValue] * 50

• SalePrice: [ItemValue] / 50 * 100

• SalePrice: [ItemValue] * 0.05

An expression on a report joins a first name and surname together. What is the expression?

• =[FirstName] & " " & [LastName]

• =[FirstName] + " " + [LastName]

• =[FirstName] &[LastName]

• ="[FirstName][LastName]"

Which expression on a report might show the total value of all sales?

• =Sum([Sales])

• =Total([Sales])

• =Max([Sales])

• =COUNT([Sales])

Which expression on a report might show the total number of records to indicate the number of orders received?

• =Sum([OrderID])

• =Total([OrderID])

• =Max([OrderID])

• =COUNT([OrderID])