1 / 27

Lesson 04 : Editing Database Getting External Data

Lesson 04 : Editing Database Getting External Data. At the end of this lesson, students should be able to: . Modify Table : Add Field Modify Form Import Data from other file type. Modify table: Add field Method 1: Add field after the last field.

arnold
Download Presentation

Lesson 04 : Editing Database Getting External Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Lesson 04 :Editing DatabaseGetting External Data

  2. At the end of this lesson, students should be able to: • Modify Table : Add Field • Modify Form • Import Data from other file type

  3. Modify table: Add field Method 1: Add field after the last field. Click Design button at database toolbar windows Students Profile: Database, to display all the fields. Click icon design view Figure 1

  4. 2. Click field below icno (refer Figure 2) 3. Type in email inside the Field Name and select text as the Data Type. Figure 2 4. Save the record.

  5. Method 2: Add new field in between the two fields Click Design button at database toolbar windows Students Profile: Database, to display all the fields. 2. Click the address field (the row will be highlight - refer Figure 3) Step 1: Click icon design view Step 2: Highlight row Figure 3

  6. 3. Click Insert at menu bar, then click rows. A new row will be added. (refer Figure 4 ) 4. Put cursor in between field name and field address. Step 1: Click Insert then click Rows Step 2: Put cursor here Figure 4

  7. 5. Type in sex inside the blank Field Name and select text as the data Type. (refer Figure 5) 6. Save students profile. 7. Click to close students profile : Table. Step 1: Type sex here Step 2: Save table Step 3: Click here Figure 5

  8. Modify form 1. Open Microsoft Access 2003   2. Click Open an Existing Database, then click file students profile and click OK.  3. In the database window, click Form and double click Create Form by using wizard. Step 2 Double Click Create Form by using wizard Step 1 Click Form Figure 6

  9. 4. Click double arrow to select Available Fields Click here Figure 7

  10. The selected Fields will be remove from left to right. • Then click Next Click Next Figure 8

  11. 6. Click Next Click Next Figure 9

  12. 7. Select Standard for style. Then click Next Step 1: Select Standard Step 2: Click Next Figure 10

  13. 8. Click Finish Finish Figure 11

  14. 9. The form will display as below Figure 12

  15. Importing Data • 1. Open Microsoft Access 2003 • 2. Create new database file • 3. Click file • 4. Click Get External Data • 5. Click Import

  16. Step 1: Click File Step 2: Click Get External Data Step 3: Click Import Figure 12

  17. 6. At the Files of type, click pull down and select Microsoft Excel 7. Click any spreadsheet files as shown in example below ( Test 2007 ) 8. Click Import Step 1: Click File “Test 2007” Step 2: Click Import Figure 13

  18. 9.Click Next 1.Next Click Next Figure 14

  19. 10. Put a tick on the box at the First Row Contain Column Headings 11.Click Next Step 1: Tick On Step 2: Click Next Figure 15

  20. 12. Click OK Click Here Figure 16

  21. 13.Click In a New Table 14.Click Next Step 1: Click In a New Table Step 2: Click Next Figure 17

  22. 15.Click Next Click Next Figure 18

  23. 16. Tick at the Choose my own primary key and select No 17. Click Next Step 1: Click Choose my own primary key Step 2: Select No Step 3: Click Next Figure 19

  24. 18.Click Finish Click Finish Figure 20

  25. 19.Now you had finished creating one table named “ Register “  20.Double click at Register Click Register Figure 21

  26. 21. The next window will be appear 22. Click File and Close  Step 1: Click File Step 1: Click Close Figure 22

  27. 24.Click button to end this session  Click Here Figure 23

More Related