Top of
the Page| Discovering Computers | Windows XP | Word 2002 | PowerPoint 2002 | Excel 2002 | Access 2002 | Site Map |
| Lesson 14 | Lesson 15 | Lesson 16 | Lesson 17 |
MS Access 2002: Publishing to the Internet Using Data Access Pages
To create a Data Access Page, you will need to use the Page Wizard. To run the wizard, you need to make sure that the table is selected in the Database window and then you should click the New Object: AutoForm button arrow on the Database toolbar as shown in Figure 2 in your book. The menu will appear and you should click on the Page option to open the New Data Access Page dialog box. Make sure that you click on the Page Wizard option in the list, select a valid table or query and then click the OK button.
The next page of the wizard lets you choose which fields you want to display on your Data Access Page. You can either select each field individually and then click the Add Field button or you can click the Add All Fields button. If you decide that you want to remove a field from the page, select it and then click the Remove Field button. Once you are done, click the Next button. The wizard will now ask you if you want to group your records. If so, select the field(s) that you want to group on and then click the Next button. The last page of the wizard will ask you to give the page a title and decide in what view you would like to open the page. To continue working on the page, you should click the Modify the page's design checkbox. Once you are done, click the Finish button to end the wizard and display your Data Access Page. To better understand the steps you just completed, see Figures 3-7 in your book.
When the design view appears, you should enter a title for the page by clicking in the upper area of the page where the label Click here and type title text is displayed. Once you have done this and are satisfied with the layout of the page, you should save it. Click on the Close Window button and the Microsoft Access dialog box should appear and ask you if you want to save the Data Access Page. Click on the Yes button to open the Save As Data Access Page dialog box. Enter the file name in the File Name box and then click the Save button. You may see one more dialog box that displays a message about including a Universal Naming Convention (UNC) as part of your file name. You do not need to be concerned about this and should just click the OK button to bypass this screen. Once this box closes, the Data Access Page will be saved and you will be able to use it to view data.
Once the Data Access Page has been created and saved, you can view it from an Internet Browser, such as Internet Explorer. If you are connected to the Internet, you can view the page by using the Web Page Preview from within Access. If you are not connected to the Internet, you can use the Open option from the short-cut menu within Access as shown in Figure 12 in your book. Either method will open the Data Access Page and you will be able to use the page just like a form.
Look at Figure 13 in your book . When you first view the Data Access Page, you will probably notice that there are many buttons on the toolbar at the bottom of the page. These buttons allow you to perform the following tasks:
Most of these functions should be familiar to you from working through the examples in the previous projects. The biggest difference here is what is displayed when you click on the Help button. Access goes straight to the help section that explains Data Access Pages as shown in Figure 14 in your book. As you have seen with the help features from previous lessons, there is a wealth of information available right at your fingertips.
| Lesson 14 | Lesson 15 | Lesson 16 | Lesson 17 |
| Discovering Computers | Windows XP | Word 2002 | PowerPoint 2002 | Excel 2002 | Access 2002 | Site Map |