微软office 2010中文官方培训课件-向数据库添加 web

Before you begin,If a yellow security bar appears at the top of the screen in PowerPoint, click Enable Editing.,You need PowerPoint 2010 to view this presentation. If you dont have PowerPoint 2010, download the PowerPoint Viewer (see the URL in the notes pane).,Microsoft Access 2010 Training,Add the web to your databases,Course contents,Overview: Displaying web pagesLesson: Includes one instructional movieSuggested practice tasksTestQuick Reference Card,Add the web to your databases,Overview: Displaying web pages,Add the web to your databases,In this course, youll learn how to use the Web Browser control to display web pages in an Access 2010 database.By way of example, well explain how to use addresses in a database to display online maps and driving directions in an Access 2010 form.,Course goals,Create a calculated field in a table.Add the Web Browser control to a form. Create a URL that uses the calculated field as a parameter.Create an expression that returns driving directions.,Add the web to your databases,Add the web to your database,Add the web to your databases,Point to the bottom of the video to see the video controls. Drag or point along the progress bar to move forward or go back.,Suggestions for practice,Create the calculated field.Add the browser control.Format the control. Add driving directions to the map.Find help for Bing maps.,Add the web to your databases,Online practice (requires Access 2010),Test question 1,You can only display maps in the Web Browser control. (Pick one answer.),Add the web to your databases,True.False.,Test question 1,Add the web to your databases,You can display maps, training videos, anything you need.,You can only display maps in the Web Browser control.,Answer:,False.,Test question 2,To create a calculated field, you use which of the following? (Pick one answer.),Add the web to your databases,The Insert Hyperlink dialog box.The Lookup Wizard.The Expression Builder dialog box.The Calculated Field object in the Application Parts gallery.,Test question 2,Add the web to your databases,The video and the practice steps show you how to start the dialog box.,To create a calculated field, you use which of the following?,Answer:,The Expression Builder dialog box.,Test question 3,You must always use calculated fields as parameters in your URLs. (Pick one answer.),Add the web to your databases,True.False.,Test question 3,Add the web to your databases,Part of the data for your URLs may come from your tables, but they can be regular table fields.,You must always use calculated fields as parameters in your URLs.,Answer:,False.,Test question 4,Based on the example in this course, which is the proper syntax for returning driving directions? (Pick one answer.),Add the web to your databases,=“adr.” & starting address & “adr.” & ending address=adr. & starting address & adr. & ending address=“adr.starting address”adr.ending address”=“where1.” & starting address & “where2.” & ending address,Test question 4,Add the web to your databases,Remember, Access uses the quotation marks to include the ADR parameters in the URL.,Based on the example in this course, which is the proper syntax for returning driving directions?,Answer:,=“adr.” & starting address & “adr.” & ending address,Test question 5,When you enter a base URL in the Insert Hyperlink dialog box, you dont enter a question mark. (Pick one answer.),Add the web to your databases,True.False.,Test question 5,Add the web to your databases,Access adds the question mark for you.,When you enter a base URL in the Insert Hyperlink dialog box, you dont enter a question mark.,Answer:,True.,Quick Reference Card,For a summary of the tasks covered in this co