Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
Access's Tables allow you to resize Rows and Columns so they don't cut off any data; some of these techniques are a lot like Excel. I have opened my SalesReps table in Datasheet View. If I hold my cursor very carefully over the line between my field names I'll get a double headed arrow, click and hold on it and you can drag to make your columns narrower or to make your columns wider. If you double-click on the line you can also best fit your column to the longest data in the fields. Note though that as you add new records to the table you may need to resize the column again if longer data gets added in the future.
Now take a look at the Table tools, Fields ribbon. Don't get fooled by this Field Size property, it does not refer to the apparent length of the column; this refers to the definition of the field where you specify the maximum number of characters that can be entered into the text field, to specify an exact column length right-click on the column header and choose Field Width off the shortcut menu. If you put a check mark in front of Standard Widths it will default to 13.4286, the standard column width for unformatted tables, you can change this to any width that you'd like, I'll click OK.
If I right-click on my Address column again and go into Field Width again I can also choose this Best Fit button, and the column will resize itself to the longest data entered in the field. All of these options are also available to resize your Rows. If you go over to the left of the records, point at the line between the records and drag down all of the rows will resize together. You do, however, have the ability to specify an exact row height. Right-click on one of the boxes to the left of the records and you'll get a shortcut menu, click on Row Height.
If I put a check mark in the Standard Height box it will default to 16.5, the standard row height for unformatted tables, and, of course, I can change this number to any Row Height that I'd like. I'll click OK. It's important that you have control over your Column and Row heights, if you didn't you could easily cut off your data.
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.