Q. Which is the valid data type in Access?

View solution

Q. How many relations may exist between tables in databases?

View solution

Q. Which data type is better to use for storing phone number in the following format “977-1-1234567”?

View solution

Q. What do you call a collection of records matching parameters of a query?

View solution

Q. Which query do you use to answer the question “Which employees earn more than $5000 a month”?

View solution

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