Office 2007 - Access

Lesson 9: Working with Tables

9/72 Lessons 

Hide Columns

In “Access”, we have the ability to hide columns (fields)

To hide columns, first select the column or columns.

Right-click and choose “Hide Column (s)” in the drop-down menu.

To make this column (s) visible again , right-click any column title and select “Unhide Columns …” from the drop-down menu.

In the “Unhide Columns” pop up window that appears, click the box next to the column (s) you want to make visible again.

Freeze Columns

Just like in “Excel”, in “Access” also we have the possibility to freeze columns.

Select the column (s) you want to freeze.

Right-click a selected column and choose “Freeze Column(s)” in the drop-down menu.

The dividing line between the freezed column and remaining columns is made bold.

To undo the freeze, right-click on a column title and choose “Unfreeze All Columns” in the drop-down menu.

Adjusting Column Width

Just like in “Excel” we have the option to set the width of the columns.

Place your cursor between the two titles for this column, when it changes into a two-arrow, click and drag it to the desired width.

To set the width of multiple columns simultaneously, select them all.

Place your cursor between two columns titles, when it changes into a two-arrow, click and drag it to the desired width.

To select multiple columns, hold the “Shift” key pressed on your keyboard.

A second way to change the column width is to right-click and choose “Column width” in the drop-down menu.
In the dialog that appears, we have several options:

 

In the “Column width”, you can manually enter a width.

You can check the “Default width” option, which gives you a width of 11.55.

And you can click on the “Best Fit” and the width of the column will adjust as per the data in this column.

Another way to make a column width “Best Fit” is to double click on the the double arrow that appears when we see the mouse pointer between two column headings.

Filter Records

Access 2007 has filtering capabilities in the table, like a table in Excel 2007.

Just click the downward pointing arrow beside the column title.
This opens a list of the unique values from the field.
Click the box “Select All”.
This removes the check boxes for all.
Select the checkbox for the fields that you want to view data in the table.
For example, “Alice Cooper” and “Deep Purple”.

Click the OK button.

Result:

Note that a filter icon is added next to the column title.

To remove the filter, click again on the downward pointing arrow next to the title.

And click “Delete Filter Group”.

You have the option to filter on one or more columns.

With the filter option drop-down list, you also have the ability to filter out certain parts of the text.

This can be useful if for example you are looking for something that you do not exactly remember the name, but only the starting letter (s) of the name.

Choose from the sub-list “Begins with …”.

This opens a dialog window where you can type the first few letter that you still remember.

Click OK.

All options in the sub-list of text filters are pretty self explanatory.

Awesome!
You've completed Lesson 9
START NEXT LESSON