In order to enforce referential integrity in Microsoft Access 2016 database, which of the following statements are correct?

1. In the primary table, the common f‌ield must be a primary key or have a unique index.

2. The common f‌ields in both the tables must be of the same data type.

3. Referential integrity can be enforced on linked tables.

Which field marked in the given image represents a foreign key?

In Microsoft Access 2016 database. which keyboard shortcut will you use to check the spellings?

Logan is working with the tables in Microsoft Access 2016 database. If he wants to show/hide the property sheet. then which of the following keyboard shortcuts will he use?

Which is the correct operator that can be used to combine two strings to form a single string and propagates null values (ie if one of the values is Null, then the whole expression evaluates to Null)?

In Microsoft Access 2016, which is the correct operator that combines two strings to form one string?

Consider the following tables: Books --------- BookId BookName AuthorId SubjectId PopularityRating (the Popularity of the book on a scale of 1 to 10) Language(such as French, English, German etc) What is the query to determine which German books (if any) are more popular than all the French books?

Which of the given text field properties should you set in order to force a user to enter a date value specifically in MM-DD-YYYY format?

What will happen when you click on the icon marked as A (see image)?

What will be the result of the following? InStr(1, 'John Smith', 'S')

Which form property determines whether the current record has been modified since it was last saved?