Access Basics:
Data Access Page

Step-by-Step: Create a Data Access Page

---

What you will learn:

to create a data access page using the wizard to create and format a page title to select multiple objects to change properties in Property dialog

---

Start with: mytrips.mdb from previous lesson

Create a Data Access Page with the Wizard

Since the AutoPage is so boring, let's try the Page Wizard to create your first data access page.

1. If necessary, switch to the Database Window.
    
2. Click on Pages in the list of objects at the left.
    
3. Double-click the link Create data access page by using wizard.
   The Page Wizard opens to the first of 4 steps
    
4. Choose Table: Trips in the first text box.
    
5. Click on the >> button to move all of the fields from Available Fields to Selected Fields.
    
6. Click on the Next button.
    

   In the second step of the wizard, you could choose a grouping level, but none of these would be helpful for this page.
    

7. Click the Next button.
    
8. In third step of the wizard, in the top box, select DateStarted and Ascending for the button beside it.
    
9. Click the Next button.
    
10. In the fourth step of the wizard, type the name  Trips Page  in the text box.
     
11. Click on the radio button "Modify the page's design" and also in the checkbox for "Do you want to apply a theme to your page?"
     
12. Click on the Finish button.
    The Theme dialog appears. A pre-designed theme is a set of formats and lines and buttons for a web page. For your data access page, you won't use many of the design elements, but this is a fast way to get some visual interest on your page.
     
13. Scroll the Theme list and click on various themes.
     
    A sample of the features of the theme shows in the right pane of the dialog window.
     
    Especially notice  at the bottom the example of a label with data. Your data access page will be almost entirely made up of these.
     
    Which themes are available depends on which version of Office you have installed. Themes may not be installed.
     
    Problem: Theme must be installed:
    When you click on a theme, you may get a message on the right about installing the theme. To install the missing themes, you will need to have the correct Office installation CD. Just click on the Install button and follow the directions. You will not have to shut down Access or reboot the computer.
     
14. Click on the theme Expedition and then on OK. The theme is applied to your page in Page Design View.
     

Change a theme: To switch to a different theme later, in Design View open the Format menu and select Theme... The Theme dialog will open again.

---

Page Design View: Create & Format Title

At the top of the page in Design View is an area for a title. It has some text that is barely readable in this theme: "Click here and type title text. "

1. Click in the title area and type My Trips.
2. Select what you just typed and click the Left Align button.
    
3. While the text is still selected, open the palette of colors for Font/Fore Color by clicking the down arrow on the toolbar button with the A.
    
4. Select Brown in the top row.
    
5. Click below the title in the blank area. The cursor shows you that there is a blank line there.
    
6. Backspace to delete the blank line.
   
   
    

---

Page Design View: Modify Labels with Property Dialog

This simple layout needs some help. Do you see what the problems are?

1. Inspect the labels beside each control.
   Strangely, the wizard did not make the labels tall enough to show the bottoms of letters like y and g. This is not a hard problem to fix! There are two choices - reduce the font size or change the label height. This time we will go for taller labels.
    
2. Drag from below the label Diary straight up the page to DateStarted. Do not drag across any of the white controls.
   Release the mouse button.

      

         Dragging across labels; Labels selected

    All of the labels now have handles (black squares), which shows that they are selected.

   Alternate method of selection: Click on the first label. Hold the SHIFT key down and click on each of the other labels that you want to include in the selection.
    

   Dragging across controls may not select them in a Form or Report:
   You can change the selection behavior to select only if completely enclosed by the dragging rectangle or if partially enclosed.  (Tools | Options... | Forms and Report | Selection behavior.)
   Problem: Can't select more than one object at a time:
   You must have installed Internet Explorer 5.5 or a later version.
    

3. If necesssary, click on the Properties button on the toolbar to open the Properties dialog.
    The dialog is titled "Multiple selection".
    
4. If necessary, click on the Format tab or the All tab.
   The properties are happen to be in alphabetical order this time.
    
5. Scroll until you can see the Height property, which is currently set to 0.177in.
    
6. Click on the Height property. A down arrow appears in the white area.
    
