What will be the result of the following?

InStr(1, "John Smith", "S")

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

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?

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?

What is the function of the icon marked as A (see image) when you are creating Macros in Microsoft Access 2010?

Suppose you have a table named Cars with fields that store the name, year, price, and condition of used cars that you are considering for purchase. Also suppose that the table has become large and that you frequently include the Year field in queries. You can create an index on the Year field so that your queries return results more quickly. Which syntax will you use to achieve this?

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?

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

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

To enforce referential integrity in Microsoft Access 2016 database, which 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 of the following types of table relationships are supported in Microsoft Access 2016? 1. A one-to-one relationship. 2. A one-to-many relationship. 3. A many-to-many relationship.