Viewers: in countries Watching now:
In Access 2010 Power Shortcuts, Access expert Alicia Katz Pollock shares hundreds of tips and shortcuts to vastly increase efficiency and get the full power out of Access 2010. The course includes tips for working with the Ribbon and Quick Access toolbar, managing files, customizing and automating Access, rapid data entry and editing, working with tables, queries, forms, and reports, managing your database, and much more. Exercise files accompany the course.
When you enter in web site URLs or e-mail addresses, Access will automatically underline them, color them blue, and turn them into hyperlinks. This is useful for quickly jumping to the Internet or making new e-mail messages. But if you're just looking at the data or needing to print, all the formatting can be distracting. Here is how to remove automatic hyperlinking. I am in my Customers table, and I am scrolled over to the right so that I can see the Web Page and Email Address columns. You'll be tempted to use the same technique that you might use in Word.
To right-click on the link, go down to Hyperlink, and choose Remove Hyperlink. But in Access 2010, for some reason, this erases the entire field. I will press Escape on my keyboard so that this error doesn't get saved. The only way to turn off the formatting is to not use the hyperlink field type. I will go up to the Customer's tab, right-click on it and change to Design View. I will scroll down and click on WebPage and I will change the data type from Hyperlink to Text and I'll do the same thing for EmailAddress; change Hyperlink to Text.
Now when I go back to the Customers table tab and right-click on it, I will go back to Datasheet View, it will ask if I want to save my changes and I certainly do. I get a message that says, some data maybe lost, but that's okay, I'll click Yes. Now when I scroll over to the right, my Webpages and my Email Address are plain text. But do note that I no longer have any interactivity. If I want to go to the Webpage or start an e-mail to that person, I now need to highlight the data, then copy and paste it into my browser or new e-mail message.
Whether you choose to remove the automatic hyperlinks, will depend if it will be more convenient to click on the links to communicate or to see the data in plain text.
There are currently no FAQs about Access 2010 Power Shortcuts.
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.