7. Click the down arrow and select auto from the one-item list. (Other properties have more choices!)
    
   The labels all get taller and show the letters properly.
    
8. Inspect the labels again to be sure that all parts of each letter are visible. If you missed any, select the label by clicking it and change its Height property to "auto".
    

---

Page View: Are there problems?

Now you need to check how well the data access page works when there is data showing in the controls. Since the labels were not sized correctly, you might suspect that there will be a problem with the controls, too.

1. Switch to Page View by clicking the Views button, which should be showing the Page View icon (which looks just like the Form View icon!)
    
2. Navigate through all of the records. Do you see any problems?

    

   • Dates: Too narrow
     The DateStarted and DateEnded controls are missing a digit in some records.
   • Links: Too narrow, too short, not clickable
     The PhotoLink control only shows the first bit of the link URL.  Letters like j and g that hang down below the line are cut off. The text is not a clickable link like it was in the form.
   • Memos: Not large enough
     The Diary control is missing a lot of the text in some records.
   • Arrangement: not logical
     Logically, the DateEnded control ought to be up near the DateStarted, which got moved to the top by the wizard because you sorted on it.

   These problems are fixable but a couple will require more work than we want to deal with at this point in the lessons.
    

3. Switch back to Page Design View.
    

---

Page Design View: Resize and Move Controls

We can easily fix the size of the controls. There are actually two choices - change the font or change the size of the control.

Dates

1. Click on the DateStarted control. Hold the SHIFT key down and click the DateEnded control. Both should have handles, showing that they are both selected.
    
2. Move your mouse pointer over the middle handle at the right edge of the DateEnded control and drag right until the edge is on the vertical gray line. Release the mouse button.
    
3. Move the mouse over the DateEnded control until the pointer changes to the hand shape.
    
4. Drag the control (the label will move, too) up to the top of the page level with the DateStarted control and drop.
    

Hyperlink

1. Click on the PhotoLink control to select it.
    
2. Move your mouse pointer over the handle in the center of the bottom edge and double-click.
   The control enlarges to the Auto size.
    
3. Move your mouse pointer over the handle in the center of the right edge and drag to the edge of the grid. Release the mouse.

   

4. Switch to Page View and navigate the records. Is the PhotoLink control OK now?
    
   Not really! The PhotoLink control is not a clickable hyperlink like it was in the form. It is showing the Display text and then the hyperlink between hash marks (#).  Kauai#http://jegsworks.com/Lessons/images/trips/kauai/kauai.htm#
   The new size for the control shows all of the characters except perhaps the last #. But, future links might have more characters.
    
   There is a way around this, but it requires entering some scripting code and the addition of another object on the page. That is beyond what we are trying to do in this section of lessons. We will leave this problem standing for now.

---

Page Design View: Move Multiple Controls

There is now a blank area in the middle of the page where the DateEnded control was. You can move the other controls up.

1. Drag from the right of the Diary control up and over to the label Description. Release.
   
   All of the controls and labels that you touched should now be selected.
    
2. Move the mouse pointer back over one of the selected items until the pointer changes to the hand shape again.
    
3. Drag up until the Description control is just below the PhotoLink control. Drop.
    
4. Switch to Page View and navigate through all of the records. All dates should be showing all digits. The PhotoLinks should all fit in the control.

---

Page View: Problem with Memo Controls

The Page Wizard created large controls for the fields with the Memo data type. But the size was not picked by looking at the actual values. The Description text seems to fit in the allowed space for all of the records. The Diary text, however, is much longer than will fit in the default control size. In the report we used the Grow and Shrink properties, but those are not available for a data access page. In the form some scroll bars appeared when there was more text than would fit. We can add scroll bars to the page, too.

1. Switch back to Page Design View.
    
2. Click on the Diary control to select it.
    
3. If the Properties dialog is not open, right click on the Diary control and from the popup menu, select  Element Properties .
    
4. If necessary, click on the All tab and scroll until you can see the Overflow property.
    
5. Switch back to Page View and navigate to each record. When there is a vertical scroll bar, you know there is text that is out of sight. Neat!