Microsoft Office FrontPage 2003

1. Microsoft Office FrontPage 2003 Tutorial 8 – Integrating a Database with a FrontPage Web Site New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

2. Understanding Databases • A database, or a relational database, is a collection of related tables that store data about an object. • A field is a single characteristic of an object. • The set of fields in a table related to one particular object makes up a record. • A common field appears in two or more tables in the database. • Microsoft Office Access 2003 is a relational database management program that lets you create and maintain a database. New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

3. Related Tables in a Database New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

4. Starting Access and Opening an Existing Database • Click the Start button on the taskbar, point to All Programs, point to Microsoft Office, and then click Microsoft Office Access 2003. • Click the Open button on the Database toolbar to open the Open dialog box. • Click the Look in list arrow, navigate to the drive or folder that contains the database, and then double-click the database filename to open it. • If a Security Warning dialog box opens, click the Open button. New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

5. Database Window for the Requests Database New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

6. Creating a Database Connection • A database connection specifies the name, location, and type of database that you want to access. • File-based connection • System DSN connection • Network connection • Custom connection New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

7. Importing an Access Database into a Web Site • Click the Start button on the taskbar, point to All Programs, point to Accessories, and then click Windows Explorer. • Browse to the database that you want to import into the Web site, right-click it to open the shortcut menu, and then click Copy. • Close Windows Explorer. • Start FrontPage and then open the Web site in Folders view. If necessary, display the Folder List. • Right-click the Folder List to open the shortcut menu, and then click Paste. • Enter the database connection name, click the Yes button, and then click the Yes button again. New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

8. Verifying a Database Connection • Click Tools on the menu bar, click Site Settings, and then click the Database tab. • Click the connection name in the list box, and then click the Verify button. • Click the OK button. New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

9. Verifying a Database Connection New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

10. Setting a Web Site to Run Scripts • Open the Web site in Folders view. • Click Tools on the menu bar, and then click Page Options. • Click the Authoring tab to display those settings. • If necessary, click the ActiveX controls and VBScript check boxes to select them, and then click the OK button. • Right-click the Web site’s root folder in the Folder List (the default folder is http://localhost/[Web folder name]) to open the shortcut menu, and then click Properties. • Click the Allow scripts to be run check box to add a check mark to it. • Click the Allow files to be browsed check box to add a check mark to it. • Click the OK button. New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

11. Setting a Web Site to Run Scripts New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

12. Creating a Database Results Region in a Web Page • Open the existing page in which to insert the Database Results region in Design view, or create a new page in Design view. • Position the insertion point where you want to insert the Database Results region. • Click Insert on the menu bar, point to Database, and then click Results. The Database Results Wizard starts. • Click the Use an existing database connection option button, and then, if necessary, click the list arrow and select the database connection name. Click the Next button. • Click the Record source option button, click the list arrow, click the object in the database that contains the data you want to display, and then click the Next button. New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

13. Creating a Database Results Region in a Web Page • If necessary, click the Edit List button to select and/or reorder the desired fields to display in the Web page, and then click the OK button. To apply a filter to the records, click the More Options button, use the More Options dialog box to create the filter, and then click the OK button. Click the Next button. • Select a formatting option for displaying the data, and then click the Next button. • Select an option for displaying returned records in the Web page, and then click the Finish button. New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

14. Creating a Database Results Region in a Web Page New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

15. Creating a Search Form in a Web Page That Queries a Database • Create a new Web page, click Insert on the menu bar, point to Database, and then click Results. The Database Results Wizard starts. • Confirm or set the options in the first two dialog boxes. • In the third dialog box, click the More Options button. The More Options dialog box opens. • Click the Criteria button to open the Criteria dialog box. • Click the Add button. The Add Criteria dialog box opens. New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

16. Creating a Search Form in a Web Page That Queries a Database • Select the field name and comparison operator to use in the query. • If necessary, click the Use this search form field check box to add a check mark to it. • Click the OK button. Click the Add button to specify additional criteria (if necessary), or click the OK button to close the Criteria dialog box. • Click the OK button to close the More Options dialog box. • Confirm or set the options in the remaining dialog boxes, and then click the Finish button. New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

17. Creating a Search Form in a Web Page That Queries a Database New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

18. Configuring a Form to Send Results to a Database • Right-click the form component in the Web page to open the shortcut menu, and then click Form Properties. • Click the Send to database option button, and then click the Options button. • Click the Database Connection to Use list arrow, and then click the name of the database connection. If necessary, click the Table to hold form results list arrow and select the table in the database in which to store the form results. • Click the Saved Fields tab, and then select the database column name that will store the data for each form field in the form component. • Click the Additional Fields tab, and then select or remove any additional fields in which to store data. • • Click the OK button. New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

19. Configuring a Form to Send Results to a Database New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

20. Creating a Data Access Page • A data access page is a Web page that uses a form to display data from the Access table or query on which it is based. • A data access page includes controls that let you add, delete, sort, filter, and change the records displayed. • You must use Access to create and format a data access page. New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

21. Creating a Data Access Page • Double-click the database in the fpdb folder in the Web site to start Access and open the database. • Click the Pages object in the Objects bar of the Database window. • Double-click Create data access page by using wizard in the pages list. • Select the table or query on which to base the data access page, select the fields to include in the data access page, and then click the Next button. • Select an optional grouping level, and then click the Next button. New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

22. Creating a Data Access Page • Use the drop-down list(s) to select an optional sort order, and then click the Next button. • Either edit the suggested title or accept the default title, and then click the Finish button. • Click the Save button on the Page Design toolbar, open the Web site in which to store the page, click the Save button, enter the page’s filename, and then click the Save button. New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

23. Creating a Data Access Page New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

24. Adding a Record to a Database Table Using a Data Access Page • Click the New button on the record navigation bar in the Web page. • Enter the data into the text boxes. Press the Tab key to move the insertion point to the next text box. • After entering data in all of the text boxes, click the Save button on the record navigation bar to save the record. New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

25. Adding a Record to a Database Table Using a Data Access Page New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7

26. Project Eight Completed Good Luck H. Zamanzadeh New Perspectives on Microsoft Office FrontPage 2003 Tutorial 7