Access ( Basic Information system ) Its a multiple choice question

1.In an Append query, what happens to any records that violate the Primary key (or any other) rule?

2.Of the four action queries, which one would help you find records that are the same after you appended an Excel spreadsheet of data into your table?

3.Of the four action queries, which one would help you find repeat customers?

4.Of the four action queries, which one would help you track student grades over the past decade?

5.The first step in creating a Delete query is to create what other type of query?

6.What happens when a Make Table query is run when a table with the same name already exists in the database?

7.Every form or report must have at least how many controls?

8. Creating a Combo Box is perfect when data ________.

9.Where does a form header appear?

10.Which view gives the database designer more control over the look of the form.

11.What key is often used in a form to advance from one field to another?

12.What is one way the user can tell that records cannot be deleted in a form?

13.When might you not want to skip a tab stop?

14.What is a ScreenTip?

15.What is the default program for opening CSV files?

16. What is not a primary key option when importing a text file into Access?

17.Which of the following Access objects cannot be exported to Excel?

18. XPS is considered an alternative to what file format?