Microsoft Office Tutorials and References
In Depth Information
MAKING SEVEN PRACTICE QUERIES
FIGURE B-46
Design of a Parameter query, continued
Note that the Criteria line uses square brackets, as you would expect to see in a calculated field.
Now run the query. You will be prompted for the employee
s ID number, as shown in Figure B-47.
FIGURE B-47
Enter Parameter Value dialog box
Enter your own employee ID. Your query output should resemble that in Figure B-48.
FIGURE B-48
Output of a Parameter query
MAKING SEVEN PRACTICE QUERIES
This portion of the tutorial gives you additional practice in creating queries. Before making these queries, you
must create the specified tables and enter the records shown in the
Creating Tables
section of this tutorial.
The output shown for the practice queries is based on those inputs.
AT THE KEYBOARD
For each query that follows, you are given a problem statement and a
You also are shown
what the query output should look like. Set up each query in Access and then run the query. When you are
satisfied with the results, save the query and continue with the next one. Note that you will work with the
Employee, Hours Worked, and Wage Data tables.
scratch area.
1. Create a query that shows the employee ID, last name, state, and date hired for employees who
live in Delaware and were hired after 12/31/99. Perform an ascending sort by employee ID. First
click the Sort cell of the field, and then choose Ascending or Descending. Before creating your
query, use the table shown in Figure B-49 to work out your QBE grid on paper.
 
Search JabSto ::




Custom Search