[ Pobierz całość w formacie PDF ]
.To create a" From the File menu choose Newnew databaseTRAININGORpress Ctrl+NORclick on the New icon on the Standard toolbar.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/ 48 Database Design and Table Creation© 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationUsing the Table Wizard© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.38Using the Table WizardTo create a" If you click on the File drop down menu within the Access window andtable usingthen click on the New command, you will see the following dialog box.Table WizardSAMPLE 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/ Database Design and Table Creation 49Using Access 2000 Foundation © 1995-2000 Cheltenham Computer Training" Select the Database icon and click on the OK button, supply a filename when prompted.Once you click on the Create button you willsee the following." Make sure that the Tables icon (down the left hand side of the window)is selected, and then double click on the Create table using wizardcommand.You will see the Table Wizard dialog box displayed.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/ 50 Database Design and Table Creation© 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationAdding FieldsUsing the Table Wizard (1)BUSINESSPERSONALOR© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.39Adding Fields Using the Table Wizard (1)" Click on one of the option buttons in the bottom left of the dialog box tochoose either Business or Personal.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/ Database Design and Table Creation 51Using Access 2000 Foundation © 1995-2000 Cheltenham Computer TrainingAdding Fields Usingthe Table Wizard (2)© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.40Adding Fields Using the Table Wizard (2)To select a" Select a sample table from the Sample Tables list.sample tableTo add Fields" Select a field that you wish to add by clicking on the field name in theSample Fields list.SAMPLE ONLY" Click on the right pointing arrow to add the field to the Fields inmy new table list.In the illustration, the Business databases havebeen selected, and from the list displayed, the Mailing List databasehas been selected.Then the MailingListID field was added.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.com/ 52 Database Design and Table Creation© 1995-2000 Cheltenham Computer Training Using Access 2000 Foundation" When you add a field the selected item within the Sample Fields listswill automatically move down one item.To add more fields select thedesired field from the Sample Fields section and click on the rightpointing arrow.To rename a" Select the field that you wish to rename within the Fields in my newfield within thetable section of the Table Wizard dialog box.Field using the" Click on the Rename Field button, which displays the Rename fieldTable Wizarddialog box." Enter the new name of the field and then click on the OK button." When you have added all the fields that you require, click on the Nextbutton, which will display the next page of the Table Wizard.SAMPLE ONLY" In the What do you want to name your table? text box, enter a nameNOT TO BEfor your table." Normally you will let the wizard set a primary key for you, but if youwish you can set the primary key.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/ Database Design and Table Creation 53Using Access 2000 Foundation © 1995-2000 Cheltenham Computer Training" Click on the Next button to continue to the next Wizard page." Here you can choose how to proceed once the table has been created." Click on the Finish button to close the Table Wizard and create thetable." The Table is displayed.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/ 54 Database Design and Table Creation© 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationCreating a Table Without a WizardOR© Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.41Creating a Table Without a WizardTo create a" In the Database Window, click the Table icon.table without" Click on the New button.Table Wizard" In the New Table dialog box, select Design View and then click on theOK 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/ Database Design and Table Creation 55Using Access 2000 Foundation © 1995-2000 Cheltenham Computer Training" The Table will be displayed in Design format, as illustrated.To add a Field" Enter the name of the required field into the empty cell immediatelyNamebelow the Field Name Header.For instance you could add a field name called First Name.Press the Tab key to move to the next cell.To set the data" The next cell is called Data Type.This allows you to control what typetypeof data is to be entered into the field.Click on the down arrow todisplay a list of available options.SAMPLE ONLYNOT TO BEUSED FORIf for instance you select Number, then only numeric data may beTRAININGadded.If you select Text, then only text may be entered, and so on." Press the Tab key to move to the next cell.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
[ Pobierz całość w formacie PDF ]