Microsoft Access

1. Microsoft Access Project 2

2. Objectives • State the purpose of queries • Create a new query • Use a query to display all records and all fields • Run a query • Print the answer to a query • Close a query • Clear a query

3. Objectives cont… • Use a query to display selected fields • Use text data and wildcards in criteria • Use numeric data and comparison operators in criteria • Use compound criteria • Sort the answer to a criteria

4. Objectives cont… • Join tables in a query and restrict the records in a join • Use calculated fields in a query • Calculate statistics in a query • Save a query and use a saved query

5. Introduction • Query • A question represented in a way that Access can understand and answer

6. Project Two – Querying the Alisa Vending Services Database • The Model

8. Opening the Database • File Open • Select the database you which to open

9. Creating a New Query • Using the Select Query Window • First create a new Select Query Window

16. Creating a New Query • Displaying Selected Fields in a Query

19. Creating a New Query • Running a Query

20. Creating a New Query • Printing the Results of a Query

21. Creating a New Query • Returning to the Select Query Window

24. Creating a New Query • Closing a Query

27. Including All Fields in a Query

30. Clearing the Design Grid

31. Entering Criteria • Using Text Data in Criteria

35. Entering Criteria • Using Wildcards

38. Entering Criteria • Criteria for a Field Not in the Result Click to see Figure 2-25 Click to see Figure 2-26 Click to see Figure 2-27

42. Entering Criteria • Using Numeric Data in Criteria

45. Entering Criteria • Using Comparison Operators

48. Using Compound Criteria • Using AND Criteria