Creating Data Access Pages with Charts using Office Web Components - Monthly temperature chart for Princeton
(Page 2 of 5 )
Create an empty data access page by clicking on Create data access page in Design View or using the New toolbar menu item. This opens up the New Data Access Page window where you highlight the Design View and click OK. You may get a version related warning as shown.
When you click OK, as seen in the above picture, you should see this design view of the data access page. The central rectangular area is where you are going to place the chart component.
Now click on the chart component marked in the above picture and place it on the design view of the data access page as shown. The Microsoft OWC control has been resized to fill the design area as shown.
You may right click and look at the object properties if you need to make changes. Here most default options are taken.
Now click on the the OWC control so that its handles are visible and right click this component. You will get a context sensitive menu as shown.
Now click on the Data... which opens up the next window where you need to choose a source of data. You have three options to choose from.
If you choose the first option of typing the value into a datasheet, then step 2 becomes active and you will be guided. In the present case, the third option is chosen. This changes the previous window to the one shown in the next picture. It uses the MSODSC. Now click on the Data Details tab and choose the PrincetonTemp table from the drop-down. This procedure of choosing data will be the same for the other two tables as well.
Next: Monthly temperature chart for Princeton continued >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
