Viewers: in countries Watching now:
Discover how to manage data entry and reporting tasks more efficiently using Access 2010. Author Adam Wilbert presents lessons on designing forms, organizing and displaying data with form controls, creating flexible queries, and building a form-based navigation system. The course also shows how to build reports from wizards and queries, highlight important data with conditional formatting, and automate reporting processes with macros.
The hyperlink and web browser controls allow your forms to reach out beyond the local database and into your computer right onto the Web, you can use the Hyperlink control to open a website or help embed online content right there inside of your database, let's take a look at how we can use Hyperlinks and web browser controls. In this Controls Forms I'll right-click and go to Design View. The Hyperlink control is this one right here with the global and the chain. I'll click on it and a Hyperlink wizard opens. I can choose to link to items within my computer, for instance, from this current folder I can scroll through and make a link to this TwoTreesCatalog file, which is a Word document.
I can say OK, and Access places a link to that document right inside of my form. If I go to Form view and click on that link, Access is going to warn me about a potential security notice, because it doesn't know exactly what file this is, but let me go ahead and say Yes, and that we'll open up Word with the document inside, so I can make any changes and save it right back to my computer. Let's go ahead and close Word that will take us back to Access and I'll switch back to Design View, let's add another hyperlink control. I'll click on that and the wizards starts again. I can choose to bring in web pages or recent files that I might have used. I can make a link to other objects in the database.
So for instance, I can link to a Form and it'll work the exact same way as is link to a file. I could also link to E-Mail addresses, so it can provide an easy link to e-mail the database developer, or I can go down here to Hyperlink Builder and connect directly to a website. So for instance, if I wanted to link to the Two Trees Olive Oil company website, I can just type URL right there in the address bar, http://twotreesoliveoil.com and press Enter. Access adds that link to my form as well; I'll switch to Form and try it out. It opens up my web browser and there is the Two Trees Olive Oil website, right there easily access within my form.
Okay, let's close this down; let's take a look at the web browser control as well. I'll switch my view back to Design View. The web browser control is the one right next to the Hyperlink; it's this one here at the box and the globe inside. The web browser control is new in Access 2010 and I really think this is cool; I'm going to first highlight these two and get rid of them. Now I will add a web browser control right inside my form and I will drag out of box when I like over the button the Insert Hyperlink wizard starts, it asks for an Address, let's say I want to add some content from Wikipedia. First, let me go find it on the web, I'll go out to my web browser and the Wikipedia article I want to link to is here, it's this Wikipedia article on Olive Oil.
Let me just highlight this address and I'll press Ctrl+C on my keyboard to copy it to the pasteboard, I'll come back down to Access. Now in the Address bar I'll press Ctrl+V to paste it in and I'll press Enter, that adds a web browser control link to the Wikipedia article. In the Format tab, I can change its size a little bit. Most web pages work pretty well with a website size of 960 pixels, so let me go ahead and just type that in. 960px to specify pixels and I will press Enter and Access will resize that object, let's go ahead and change to our View menu and I'll view our form. And after just a moment, the Wikipedia article loads right there inside of my form, I can scroll through and read the entire article.
So it makes it really easy to bring an external content for reference, let's take another look at this web browser control and something that I think is kind of cool. I can switch my view into Design View here and I'm going to delete the one that I put with Wikipedia, we'll add one more here and I'll just click to add that in there. Now let's say I wanted to add video content from YouTube, let me go back up to my web browser here, and if I switch to this page here, I've currently got the lynda.com YouTube channel up. Let's say I want to embed the content of this video right inside of my form. On YouTube, I'll click this Share link here and then the Embed code, this'll give the code that I need.
The piece that I want is his web source right here, the http portion. Now fortunately, I can't just select that portion, so I'm going to Ctrl+C to copy the whole block of text. I'll go back into Access, and I'll paste the whole thing here in the address bar and I'll delete everything after the URL, which ends right there with the first quotation mark that I can see, I'll get rid of that and then I'll scroll this back to the beginning, and I'll get rid of everything before the http, including that first parenthesis. So that leaves me just the URL for the video, I'll press Enter and that will apply down to the box. Now let's switch into the Form view and I can see the content of the video right inside of my form, I can even play it.
So bringing in content from the web can be a great way to add dynamic content to your database without having to store anything inside of it. Training or marketing documents, customer testimonial videos, specs on products and all kinds of information can be made available right within your database, so that's easy to get to when you need it.
There are currently no FAQs about Access 2010: Forms and Reports in Depth.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.