Office 2010 - Access

Lesson 44: Organizing Form Fields

44/76 Lessons 

Organize fields (2)

The “City” row is now neatly placed below the address row.
Next I want to move the photo to the “StudentID” field. To do this, I click and drag this next to the field.
The photo may slightly be larger but, when I place it in a cell, then the whole row i.e the “StudentID” row is adjusted.
So first select the cell containing the image, hold the shift key on your keyboard pressed and then click the two underlying cells.
Click the “Merge” button in the “Ribbon”.

les44_image008_en

Now you can change the dimensions of the photo, without changing the underlying cells in other columns. This is done by clicking and dragging the edge or corner of the photo.

les44_image009_en
Does not look bad, but we still have to change the height of the “First Name”, “Last Name” and “Address” fields. Select the field that you want to change the height of, position the mouse pointer over the edge of the field and when it changes into a two-way arrow, click and drag it to the desired height. Repeat for the other fields.

les44_image010_en
Now we slightly modify data in the subtable. I do not need the “ResultID” column (1), so I can hide it. Right-click above the column title and choose “Hide Fields” in the drop-down menu.

les44_image011_en
Finally, I want the scores to be aligned in the middle of this column.
Click above the first column.
Choose the “Format” contextual tab and click the “Center” button in the “Font” group in the “Ribbon”.

les44_image012_en
If you’re looking at the form in “Form View”, it looks a lot better.

les44_image013_en
There are dozens of other options in the contextual tabs allowing you to change the layout of the fields in the form, but it is impossible to mention all of them here. Most of them are pretty apparent.

Awesome!
You've completed Lesson 44
START NEXT LESSON