Core Training for Microsoft Access 2002

Working with Pages

Creating Static Web Pages

1 To start exporting the Alphabetical List of Products report to the Web, click the File menu, and click Export.
2 To specify a location where the report will be stored, in the Export Report 'Alphabetical List of Products' To dialog box, double-click the Garden Company folder, and then double-click the Vendors subfolder.
3 To assign a name to the report, click in the File name text box, and type AlphaProd.
4 To select the file type, click the arrow next to the Save as type text box, click HTML Documents, click the Autostart check box, and click Export.
5 To start exporting the report, in the HTML Output Options dialog box, click OK.
6 AlphaProd opens in Internet Explorer browser window. To view the next list of products, on the lower-left corner of the browser window, click Next.
7 To view the last page of the report, click once below the scroll box on the vertical scroll bar, and on the lower-left corner, click Last.
8 To close the browser window, on the title bar of the window, click the Close button.

Creating a Data Access Page with AutoPage

1 To start creating a new data access page, on the Objects bar, click Pages, and on the Database toolbar, click the New button.
2 To create the page using an AutoPage, in the New Data Access Page dialog box, click AutoPage: Columnar, click the arrow next to the Choose the table or query where the object's data comes from box, click Employees, and then click OK.
3 To save the page, on the Standard toolbar, click Save, and in the Save As Data Access Page dialog box that appears, click Save.
4 To view the Employees page in Internet Explorer browser, on the Windows taskbar, click the Internet Explorer icon.
5 To start opening the Employees page, in the browser window, click the File menu, and click Open.
6 To locate the Employees page, in the Open dialog box, click Browse.
7 To open the Employees page, in the Microsoft Internet Explorer dialog box, click Employees, click Open, and click OK.
8 To minimize the browser window and view the page in Design view, on the browser window title bar, click Minimize, and on the Database toolbar, click View.
9 To view the entire page window, on the upper-right corner of Field List, click the Close button.
10 To assign a heading to the page, on the upper portion of the page, click on the text Click here and type title text, and type Employee List.
11 To begin adding a list of all the actions that can be performed in the Employee List, press the down arrow key once, type While viewing this page, you can:, and press ENTER.
12 To add the actions as a bulleted list, on the Formatting toolbar, click the Bullets button, type Click Next or Previous to scroll records., and press the ENTER key.
13 To emphasize important words in the list, in the first bulleted item, double-click the word Next, and on the Formatting toolbar, click the Bold button.
14 To add a copyright message to the page, click once below the scroll box on the vertical scroll bar, on the lower portion of the page, click once below the navigation bar, and type Copyright 2003, The Garden Company.
15 To move up the page and start editing a label, click once above the scroll box on the vertical scroll bar.
16 To edit a label, double-click the First Name label, and in the Label : FirstName_Label properties dialog box, click the Other tab.
17 To change the First Name label, in the Properties dialog box, click the Inner Text property, type Name, and press the ENTER key.
18 To prevent users from deleting records, click once below the scroll box on the vertical scroll bar, on the lower portion of the page, click the navigation bar, and on the navigation bar, click the Delete (right arrow with red x) button.
19 To hide the Delete button on the navigation toolbar, in the Properties dialog box, click the Format tab, click the Visibility property, click the arrow next to the Visibility property text box, and then click Hidden.
20 To save the changes made to the page, on the Standard toolbar, click Save.
21 To return to Internet Explorer and view the page, on the Windows taskbar, click the Employees-Microsoft Internet Explorer tab.
22 To view the page with modified property settings, in the browser window, on the Standard toolbar, click the Refresh button.
23 To verify the changes made in the navigation toolbar, click once below the scroll box on the browser's vertical scroll bar.
24 The Delete button is not visible on the navigation bar. To close the browser window, in the upper-right corner of the window, click the Close button.
25 To close the Employees page, in the upper-right corner of the screen, click the lower of the two Close buttons.

Creating a Data Access Page with the Page Wizard

