Define: QUERY Before I go into Access Queries I want to go over the meaning of the word “Query”. Query is an older style word and has a specific meaning. I got the following definition from reference.com: 1)    To ask or inquire about: “No one queried his presence.” 2)    To question as doubtful or obscure: [...]

Five Steps of the Query Process There are five steps to the query process: Step 1: Create & Name A New Query Step 2: Select Table(s) to Query Step 3: Select Output Fields Step 4: Create Query Selection Criteria Step 5: (Optional) Select A Sort Field One minor editorial comment – you don’t have to [...]

Three Access Query Views Like all other Access Database objects a query has multiple views. The most important views are: Datasheet View Design View SQL View (Covered in Module 7) The datasheet view is identical to the datasheet view in an Access table object and it shows the records selected by the query. The query [...]

Now we understand the theory behind creating a query we actually want to create our first query. There are dozens of different ways to create a query. We are going to start by creating our first Access query using the Simple Query Wizard.  It is very likely that you will quickly outgrow the wizard as [...]

Creating an Access query with the Simple Query Wizard is a great way to create your first query but as you become a Database SuperStarTM you will move faster and create not-so-simple queries. The query wizard will slow you down. Creating an Access query using the query design view (without the Simple Query Wizard) is [...]

A query with out criteria is like an Access table without data – mostly useless. Without query criteria we are just selecting fields, which is fine but we want to be a Database SuperStarTM so we want criteria, lots and lots of criteria. Query criteria allow us to select the exact records we want in [...]