How to Create and Edit a Query
1. Most of the queries that we use have already been programmed, but if you need to create a new query, the process is simple. Click on the Create tab in the Access Ribbon and select Query Wizard (far right).
2. In the Query Wizard, select the type of query you'd like to run: Find Duplicates (for example, finding how many bills a specific intern has worked on), or Simple Query Wizard, which will return the results from a specific fields from tables or other queries in the database.
3. Select the fields from which you would like to pull data, and give the query a name. It will appear in the list of queries in the left-hand navigation pane in Access until you delete it.
Example
InternalDatabaseKeyVotes
