R. Craig Collins > BCIS 1301 > Lab 7
R. Craig Collins > ITSC 1309 > Lab 7
|
R.
Craig Collins > COSC 1301 >
Lab 7 R. Craig Collins > BCIS 1301 > Lab 7 R. Craig Collins > ITSC 1309 > Lab 7 |
How To, Access Lab Notes © R. Craig Collins, 2006
Project 1
Project One, Step 1
Project One, Step 3
Project One, Step 4
Project One, Step 5
Project One, Step 6
Project One, Step 7
Project 2
Calculated Fields is a field that can be added to a query to compute data in
other fields.
• Place your insertion point in the first open column,
right click, and choose Zoom.
• Type in field name: then include
the field names in brackets seperated by the mathematical operation
• Hours worked:[field 1]/[field2]
Project Two, Step 1
Project Two, Step 2
Project Two, Step 3
Project Two, Step 4
Project Two, Step 5
Project Two, Step 6, part 1
Project Two, Step 6, part 2
Project Two, Step 6, part 3
Project Two, Step 7
Crosstab Queries
•Calculates statistics that is grouped in by different
areas, such as sales and commissions for different employees. The sales info
could go across the top, and employees would go down the side.
| Sales | Commision | |
| Employee 1 | calculated no. | calculated no. |
| Employee 2 | calculated no. | calculated no. |
| Employee 3 | calculated no. | calculated no. |
•Use the Crosstab Query Wizard
Either select the single table that contains all the fields you need, or perhaps select a query that joins the tables you will need. For this project, you could choose the single table that includes the customer balances, but I chose a query that joined both tables.
Crosstab, step 1
Crosstab, step 2; select the left column info, which will be the row label:
the Technician City
Crosstab, step 3; now to select the info for the top row, the column headings:
the Technician Number
Crosstab, step 4; what we actually want to display is the balances, by city
and technician, and to include a total
Crosstab, step 5
Project 3
Lab 7 will focus on updating a table design, look up fields, and sorting