Working With the Supplied Forms
IIHE  |  Education  |  Getting Started With Microsoft Access  |  Working With the Supplied Forms

We've supplied five forms that make it easier to create queries. With these forms, you can create a query with just a few mouse clicks. To open a form, open the database and then click on the Forms tab:

Now, double click on the HFHS Panel Admissions Search Form or click on the HFHS Panel Admissions Search Form and then click on the Open button:

It's easy to use the form. If a field (e.g., Age or Disposition) is left blank, then that field will have no effect on the query. Let's look at the section dealing with Site:

The All box is checked. This means that the query will include data from all the sites. If you click on one of the other check boxes like Detroit Northwest, you can limit the records in the query to that site. Notice that when you click on one of the sites, the All box becomes unchecked. One of the properties of check boxes is that you can have more than one checked at the same time. In other words you can include two sites in the query at the same time.

Let's look at the Sex section now:

This is pretty simple. The only reason that we mention it is to talk about radio buttons. With radio buttons, you can only have one button selected. One other note, there are some people in the databases that do not have their sex noted, so adding up the number of males and females may not add up to 100 percent.

The Age section uses another form:

Here, you can ask for a range of ages. By not entering anything in the boxes, the query includes all ages. By entering a number in only one of the boxes, the query will include people that are that number of years old. For instance, if you entered 53, then the results would only have 53 year old patients. If you want people that are in their twenties, you would enter 20 and 29. The forms check that the age you enter is between 0 and 200; you will receive an error if you enter an age outside of this range.

A fourth type of entry box is used in Primary DRG:

Here records are included only if they use one of the selected names. For the Primary DRG, you can find records that match up to 5 codes. If you need more codes, you can modify the query that the form creates. See the Editing a Query page for details.

If you know the codes that you want, type them in. If you enter an invalid code, a get the message:

You have to correct or delete the code you entered after clicking on the OK button. Notice that there is a pop up menu on the right side of the codes. If you click on the pop-up button, you see:

The pop-up menu displays the valid codes along with their descriptions. you can scroll through the list and pick out the code you want. Also, you can bring up the pop-up menu and then begin typing the code you want The list will scroll the part of the list you're referencing. For instance, if you type a 2, the list jumps to the 200's and then if you type a 5, the list jumps to the 250's.

The Form Buttons

You use the buttons at the bottom of the form when you are through filling out the form:

Button	Description
Search	Creates a query with the criteria shown. You will be asked to name the query.
Clear Form	Clears all the text boxes for a new search.
Exit	Closes the Form without doing a search.

If you click on the Search button, you are asked:

The name is automatically generated and will be used for the new query. You should enter a new name that is more descriptive. If the name you enter is the same as one of the current queries, you are asked:

The old query will be overwritten if you click the Yes button. If you click on the No button, you return to the previous dialog and are asked to name the query again.

Once you enter a unique query name, the query is run and the results are shown below:

Let's take a look at the design of the query. Click on the button on the toolbar to go to Design view:

Here you can see how the query is made. This query includes females (SEX_CD = "F") that are in their twenties (AGE_YRS Between 20 and 29). In the next section, you will learn how to create and modify queries.

Using Tables  |  Getting Started With Microsoft Access  |  Creating a Query