¹ | Ñëàéä | Òåêñò |
1 |
 |
Welcome to Technology Training @ The Public Library of Charlotte&Mecklenburg County 1 |
2 |
 |
Managing Your Multimedia Collection using Microsoft Access 2003Instructor: Mary Wright 2 |
3 |
 |
By the end of this workshop, you should be able to:Operate a Database Navigate the menu systems. Use the help feature. Minimize and maximize the database window. Minimize and maximize the database application. Access a Database Open and exit database software. Open and close a database 3. Create a Database Design and create a new database. Create an auto-form for data entry. Enter data using a form. Create and print a report.. Manage a Database Search a database. Scroll through a database. Sort database records. Edit existing data. 3 |
4 |
 |
What is a Database |
5 |
 |
5 |
6 |
 |
What are the names of four popular database applications6 |
7 |
 |
Microsoft Access7 |
8 |
 |
8 |
9 |
 |
IBM DB29 |
10 |
 |
FileMaker Pro10 |
11 |
 |
11 |
12 |
 |
12 |
13 |
 |
13 |
14 |
 |
14 |
15 |
 |
15 |
16 |
 |
OPENMicrosoft Access 2003 |
17 |
 |
Step 1: Click STARTStep 2: Click MICROSOFT OFFICE. Step 3: Click MICROSOFT OFFICE ACCESS 2003. 17 |
18 |
 |
CREATE A NEW DATABASE |
19 |
 |
Step 4: CLICK CREATE A NEW FILE…19 |
20 |
 |
Step 5: CLICK BLANK DATABASE20 |
21 |
 |
SAVE A NEW DATABASEStep 6: INSERT A 3 ? “ FLOPPY DISK INTO THE FLOPPY DRIVE A. |
22 |
 |
Step 6: CLICK THE DOWN ARROW TO THE RIGHT OF THE SAVE IN…BOXStep 7: CLICK 3 ? Floppy (A:) 22 |
23 |
 |
Step 8: CLICK THE DOWN ARROW TO THE RIGHT OF THE FILE NAME…BOXStep 9: PRESS THE BACKSPACE KEY TO CLEAR “db1.mdb”. 23 |
24 |
 |
Step 10: TYPE A NAME FOR YOUR NEW DATABASE IN THE FILE NAME…BOXStep 11: CLICK CREATE. 24 |
25 |
 |
CREATE A NEW TABLEVideo Collection |
26 |
 |
Step 12: CLICK “Tables”CLICK “Create table by using wizard.” CLICK Open. 26 |
27 |
 |
Step 13: CLICK PERSONALStep 14: SCROLL DOWN under “SAMPLES TABLES:” and CLICK “VIDEO COLLECTION”. 27 |
28 |
 |
STEP 15: Under “SAMPLE FIELDS: “CLICK on the field you would like toinclude in your new table. CLICK the single right-facing arrow (>) to send the field to the “Fields in my new table” box. 28 |
29 |
 |
Step 16: Now we will rename fields so that you will be able to enterthe actual names of various artists. CLICK ActressID in the “Fields in my new table:” box. Click the “Rename Field…” button. Type the word ActressName (NO SPACE) in the “Rename field:” text box. CLICK OK. Repeat this renaming procedure for: ActorID, DirectorID, and When finished, CLICK NEXT. 29 |
30 |
 |
30 |
31 |
 |
Step 17: Type a name for your table in the text box provided under :“What do you want to name your table?” Step 18: CLICK “No, I’ll set the primary key.” CLICK NEXT. 31 |
32 |
 |
Step 19: CLICK VideoCollectionID under the heading: What field willhold data that is unique for each record? Step 20: CLICK “Numbers and/or letters I enter when I add new records.” CLICK NEXT. 32 |
33 |
 |
Step 21: CLICK “Modify the table design” CLICK the FINISH button. 33 |
34 |
 |
Step 22: CLICK VideoCollectionID in the Field Name columnPress the TAB key. CLICK the down arrow in the Data Type column. CLICK Text. Repeat this procedure for: ActressName ActorName, DirectorName, and ProducerName Step 23: CLICK SampleVideoClip in the Field Name column. Delete the word “Sample”. Press the TAB key. CLICK the down arrow in the Data Type column. CLICK Hyperlink. Step 24: To Save the changes: CLICK FILE. CLICK CLOSE. CLICK YES. 34 |
35 |
 |
CREATE A NEW TABLEMusic Collection |
36 |
 |
Step 25: CLICK “Tables”CLICK “Create table by using wizard.” CLICK Open. 36 |
37 |
 |
Step 26: CLICK PERSONALStep 27: SCROLL DOWN under “SAMPLES TABLES:” and CLICK “Recordings”. 37 |
38 |
 |
STEP 28: Under “SAMPLE FIELDS: “CLICK on the field you would like toinclude in your new table. CLICK the single right-facing arrow (>) to send the field to the “Fields in my new table” box. 38 |
39 |
 |
Step 29: Now we will rename fields so that you will be able to enterthe actual names of various artists. CLICK RecordingArtistID in the “Fields in my new table:” box. Click the “Rename Field…” button. Type the word RecordingArtistName (NO SPACE) in the “Rename field:” text box. CLICK OK. Repeat this renaming procedure for: MusicCategoryID, and When finished, CLICK NEXT. 39 |
40 |
 |
40 |
41 |
 |
Step 30: Type a name for your table in the text box provided under :“What do you want to name your table?” Step 31: CLICK “No, I’ll set the primary key.” CLICK NEXT. 41 |
42 |
 |
