Article Index
Microsoft Access Tutorial
Queries
Creating A Database
Tables
Creating Tables
Queries
Forms In Microsoft Access
Reports In Microsoft Access
Data Access Pages
Controlling The User's Input
Subdatasheets
Designing Forms
Exploring And Analyzing Data
Tables Looks
Design And Exploration
Forms Design Propertie
Controlling Data Output
Microsoft Access Controls
Design And Improvements
Importing And Exporting Data
Macros
Switchboards

Creating An AutoPage: Data Access Page:

Start Microsoft Access and open the Videos1 database.

In the Database Window, click the Pages button.

On the toolbar, click the New Object button to drop its list and choose Page.

In the New Data Access Page dialog, choose AutoPage: Columnar. In the table/query combo box, choose tblVideos and click OK.

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.

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.

In the browser, click the New Record button and enter the following records:

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.

Open the Greater Highland High School database (GHHS).

In the Database Window, click the Pages button.

Double-click Create Data Access Page By Using Wizard.

In the first page, choose Table: tblStudentRegistrations. Select all fields and click Next.

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.

Click Next, Next. Save the page as dapStudentRegistrations and click Finish.

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.

Save the web page as dapregistrations.

Open the page in your browser and edit some records.

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:

Redundancy in database is the default of having the same data provided or entered in more that one component; having two different forms from where the user can enter the same customer's name is nasty is should always be avoided.

Furthermore, when you design your database and decide that some boxes will receive an employee's date of birth, you have to make sure that only a recognized date can be entered.

Different components of your database are meant to communicate and collaborate, allowing some data in one component to supply necessary data to another; this assures that the same data cannot be entered from more than one place, once more eliminating redundancy.