Data Access Pages

If you are using Microsoft Access 97, skip this section.

Introduction:

A Data Access Page is a form you create for users on the Internet using a browser. Your can accommodate you users and/or visitors with a convenience application they simply have to fill out. The form also has a lot of functionality and flexibility.

There are different ways you can create a Data Access Page, using a click of the mouse, using a wizard, or design a better one.

Like a query, a form, or a report, a Data Access Page gets its fields from an existing table or query. You can also modify an existing web page to design your Data Access Page.

Creating An AutoPage: Data Access Page:

1. Start Microsoft Access and open the Videos1 database
2. In the Database Window, click the Pages button
3. On the toolbar, click the New Object button to drop its list and choose Page.
4. In the New Data Access Page dialog, choose AutoPage: Columnar. In the table/query combo box, choose tblVideos and click OK.
5. A quick and cute page is created for you. Save the page as dapvideos, and close it.

Opening A Data Access Page:

There are two ways you can preview your Data Access Page. Using Windows Explorer to launch the page or opening it from the browser.

1. Open Windows Explorer, locate the folder where your databases are located (where the page was saved), this should be C:\Microsoft Access Exercises and then double-click dapvideos.htm. That should call your default browser and show the page you created. If the browser is already opened, click File ->Open... Then browse the hard drive, different drives and folders, then open the dapvideos web page.
2. In the browser, click the New Record button and enter the following records:
   
3. When you have finished, close the Videos2 database.
   

Creating A Data Access Page From Wizard:

You can create a quick Data Access Page using the wizard and allow people to use it on the Internet.

1. Open the Greater Highland High School database (GHHS )
2. In the Database Window, click the Pages button.
3. Double-click Create Data Access Page By Using Wizard.
4. In the first page, choose Table: tblStudentRegistrations. Select all fields and click Next.
5. Make sure items are not in any grouping, in other words, you should have a complete blank/white list/paragraph of the table's items on the right list (no blue item on top). If you happen to have a grouping of items, remove the header of the list.
   
6. Click Next, Next. Save the page as dapStudentRegistrations and click Finish.
7. Make sure you are in Design View. On top of the page, click the Click Here And Type Title Text line, then type: Online Student Registration.
8. Save the web page as dapregistrations .
9. Open the page in your browser and edit some records.
10. Then you are free to close everything.

Exercises:

The DCMS, Inc.'s Business Resources database.

• Open the DCMS database.
• Press F11 to access the Database Window.
• Double-click the Asset Categories table to open it in Datasheet View. Type the following asset categories: Desktop PC, Bookshelves, Furniture, Car, Copier.
• Open the Status table and type the following: In Service, On Repair, Inactive, Non-Existing.
• Open the Employees table. Move the Extension right of the WorkPhone field. Make the following entries:
  

Help In Microsoft Access:

Click the Office Assistant and type Data Access Pages .

Click Create A Data Access Page .

Source : Function-X