Step 32: CLICK RecordingID under the heading: What field will holddata that is unique for each record? Step 33: CLICK “Numbers and/or letters I enter when I add new records.” CLICK NEXT. 42 |
43 |
 |
Step 34: CLICK “NEXT”Do not relate your table to any other table. 43 |
44 |
 |
Step 35: CLICK “Modify the table design” CLICK the FINISH button. 44 |
45 |
 |
Step 36: CLICK RecordingArtistName in the Field Name columnPress the TAB key. CLICK the down arrow in the Data Type column. CLICK Text. Repeat this procedure for: MusicCategoryName Step 37: To save the changes: CLICK FILE. CLICK CLOSE. CLICK YES. 45 |
46 |
 |
CREATE A FORM TO ENTER DATA INTO THE DATABASE |
47 |
 |
Step 38: CLICK FORMSCLICK “Create form by using wizard” CLICK Open. 47 |
48 |
 |
Step 39: CLICK the down arrow to the right of the Tables/Queries boxCLICK the desired table. CLICK the double right-facing arrow (>>) to send all the fields in your table to the “Selected Fields” box. CLICK NEXT. 48 |
49 |
 |
Step 40: CLICK JUSTIFIEDCLICK NEXT. 49 |
50 |
 |
Step 41: CLICK on the style of your choiceCLICK NEXT. 50 |
51 |
 |
Step 42: Type a name for your form in the text box provided under :“What title do you want for your form?” CLICK FINISH. 51 |
52 |
 |
52 |
53 |
 |
ENTER DATA |
54 |
 |
Step 43 : CLICK in each field to enter data, or press the TAB key totravel from field to field, and from record to record. Step 44 : To save the changes: CLICK File. CLICK Close. CLICK Yes. 54 |
55 |
 |
55 |
56 |
 |
SORT RECORDS |
57 |
 |
Step 45 : CLICK the Sort Ascending button to sort the records from Ato Z. 57 |
58 |
 |
Step 46 : CLICK the Sort Descending button to sort the records from Ato Z. 58 |
59 |
 |
ADD A RECORD |
60 |
 |
Step 47 : CLICK the New Record button to add a new record60 |
61 |
 |
DELETE A RECORD |
62 |
 |
Step 48: CLICK the Delete Record button to delete a record62 |
63 |
 |
Step 49: Verify that you want to delete the record by clicking YesIf you do not want to delete the record, click No. 63 |
64 |
 |
SEARCH FOR A RECORD |
65 |
 |
Step 50: To search for a record: CLICK the Find buttonType the name of the record in the Find What text box. CLICK in the Look In box to choose a table. CLICK in the Match box and choose Whole Field, Any Part of Field, or Start of Field. CLICK All, Up, or Down in the Search box. CLICK the Find Next button. CLICK the Close Button ?. 65 |
66 |
 |
FILTER RECORDS |
67 |
 |
Step 51: CLICK the Filter by Form button67 |
68 |
 |
Step 53: CLICK in the field you want to filter byCLICK the down arrow that appears. CLICK the field type. 68 |
69 |
 |
Step 52: CLICK the Apply Filter button69 |
70 |
 |
70 |
71 |
 |
Step 53 : CLICK the Remove Filter button71 |
72 |
 |
72 |
73 |
 |
CREATE A REPORT |
74 |
 |
Step 53: CLICK ReportsCLICK “Create report by using wizard.” CLICK New. 74 |
75 |
 |
Step 54: CLICK Report WizardCLICK the desired table on which you want your report based. Click OK. 75 |
76 |
 |
Step 55: CLICK the down arrow to the right of the Tables/Queries boxCLICK the desired table. CLICK the double right-facing arrow (>>) to send all the fields in your table to the “Selected Fields” box. CLICK NEXT. 76 |
77 |
 |
Step 56: CLICK NEXT77 |
78 |
 |
Step 55: CLICK the down arrow under the heading: You can sort recordsby up to four fields, in either ascending or descending order. CLICK the field or you want to sort. CLICK Next. 78 |
79 |
 |
Step 56: CLICK JustifiedCLICK Portrait. CLICK Next. 79 |
80 |
 |
Step 57: CLICK on the report style of your choiceCLICK Next. 80 |
81 |
 |
Step 58: Type a name for your report in the text box provided under:“What title do you want for your report?” CLICK “Preview the report.” CLICK Finish. 81 |
82 |
 |
Step 59: CLICK the right-facing arrow at the bottom of the reportwindow to go to the next page of the report. To Print the report: CLICK File. CLICK Print. Click OK. CLICK File. CLICK Close to close the report window and return to the database window. 82 |
83 |
 |
Step 60: To close the database you have created: CLICK FileCLICK Close. To close Microsoft Access: CLICK File. CLICK Exit. 83 |
84 |
 |
84 |
85 |
 |
Would you like to practice your database skillsTry the following websites to continue your education… Microsoft Access 2003 Courses Self-paced training courses for Microsoft software are available from Microsoft. They can be accessed at: http://office.microsoft.com/en-us/training/default.aspx 85 |
86 |
 |
Free Learning OpportunitiesGoodwill Industries- GCF Global Learning www.GCFLearnFree.org This website is administered by Goodwill Industries and is supported by the Goodwill Community Foundation. GCF GLOBAL LEARNING® is a free computer and life-skill training program that offers online learning opportunities in English and Spanish. 86 |
«Êàê âñòàâèòü âèäåîôàéë â 2003» |
http://900igr.net/prezentacija/anglijskij-jazyk/kak-vstavit-videofajl-v-2003-265207.html