1 To begin creating a data access page, on the Database toolbar, click the New button.
2 To create the page using the Page Wizard, in the New Data Access Page dialog box, click Page Wizard.
3 To choose a query on which the page will be created, click the arrow next to the Choose the table or query where the object's data comes from box, click once below the scroll box on the scroll bar, click Products by Category, and click OK.
4 To move all the fields from the Available Fields of the selected query to the Selected Fields pane, in the Page Wizard dialog box, click the >> button, and click Next.
5 To set the order in which the records will initially be displayed, in the Page Wizard dialog box, double-click CategoryName, and click Next.
6 To set a sort order for the records, in the Page Wizard dialog box, click the arrow next to the text box numbered 1, click ProductName, and click Next.
7 Products by Category is an appropriate title for the page. To be able to apply a theme to the page, in the Page Wizard dialog box, click the Do you want to apply a theme to your page check box, and then click Finish.
8 To preview a theme for the page, in the Theme dialog box, in the Choose a Theme list, click Layers.
9 To select a theme for the page, on the Choose a Theme scroll bar, click once below the scroll box, click the theme Sumi Painting, and click OK.
10 To view the entire page, on the upper-right corner of Field List, click the Close button, and on the blank title bar of the Properties dialog box, click the Close button.
11 To assign a heading to the page, on the upper portion of the page, click the text Click here and type title text, and type Products by Category.
12 To view the page in Page view, on the Standard toolbar, click View.
13 To move to the next category of products, on the navigation bar, click the Next (right arrow) button.
14 To display a product record for the category Bonsai Supplies, to the left of CategoryName, click the + button.
15 To view the next product record for the category name Bonsai Supplies, on the upper navigation bar, click the Next (right arrow) button.
16 To move to the next category of products, on the lower navigation bar, click the Next (right arrow) button.
17 To close the Products by Category page without saving it, in the upper-right corner of the window, click the lower of the two Close buttons, and in the message box that appears, click No.

Saving an Object as a Data Access Page

1 To start saving an object as a data access page, in the Objects bar, click Tables.
2 To view the table to be saved as a data access page in Datasheet view, in the Tables pane, double-click Products.
3 To start saving the design of the Products table as a data access page, click the File menu, and click Save As.
4 To assign a name to this page, in the Save As dialog box, in the Save Table 'Products' To box, type Products Page.
5 To specify the object type for Products Page, click the arrow next to the As box, click Data Access Page, and then click OK.
6 To save Products Page in the Vendors folder, in the New Data Access Page dialog box, click OK.
7 To close Products Page displayed in Page view, in the upper-right corner of the window, click the lower of the two Close buttons.
8 To close the Products table, in the upper-right corner of the window, click the lower of the two Close buttons.
9 To open a form, in the Objects bar, click Forms, and then in the Forms pane, double-click Customers.
10 To save the form as a data access page, click the File menu, and click Save As.
11 To assign a name to this page, in the Save As dialog box, in the Save Form 'Customers' To box, type Customers Page.
12 To specify the object type for Customers Page, click the arrow next to the As box, click Data Access Page, and then click OK.
13 To save Customers Page in the Vendors folder, in the New Data Access Page dialog box, click OK.
14 To close the Customers form, in the upper-right corner of the window, click the lower of the two Close buttons.
15 Customers Page is displayed in the Page view. To view the next record, in the navigation bar, click the Next Record button (right arrow).
16 To close Customers Page, in the upper-right corner of the window, click the lower of the two Close buttons.
17 To confirm that the two objects have been saved as data access pages, in the Objects bar, click Pages.
18 To view Customers Page in the Internet Explorer Web browser, in the Pages pane, click Customers Page, and then on the Windows taskbar, click the Internet Explorer icon.
19 To open Customers Page in the browser window, click the File menu, and click Open.
20 To specify the location of Customers Page, in the Open dialog box, click Browse.
21 To specify the location of the file, in the Microsoft Internet Explorer dialog box , double-click Customers Page.
22 To open Customers Page, in the Open dialog box, click OK.
23 To close Customers Page, in the Customers - Microsoft Internet Explorer browser window, click the Close button.