[ Pobierz całość w formacie PDF ]
.Create a table without a Wizard?5.Add a Field Name?NOT TO BE6.Set the data type?7.Add a field description?8.Save a new table?USED FOR9.Run the Input Mask Wizard?10.Edit the Input Mask?TRAINING11.Set a Primary Key?12.Add records to a Table Datasheet?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/ Formatting a Table 69Using Access 2000 Foundation © 1995-2000 Cheltenham Computer TrainingFormatting a TableLearning Module ObjectivesWhen you have completed" Seen how to Edit Recordsthis learning module you will" Seen how to Select Recordshave:" Seen how to select a record using the record selector" Seen how to select a group of adjacent records" Seen how to select all records in a Datasheet" Seen how to select a column" Seen how to select adjacent columns" Seen how to delete a record" Seen how to delete the contents of a field" Seen how to replace the entire contents of a field" Seen how to view or set Datasheet options" Seen how to re-order columns within a table" Seen how to hide and un-hide columns" Seen how to freeze columns" Seen how to format Datasheet cells" Seen how to copy and move fields and records" Seen how to preview a form or DatasheetSAMPLE 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/ 70 Formatting a Table© 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationEditing Records" Many editing operations involve selection" There are many ways to select fields and records" Record selectors indicate the current status ofthe recordCurrent recordRecord is selectedRecord is being editedLast (empty) record© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.50Editing RecordsBackground Whether you edit your records through a Datasheet or a form, there is, asusual, a variety of ways to do it.As far as your user is concerned, youshould make it as straightforward and uncomplicated as possible: for theuser, there should only be one right way.SAMPLE ONLYMany editing operations first involve selection.To replace a field, you firstselect it and then type in the new value.The gray area to the left of each record in the Datasheet is called the recordselector.The following symbols indicate the status of the record:NOT TO BECurrent record.USED FORRecord is selected.Record is being edited.TRAININGLast (empty) record.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/ Formatting a Table 71Using Access 2000 Foundation © 1995-2000 Cheltenham Computer TrainingSelecting Records With The MouseGroup of RecordsAll RecordsClick and dragClick hereacrossrecord selectorsSingle RecordClick in therecord selector© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.51Selecting Records With The MouseTo select a" Click in the record selector.record usingthe recordselectorTo select aSAMPLE ONLY" Click on a record selector and drag over the rest of the groupgroup ofadjacentORclick on a record selector and while holding down the SHIFT key,recordsclick on the last record in the range.NOT TO BETo select all" Click the record selector that forms the intersection of the column andrecords in arow selectors.DatasheetUSED 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/ 72 Formatting a Table© 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationSelecting RecordsUsing The Keyboard" Single Record Select the record required Select the Edit menu (Alt+E) Choose Select Record (L)" All Records Select the Edit menu (Alt+E) Choose Select All Records (A)or Press Ctrl+A© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.52Selecting Records Using The KeyboardTo select all" Press Ctrl+A.recordsSAMPLE 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 73Using Access 2000 Foundation © 1995-2000 Cheltenham Computer TrainingSelecting Fields With The Mouse" Single Field place the mouse at the beginning ofthe field (cross pointer) andclick once" Group of Fields Select 1st field Hold [Shift] + select last fieldor Select and Drag© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.53Selecting Fields With The MouseTo select a" Click at one end of the field and with the mouse button depressed, dragfield byto the other end of the field.draggingTo select a" Place the mouse pointer at the beginning of the field.The pointer willfield bySAMPLE ONLYchange into the shape of a cross.pointing" Click the mouse button.To select" Select a field.adjacent" Hold down the Shift key and press the arrow key to select fields in theNOT TO BEfieldsdirection of the arrow.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/ 74 Formatting a Table© 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationSelecting Columns With The Mouse" To select a Field Column Click the button above the column" To select Adjacent Columns Click the button above the columnand drag across the columns required© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.54Selecting Columns Using the MouseTo select a" Move the mouse pointer over the column selector.It will change to acolumn usingblack, downward pointing arrow.the mouse" Click the mouse button.To select" Click on a column selector and drag the mouse over the other columnSAMPLE ONLYadjacentselectorscolumnsusing theORclick on a column selector and whilst holding down the SHIFT key,mouseclick on the last column selector in the range.NOT 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 [ Pobierz caÅ‚ość w formacie PDF ]
zanotowane.pl doc.pisz.pl pdf.pisz.pl odbijak.htw.pl
.Create a table without a Wizard?5.Add a Field Name?NOT TO BE6.Set the data type?7.Add a field description?8.Save a new table?USED FOR9.Run the Input Mask Wizard?10.Edit the Input Mask?TRAINING11.Set a Primary Key?12.Add records to a Table Datasheet?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/ Formatting a Table 69Using Access 2000 Foundation © 1995-2000 Cheltenham Computer TrainingFormatting a TableLearning Module ObjectivesWhen you have completed" Seen how to Edit Recordsthis learning module you will" Seen how to Select Recordshave:" Seen how to select a record using the record selector" Seen how to select a group of adjacent records" Seen how to select all records in a Datasheet" Seen how to select a column" Seen how to select adjacent columns" Seen how to delete a record" Seen how to delete the contents of a field" Seen how to replace the entire contents of a field" Seen how to view or set Datasheet options" Seen how to re-order columns within a table" Seen how to hide and un-hide columns" Seen how to freeze columns" Seen how to format Datasheet cells" Seen how to copy and move fields and records" Seen how to preview a form or DatasheetSAMPLE 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/ 70 Formatting a Table© 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationEditing Records" Many editing operations involve selection" There are many ways to select fields and records" Record selectors indicate the current status ofthe recordCurrent recordRecord is selectedRecord is being editedLast (empty) record© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.50Editing RecordsBackground Whether you edit your records through a Datasheet or a form, there is, asusual, a variety of ways to do it.As far as your user is concerned, youshould make it as straightforward and uncomplicated as possible: for theuser, there should only be one right way.SAMPLE ONLYMany editing operations first involve selection.To replace a field, you firstselect it and then type in the new value.The gray area to the left of each record in the Datasheet is called the recordselector.The following symbols indicate the status of the record:NOT TO BECurrent record.USED FORRecord is selected.Record is being edited.TRAININGLast (empty) record.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/ Formatting a Table 71Using Access 2000 Foundation © 1995-2000 Cheltenham Computer TrainingSelecting Records With The MouseGroup of RecordsAll RecordsClick and dragClick hereacrossrecord selectorsSingle RecordClick in therecord selector© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.51Selecting Records With The MouseTo select a" Click in the record selector.record usingthe recordselectorTo select aSAMPLE ONLY" Click on a record selector and drag over the rest of the groupgroup ofadjacentORclick on a record selector and while holding down the SHIFT key,recordsclick on the last record in the range.NOT TO BETo select all" Click the record selector that forms the intersection of the column andrecords in arow selectors.DatasheetUSED 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/ 72 Formatting a Table© 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationSelecting RecordsUsing The Keyboard" Single Record Select the record required Select the Edit menu (Alt+E) Choose Select Record (L)" All Records Select the Edit menu (Alt+E) Choose Select All Records (A)or Press Ctrl+A© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.52Selecting Records Using The KeyboardTo select all" Press Ctrl+A.recordsSAMPLE 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 73Using Access 2000 Foundation © 1995-2000 Cheltenham Computer TrainingSelecting Fields With The Mouse" Single Field place the mouse at the beginning ofthe field (cross pointer) andclick once" Group of Fields Select 1st field Hold [Shift] + select last fieldor Select and Drag© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.53Selecting Fields With The MouseTo select a" Click at one end of the field and with the mouse button depressed, dragfield byto the other end of the field.draggingTo select a" Place the mouse pointer at the beginning of the field.The pointer willfield bySAMPLE ONLYchange into the shape of a cross.pointing" Click the mouse button.To select" Select a field.adjacent" Hold down the Shift key and press the arrow key to select fields in theNOT TO BEfieldsdirection of the arrow.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/ 74 Formatting a Table© 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationSelecting Columns With The Mouse" To select a Field Column Click the button above the column" To select Adjacent Columns Click the button above the columnand drag across the columns required© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.54Selecting Columns Using the MouseTo select a" Move the mouse pointer over the column selector.It will change to acolumn usingblack, downward pointing arrow.the mouse" Click the mouse button.To select" Click on a column selector and drag the mouse over the other columnSAMPLE ONLYadjacentselectorscolumnsusing theORclick on a column selector and whilst holding down the SHIFT key,mouseclick on the last column selector in the range.NOT 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 [ Pobierz caÅ‚ość w formacie PDF ]