EBook Microsoft Access 2000 Training Manual

[ Pobierz całość w formacie PDF ]
." Remember that we havebeen working in DesignView.Now we can switch toDatasheet View." To do this click on the Viewdrop down menu, and selectDatasheet View." The screen will be as illustrated below.SAMPLE ONLYNOT TO BEUSED FORTRAINING" You should find that the values in the third column do in fact represent5% of the second column.We could also have formatted this columnso that it displayed the currency symbol, and also we could haveheaded the column with a more inspiring name!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/148 Creating Calculated Fields� 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationReview Questions� Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.106Review Questions - How Would You.1.Open the Expression Builder?2.Create calculated fields, using the Expression Builder?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/Introducing Forms 149Using Access 2000 Foundation � 1995-2000 Cheltenham Computer TrainingIntroducing FormsLearning Module ObjectivesWhen you have completed" Understood the concepts behind the use of Basicthis learning module you willForm Layout Typeshave:" Seen how to create a form using AutoForm" Seen how to create a form using Forms Wizard" Seen how to use Design View, Form View and PrintPreviewSAMPLE 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/150 Introducing Forms� 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationIntroduction to Forms Forms provide a friendlier view of the database Forms can be used to display, view and print data Forms can be used to add, update and delete records Forms can include pictures, drawings, different fonts and colors� Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.108Introduction to FormsBackground Tables provide a convenient way of storing data, and queries provide auseful way of retrieving data to satisfy particular needs.The Datasheetviews of tables and queries provide an ordered means of viewing,displaying and entering data.Forms provide the user with a muchfriendlier, better controlled and more attractive view of the database.SAMPLE ONLYWhen designing a form, you can use a variety of techniques such asadditional text, font sizes and styles, color, scanned images, clip art,graphs, and command buttons which can be used to open new forms, runqueries and set other operations going.NOT TO BEForms are used for a variety of purposes: they are used to display andview data; they are used for getting data into the database (data entry) andas a means of editing or removing existing data; they can be used to printdata or information; and they can provide an easy-to-use menu system forUSED FORthe end-user.All forms are based on one or more underlying tables.The structure of thetables is unaffected by the form design but the contents may be altered byactions within the forms.TRAININGForms Wizards make basic and initial form design easy.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/Introducing Forms 151Using Access 2000 Foundation � 1995-2000 Cheltenham Computer TrainingBasic Form Layout Types� Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.109Basic Form Layout TypesBackground There are numerous variations on a theme when it comes to designingforms.The Form Wizard will offer you 4 basic layouts.These can becustomized as you see fit to make the form more appropriate for it'sparticular function.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/ColumnarTabularJustifiedDatasheet152 Introducing Forms� 1995-2000 Cheltenham Computer Training Using Access 2000 FoundationCreating a Form Using AutoForm� Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.110Creating a Form Using AutoFormTo create a form" In the Databaseusing AutoFormWindow click on theWizardTable or Queryicon." Click on a Table orSAMPLE ONLYQuery to select it." Click the AutoFormbutton on theStandard toolbar.NOT TO BE" You can now use this form to enter the information into the table orquery.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/Introducing Forms 153Using Access 2000 Foundation � 1995-2000 Cheltenham Computer TrainingCreating a Form Using the Form Wizard� Cheltenham Computer Training 1995-2000 Access 2000 Foundation/Intermediate - Slide No.111Creating a Form Using the Form WizardBackground If possible, use the Form Wizard to create your forms.It is easy to useand effective.You can modify the design later if you wish.To create a form" In the Database Window click on the Forms icon.using Form" Choose the New button, which will display the New Form dialog box.SAMPLE ONLYWizardNOT TO BEUSED FOR" Select the Form Wizard.TRAINING" Choose the table or query where the objects data will come from.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/154 Introducing Forms� 1995-2000 Cheltenham Computer Training Using Access 2000 Foundation" Click on the OK button to display the next page of the Form Wizard." Click on the field that you wish to add to the form, and then click on theright printing arrow button to add it to the Selected Fields section ofthe dialog box." Repeat this procedure so that all the required fields are added.Remember that you can use the down arrow in the Tables/Queriessection of the dialog box to select a different data source which willcontain other fields." When you have added the required fields click on the Next 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 [ Pobierz całość w formacie PDF ]

Archiwum