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.
As you're working with your data, you may have some fields that you only need occasionally, instead of having to tab over them every time you enter in a new record, you can also hide them from view. I have opened my Customers table, and let's scroll over to the right. Find the FAX column, and right-click on the header, choose Hide Fields, and it disappears from view. Scroll over to the end of the table and also right-click on Documentation and hide that field as well. One warning: There's no visual to remind you that you've hidden some fields.
So while this may be handy in the moment, if you have multiple users of your database, make sure that they know that you've hidden the fields or they might not notice, or worse, they may think the columns have been deleted altogether and not entered in data as needed. When you want to bring back a field that's been hidden, right-click on Notes, and tell it Unhide Fields. This will bring up a checklist where you can pick and choose from the fields that you want to see again, you can choose one of them or all of them. And additionally use for hiding your Table fields, is to allow you just to view the data that you want to see at the time, without having run a query to exclude certain fields.
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.