[ Pobierz całość w formacie PDF ]
.61Hiding and Un-hiding ColumnsTo hide aYou can hide columns so that only those of interest are visible for acolumnparticular view of the Datasheet." Select the column that you wish to hide." Click on the Format drop down menu and then select the HideSAMPLE ONLYColumns command.The column will then be hidden from view, but thedata contained within the column will not be affected!To un-hide a" Click on the Format drop down menu and then select the UnhidecolumnColumns command and a dialog box will be displayed, as illustrated.NOT TO BEUSED FOR" In the example illustrated, the Description column has been hidden.TRAININGTo un-hide it, select the Description field check box and then click onthe Close button.SAMPLE 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/ 82 Formatting a Table© 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationFreezing Columns" Freezing Columns Allows you to keep selected columns visible on-screen whilstyou view columns off the screen" To Freeze Columns Select Columns Click the right mouse buttonorSelect the Format menu Click Freeze Columns" To Unfreeze Columns Select the Format menu Click Unfreeze All Columns© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.62Freezing ColumnsBackgroundTables frequently have a larger width than the screen.When this is thecase you will lose sight of the left most fields as you move to the right of thetable.Freezing columns causes the columns chosen to remain on screenas you scroll through the other columns of the table.SAMPLE ONLYTo freeze a" Select the column or columns.column or" Choose Freeze Columns from the Format menucolumnsORclick on the right-hand mouse button in a column and chooseFreeze Columns.NOT TO BETo unfreeze all" Choose Unfreeze All Columns from the Format menu.the columnsUSED 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/ Formatting a Table 83Using Access 2000 Foundation © 1995-2000 Cheltenham Computer TrainingFormatting Datasheet Cells" Cell Effects include: Horizontal and verticalgridlines Gridline and backgroundcolors Cell effects - Flat, Raisedand Sunken© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.63Formatting Datasheet CellsTo apply Cell" From the Format menu select Datasheet.This will display theEffectDatasheet Formatting dialog box.formattingTo display or" In the Gridlines Shown section of the dialog box, select the requiredSAMPLE ONLYhide gridlinesoptions.To change the" In the Gridline Color section of the dialog box, click on the down arrowcolor of theand select the color required.table gridlinesNOT TO BETo choose Flat," In the Cell Effect section of the dialog box, select the required option,raised orFlat, Raised or Sunken.sunken celleffectsUSED FORTo change the" In the Background Color section of the dialog box, click on the downbackgroundarrow and select the color required.color ofselected cellsTRAININGSAMPLE 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/ 84 Formatting a Table© 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationChanging Datasheet Fonts" Select Font fromthe Format dropdown menu© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.64Changing Datasheet FontsTo change the" Choose Font from the Format menu to display the following dialog box.font for a" Select the desired options from each section of the dialog box.Datasheet" Click on the OK Button.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/ Formatting a Table 85Using Access 2000 Foundation © 1995-2000 Cheltenham Computer TrainingCopying and MovingFields and Records" To copy or move fields and records Select the field or record Copy or move it to the Clipboard Paste from the ClipboardCut - move (Ctrl+X)Copy (Ctrl+C)Paste (Ctrl+V)© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.65Copying and Moving Fields and RecordsSelect, thenBackground Copying and moving data uses the familiar technique ofManipulate!You select the data you want to move or copy, you cut orcopy it to the Clipboard and you paste it in its new destination.As with allAccess functions, you can use the keyboard or the mouse.The options areas follows:SAMPLE ONLYEdit Menu Toolbar Icon Editing Keys ActionCut Ctrl+X Moves the selected data andputs it on the Clipboard.NOT TO BECopy Ctrl+C Copies the selected data tothe Clipboard.USED FORPaste Ctrl+V Pastes the selected data fromthe Clipboard into the newlyselected area or at thelocation of the insertion point.TRAININGSAMPLE 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/ 86 Formatting a Table© 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationWhen you copy or move records to a Datasheet, Access pastes the datainto the receiving fields in the order in which the columns appear in theDatasheet.It takes no notice of field names (column headings).When youcopy or move to a form, then Access pastes the data into the fieldsaccording to the field names.It takes no notice of the order of the fields onthe form.To copy data" Select the data you want to move or copy.from a field" Choose Copy from the Edit menuinto theClipboardORclick the Copy icon on the toolbarORpress Ctrl+C.To cut data" Select the data you want to move.from a field" Choose Cut from the Edit menuinto theClipboardORclick the Cut icon on the toolbarORpress Ctrl+X.To insert the" Click in the destination field where you want to insert the data.contents of the" Choose Paste from the Edit menuClipboard intoanother fieldORclick the Paste icon on the toolbarORpress Ctrl+V.To copy the" Select the fields or columns to copy.contents of" Choose Copy from the Edit menumultiple fieldsSAMPLE ONLYor columns toORclick the Copy icon on the toolbarthe ClipboardORpress Ctrl+C
[ Pobierz całość w formacie PDF ]