Presidential Questionnaire

Name:

Search through your database to find the answer to the following questions in the Presidential Questionnaire.

1. How many Republican presidents were there? Name them. Save and name this query Republican Presidents.

2. How many Democrats were in office in the nineteenth century? Name them. (The years to search are the 1800s). Save and name this query Democrats in the 19th Century. Place this in criteria line : >"1799" And <"1900"

3. How many Republicans were in office in the nineteenth century? Name them. (The years to search are the 1800s). Save and name this query Republicans in the 19th Century. Place this in criteria line : >"1799" And <"1900"

4. How many past presidents are still alive today? Name them. (Hint: use the null criteria in this query) Save and name this Live Presidents.

5. Which president went by the nickname "The Gentleman Boss?" Save and name this query The Gentleman Boss.

6. Were there more Republican or Democratic presidents? Hint: You have already run the Republican Query. Run the query on the democrats and then save the one with the most as Most Party Nominated.

7. How many presidents served during a war? Name the presidents along with the war. (Hint: Use the "Is Not Null criteria"). Name this query Wars During Office.

8. Which president was in office during the War of 1812? Save and name this query President during the War of 1812.

9. Which presidents were in office for more than one term? Name them. (Hint: greater than one) Name this query Presidents for More than One Term. ( >1 will be your criteria)

10. How many presidents served only one term. Name them. (Hint: criteria is =1) Save and name this query Presidents serving One Term.

11. Who was the tenth president? Name him. (Hint: number is equal to 10) Name this query Tenth President.

12. Who was the twentieth president and what party did he belong to? Name this query Twentieth President With Party.

13. Which president was called "The Man of the People," and what party did he belong to? Save and name this query The Man of the People with Party.

14. Which president served more than 2 terms and what party did he belong to and what was his nickname? Save and name the query President who served more than 2 terms with Party and Nickname.

15. Who was president during the Mexican War and what other positions did he hold? Save and name this query President during the Mexican War and Other Positions Held.

16. Which presidents belonged to the Whig Party, name them. Save and name this query Presidents of the Whig Party.

17. Which president had the nickname Old Buck and what accomplishments did he make? Save and name this query President "Old Buck" with Accomplishments.

18. Which presidents died in 1901 and what were their nicknames if any? Save and name this query Presidents Deaths in 1901 With Nicknames .

19. Which presidents served during the 19th century and served two terms in office? Save and name this query Presidents Who served 2 Terms During the 19th Century.

20. Who was president during the Vietnam war who served two terms and what was his nickname? Save and name this query President During the Vietnam War.

Now that you are a Access Wizard, create 5 questions of your own. Write out the questions and run the query for each and save them with a name you assign to it.