Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 81341 Viewers
80 Video lessons · 133253 Viewers
52 Video lessons · 66621 Viewers
59 Video lessons · 52433 Viewers
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.
Your file was successfully uploaded.