tambahan kpd 14 steps to merge parents and students (1)

13
14 STEPS TO MERGE PARENTS AND STUDENTS STEP 1 STEP 2

Upload: aini-manal

Post on 18-May-2017

227 views

Category:

Documents


4 download

TRANSCRIPT

Page 1: Tambahan Kpd 14 Steps to Merge Parents and Students (1)

14 STEPS TO MERGE PARENTS AND STUDENTS

STEP 1

STEP 2

Page 2: Tambahan Kpd 14 Steps to Merge Parents and Students (1)

STEP 3

STEP 4

Page 3: Tambahan Kpd 14 Steps to Merge Parents and Students (1)

STEP 5

STEP 6

Page 4: Tambahan Kpd 14 Steps to Merge Parents and Students (1)

STEP 7

STEP 8

Page 5: Tambahan Kpd 14 Steps to Merge Parents and Students (1)

STEP 9

STEP 10

Page 6: Tambahan Kpd 14 Steps to Merge Parents and Students (1)

STEP 11

STEP 12

Page 7: Tambahan Kpd 14 Steps to Merge Parents and Students (1)

STEP 13

STEP 14

Page 8: Tambahan Kpd 14 Steps to Merge Parents and Students (1)

Ini sedikit tambahan kpd ’14 steps to merge parents and students’. Ini bertujuan kaitkan pelajar dgn yesid sendiri dan yesid bapanya.

1. Create Students excel file seperti dalam Step 1 to Step 3.2. Ikut langkah Step 4 to Step 10 dan create query seperti di bawah. Link Parents:IdNumber kpd

TMurid:NoKPBapa dan link TMurid:NoKP kpd Students:IdNumber untuk kaitkan pelajar, idnya dan bapa serta id bapa. Ikut Step 13 dan 14.

3. Lepas itu copy all dan paste dalam Excel dan sort.

4. Langkah-langkah di atas di ulang utk kaitkan pelajar dgn yesid sendiri dan yesid ibunya. (Link Parents:IdNumber kpd TMurid:NoKPIbu

Page 9: Tambahan Kpd 14 Steps to Merge Parents and Students (1)

Langkah tambahan untuk link yesid ketiga-tiga pelajar, bapa dan ibu. Dan juga langkah untuk delete duplicate info.

1. Link idNumber dr Query2 ke idNumber dr Query3. Ini menghasilkan data yg mengaitkan pelajar dgn kedua-dua ibubapanya.

2. Utk hapuskan duplicate data, prosedur rumit sedikit. Sy lampirkan salinan dr internet.

Instructionso 1 Open your Access database. Go to "Queries" and select "New."

o 2 Select "Find Duplicates Query Wizard" and select "OK" to start the query wizard.

o 3 Select the "Tables" radio button and choose the table you want to view duplicates from. Select "Next." Select the fields you want to search for duplicates. Select "Next."

o 4 Choose any additional fields you wish to view along with the query. These fields are for your convenience only and don't affect your query. Select "Next." Choose a name for your query or use the default name and select "Finish."

o 5 Remove duplicates manually by selecting each row you wish to delete and press the "Del" or "Delete" key on your keyboard. If you will need more

Page 10: Tambahan Kpd 14 Steps to Merge Parents and Students (1)

than two or three minutes to delete duplicates, remove duplicates by creating a new table. Continue to Step 6 for this method.

o 6 Remove duplicates automatically. Close your query by using the red "X" at the top of the query. Go to "Tables." Copy the table (cth dad&mum) with duplicates by highlighting the table and pressing "Ctrl" and "C" on your keyboard. Paste the table by pressing "Ctrl" and "V" on your keyboard. Choose a name for the new table (cth dad&mum – to append) and select "Structure Only." Select "OK."

o 7 Highlight the new table and select "Design View." Select the field (cth IdNumber) you wish to prevent duplicates in. Right-click the gray box to the left and choose "Primary Key." This will prevent any duplicates in that field since a primary key must be unique. You can change the primary key for the table after you've removed all duplicates. Close the table to save changes.

o 8 Go to "Queries" and click "Design View." Select the table (cth dad&mum – to append) you created in Step 6 and choose "Append" as your query type. Query types are found in the toolbar with an icon looking like two small white squares next to the red exclamation point icon. Select the original table (cth dad&mum) to append.

oDrag the asterisk (*) at the top of the field list to the first field at the bottom of the design view window. Press the red exclamation point icon on the toolbar to run the query. Press Yes all the way. Only unique records will be pasted into the new table.

o 9 Rename the original table to "TableName Original Date" or something similar and change the new table to the original table's name. This will give you a backup in the event a duplicate wasn't actually a duplicate.

Read more: How to Remove Duplicates in Access | eHow.com http://www.ehow.com/how_5328612_remove-duplicates-access.html#ixzz29djXZrr8

Page 11: Tambahan Kpd 14 Steps to Merge Parents and Students (1)