Correct Answer: NZ(fieldName,0)
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Access Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Access MCQ Questions
If you convert a database to an .accde file using Microsoft Office Access 2010, which versions of Microsoft Access can you open it in?
While working with the Microsoft Access 2016 database, which keyboard shortcut is used to copy a screenshot of the current/active window to the Clipboard?
In which of the following relationships in Microsoft Access 2016 database, the Indexed property of a primary key and foreign key fields must be set to Yes (No Duplicates)?
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.
To enforce referential integrity in Microsoft Access 2016 database, which statements are correct? 1. In the primary table, the common field must be a primary key or have a unique index. 2. The common fields in both the tables must be of the same data type. 3. Referential integrity can be enforced on linked tables.
How do you create a report for a Crosstab Query if certain column values are missing?
In a report with grouping, how can you display the count of records in each group?
How can you share common objects between multiple projects 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?
What is the function of the icon marked as A (see image) when you are creating Macros in Microsoft Access 2010?