Module 5 Databases
Change arrangement of objects within form layout.
Similar in OpenOffice and Microsoft Access - as below
To move controls or labels · Move the mouse pointer over the edge of the control until it changes to an open hand.· Click the mouse button and keep it depressed while you move the control to its new position and release the mouse button.
To move a text box or label independently · Move the mouse pointer over the move handle at the top left of the label or text box. It will change to a pointing hand.· Click the mouse button and drag the text box or label to its new position
.Note: If, when you first click in a control, you keep the mouse button held down, it will appear as an open hand and you can move the control straight away.
To resize a control - Move the pointer over one of the sizing handles. It will change to a double-ended arrow indicating the directions in which you can drag the handle. Click the left-hand mouse button and while you keep it depressed, drag the sizing handle to increase or decrease the size.
To align controls to each other - Select the controls you want aligned. Choose Align from the Format menu and then select the desired option from the sub-menu.
To change the spacing between controls - Select the controls you want
spaced. Choose Horizontal Spacing or Vertical Spacing from the Format
menu. Choose Increase, Decrease or Make Equal from the sub-menu.
To make controls snap to grid · Select Format from the menu bar.· Choose the menu item Snap to Grid. If you want your controls to snap to grid, this item should be ticked.
To delete a control · Click somewhere in the control.· Press the DEL key.Note: If you select the label and press delete, just the label will be deleted. However, if you select the text box and press delete, both text box and label will be deleted.
To duplicate a control and its label - Select the control.· Choose Duplicate from the Edit menu. A copy of the control will appear immediately below the original.Note: If you reposition the duplicated control and then select Duplicate again, Access will create a third control and position it so that all three are evenly spaced.
To move or copy controls using the Edit menu · Select the control.· Choose Cut or Copy from the Edit menu to place the control on the clipboard.· Choose Paste from the Edit menu. Access will put the control in the top left-hand corner of the detail section.· Move the control to its new location.Note: As you need the mouse to move the control once you have pasted it, it seems more sensible to use the mouse in the first place.