Before you begin

1. 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 don’t have PowerPoint 2010, download the PowerPoint Viewer(see the URL in the notes pane).

2. Microsoft®Access®2010 Training Add the web to your databases

3. Course contents • Overview: Displaying web pages • Lesson: Includes one instructional movie • Suggested practice tasks • Test • Quick Reference Card Add the web to your databases

4. Overview: Displaying web pages In this course, you’ll learn how to use the Web Browser control to display web pages in an Access 2010 database. By way of example, we’ll explain how to use addresses in a database to display online maps and driving directions in an Access 2010 form. Add the web to your databases

5. 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

6. Add the web to your database 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. Add the web to your databases

7. 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. Online practice (requires Access 2010) Add the web to your databases

8. Test question 1 You can only display maps in the Web Browser control.(Pick one answer.) Add the web to your databases True. False.

9. Test question 1 You can only display maps in the Web Browser control. Answer: False. Add the web to your databases You can display maps, training videos, anything you need.

10. Test question 2 To create a calculated field, you usewhich 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.

11. Test question 2 To create a calculated field, you use which of the following? Answer: The Expression Builder dialog box. Add the web to your databases The video and the practice steps show you how to start the dialog box.

12. 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.

13. Test question 3 You must always use calculated fields as parameters in your URLs. Answer: False. 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.

14. 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

15. Test question 4 Based on the example in this course, which is the proper syntax for returning driving directions? Answer: =“adr.” & starting address & “~adr.” & ending address Add the web to your databases Remember, Access uses the quotation marks to include the ADR parameters in the URL.

16. Test question 5 When you enter a base URL in the Insert Hyperlink dialog box, you don’t enter a question mark. (Pick one answer.) Add the web to your databases True. False.

17. Test question 5 When you enter a base URL in the Insert Hyperlink dialog box, you don’t enter a question mark. Answer: True. Add the web to your databases Access adds the question mark for you.

18. Quick Reference Card For a summary of the tasks covered in this course, view the Quick Reference Card. Add the web to your databases