[ Pobierz całość w formacie PDF ]
.As you move the pointer, it draws a rectangle around thecontrolsselected group.To select non-" Hold down the SHIFT key as you select each of the controls.adjacentcontrolsTo align" Select the controls you want aligned.controls to each" Choose Align from the Format menu and then select the desiredotheroption from the sub-menu.To change the" Select the controls you want spaced.spacing" Choose Horizontal Spacing or Vertical Spacing from the Formatbetweenmenu.controls" Choose Increase, Decrease or Make Equal from the sub-menu.To save a form" Choose Save from the File menu." Type in a name for the form." Press Enter or click on OK.To change theAfter adding and moving controls you might want to change the size of asize of a sectionsection." Move the mouse pointer over the bottom edge of the section.Thepointer will change to a double-headed vertical arrow across a solidhorizontal bar." Drag the edge of the section until it is the required size.To change the" Move the mouse pointer over the right edge of any section on thewidth of theform.It will change to a double-headed horizontal arrow across a solidSAMPLE ONLYformvertical bar." Drag the edge of the section until it is the required size.To change the" Move the pointer over the right-hand corner of the section.It willwidth of thechange to two intersecting double-headed arrows.NOT TO BEform and size of" Drag the corner of the section and form until it is the required size.a sectionsimultaneouslyUSED FORTRAININGSAMPLE ONLY NOT TO BE USED FOR TRAINING©Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/ 168 More About Creating Forms© 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationTypes of Control" Bound controls are bound tofields in tables or queries" Unbound controls displayinformation not held in thedatabase" Calculated controls are derivedfrom expressions" You can add controls using thetoolbox© Cheltenham Computer Training 1995-1999 Access 2000 Foundation/Intermediate - Slide No.118Types of ControlBackground This section deals with bound, unbound and calculated controls.Let sstart with some definitions.Bound ControlsA control that displays data from a table or query.Bound controls areused to display data and to enter and update data in tables.The mostSAMPLE ONLYfrequently used bound control is a text box.Bound controls inherit fieldproperties from the table.The properties can be altered in the formwithout affecting the original table properties.UnboundA control that does not have a source of data.An unbound control canNOT TO BEControlsdisplay information such as text, lines, rectangles and pictures.It can alsoaccept input that will not directly go into a table.An unbound control is notderived from a table.CalculatedA control whose data is derived from an expression.USED FORControlsTRAININGSAMPLE ONLY NOT TO BE USED FOR TRAINING©Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/ More About Creating Forms 169Using Access 2000 Foundation © 1995-2000 Cheltenham Computer TrainingThe Toolbox" Using the Toolbox you can addcontrols Open the toolbox by clicking on thetoolbox icon Position and size the toolbox to yourpreferences Double click on the toolbox title bar toattach it to the other menus at the top ofthe screen© Cheltenham Computer Training 1995-1999 Access 2000 Foundation/Intermediate - Slide No.119The ToolboxBackground Using the Toolbox you can add the full range of controls available inAccess.To open the" Open the toolbox by clicking on the Toolbox icon.toolbox" Position and size the toolbox to your preferences.SAMPLE ONLYNOT TO BEUSED FORTRAININGSAMPLE ONLY NOT TO BE USED FOR TRAINING©Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/ 170 More About Creating Forms© 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationTool name Icon DescriptionSelect Objects When selected, the selection or pointer icon allows you to select,move and size controls.Control Wizards Control Wizards allow you to easily create the following types ofControls:" List Box." Combo Box." Option Group." Command Button.Label You use this icon to display text that doesn t change.Mostcontrols created in Access are created with a label alreadyattached.This is useful for creating text anywhere on a form.Text Box A text box is the most commonly used control on a form.It isused to show the content of a field, and allows you to type newdata into it.Option Group This control allows you to provide the user with a group ofoptions from which to choose only one item, they are mutuallyexclusive, i.e.only one can be selected.Toggle Button This control allows you to either select or not select an option.Both text and pictures can be put on Toggle Buttons.Option Button This control allows you to either select or not select an option, adot is displayed when this option is selected.SAMPLE ONLYCheck Box This control allows you to either select or not select an option, acheck mark is displayed when this option is selected.Checkboxes are not mutually exclusive.In other words, you can checkmore than one box.A check box is selected when there is aNOT TO BEcross in it.USED FORTRAININGSAMPLE ONLY NOT TO BE USED FOR TRAINING©Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/ More About Creating Forms 171Using Access 2000 Foundation © 1995-2000 Cheltenham Computer TrainingTool name Icon DescriptionCombo Box A Combo Box will display a list of options available to you.Youhave to click on the down arrow key to the right of the box inorder to see the list of options.Alternatively you can type in theText Box as the user types, Access changes the display to thenearest match so far.Provided you have not specified Limit ToList when creating the Combo box, the user can enter a newvalue that will then be entered in the table.List Box Alternative values are displayed in a scrollable box.Only valuesavailable in the list can be selected.Command Command Buttons are used to carry out an action such as PrintButton Record .The action is carried out because the button is linkedto a series of commands called Macros .Image Allows you to insert a picture into your form
[ Pobierz całość w formacie PDF ]