Resizing columns and rows


show more Resizing columns and rows provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Resizing columns and rows

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...

Resizing columns and rows
Video duration: 2m 7s 3h 43m Intermediate

Viewers:

Resizing columns and rows provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...