Question
a.
By setting required to ‘Yes’
b.
By using default value
c.
By defining validation rule
d.
By using format
Posted under MS Office
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
Similar Questions
Discover Related MCQs
Q. In an application created using the database wizard, the main menu is presented as a:
View solution
Q. Which leads you through the process of creating a table?
View solution
Q. Which data type is better to use for storing the price of an item?
View solution
Q. Which do you click to display the table’s primary key and indexes in a separate window?
View solution
Q. After right click the field selector button, which do you choose to delete a field in design view?
View solution
Q. Which tool is used to generate printout of a table’s structure?
View solution
Q. Which of the following is not a legitimate section for form objects?
View solution
Q. Which control types is most often associated with a bound control?
View solution
Q. Which control type do you use to create a calculated control?
View solution
Q. Which is not a view for displaying a report object?
View solution
Q. The report footer section is most useful for displaying:
View solution
Q. Which function can not be used for calculated controls in a report?
View solution
Q. Which setting you must modify to print a report using letterhead?
View solution
Q. In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?
View solution
Q. Which is not an option for customizing a datasheet window?
View solution
Q. Which is not a command that is selectable from right click menu of a field column?
View solution
Q. What do you call the process of restricting the display of records in a table to those matching a particular criterion?
View solution
Q. In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?
View solution
Q. Which of the following is not an action query?
View solution
Q. In MS Access, Text Data type may contain maximum character of
View solution
Suggested Topics
Are you eager to expand your knowledge beyond MS Office? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!