Access Controls  «Prev  Next»

Using Access Chart Wizard

For further practice, try this on your own in Access, using another instance.
Let's review the correct steps to take:
  1. In the New Form dialog, use the qryHoursByProjectForClientNo query. To do this click on the drop-down with the title "Choose the table or query where the object’s data comes from:"
  2. Now choose qryHoursByProjectForClientN.
  3. Now that the record source has been chosen, it is time to tell Access to use the Chart Wizard. Click the Chart Wizard in the list of wizards displayed.
  4. Click the OK button.
  5. Now you see the first page of the Chart Wizard. This screen lets you specify which fields to use for the chart’s x and y axes. Click the ProjectDescription listed in Available Fields column.
  6. Click the > button to move the ProjectDescription field over to the Fields For Chart column.
  7. By default, the wizard highlights the next field in the Available Field list. Click the > button to move the "Sum of Hours worked" field over to the Fields For Chart column.
  8. Click the "Next >" button.
  9. You can now see the various types of chart available to use. For our purposes, click the Pie chart in the bottom left-hand corner.
  10. Click the "Next >" button.
  11. This screen shows you how your data will look in the chart type you have chosen. You can change data around if you need to here, but this time, it is not necessary. Click the "Next >" button.
  12. This is the last screen. Although this screen allows you to change a number of items with the chart, we are going to go ahead and just change the title of the chart. To start, click the DEL key.
  13. Type in "Projects" for the new title. Then click the Finish key.
  14. Now, Access will open the form that was created with the Chart wizard. Since the query that the chart is based on uses a criteria setting, you are asked to enter a client number. Type "1" and click OK.
  15. When you rerun this and enter a different client number, all projects for that client are reflected.