Q. Which query do you use to answer the question “What is the average salary of the employees”?

View solution

Q. What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?

View solution

Q. How to make a date field DOB store the dates like “2002/10/17” ?

View solution

Q. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?

View solution

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