Q. What determines a table’s sort order?

View solution

Q. What is an intersection of a row and a column?

View solution

Q. Which tool do you use to create a query object?

View solution

Q. Which of the following is not a view for interacting with a form object?

View solution

Q. What is the purpose of indexing?

View solution

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