Q. In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?

View solution

Q. What does the expression [detail] ! [product] * 1.30 do?

View solution

Q. Which criteria return only those addresses beginning with the letter “K”?

View solution

Q. Which criteria do not return the position “Officer” as a match?

View solution

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