ada bagian ini, kita akan melihat berbagai macam fungsi untuk melakukan pemeriksaan lebih mendetail terhadap data-data yang akan diambil dari populasi. Fungsi yang ada di sini digunakan untuk melihat data yang terduplikasi, hilang, hingga pengurutan data dari populasi untuk memudahkan teman-teman dalam melakukan pemeriksaan

Examining Sequential Data

Sequence determine whether the data is in order, and lets you search for gaps and duplicates as well.

Gaps and duplicates commands can operate only on files previously sorted on the field.

Perform a sequence test

·Select Analyze|Examine Sequence

Test for gaps

·Select Analyze|Look for Gaps.

Test for duplicates

·Select Analyze|Look for Duplicates

Extracting and Exporting Records – EXTRACT

Extract, you can extract the records displayed in a view to create a new table.

Extract records from the active table

·Select Data|Extract Data. Select Records, choose any additional options, and click OK.

Extract fields from the active table

·Select Data|Extract Data. Select Fields, choose any additional options, and click OK.

Extract specific records to a new table

·You can apply a view filter

Export, you can export the records in the view or all records in a table.

Export, you can export the records in the view or all records in a table.

Export data to another file format

·Select Data|Export to Other Application.

·From the Export As list, choose a data format.

Create a merge file or bulk mailing

·Export information form a customer table to a Ms. Word merge file.

·In the Export dialog box, select name and address fields and choose a merge file format from the Export As list.

Sorting and Indexing Tables

Use the Sort command to sort the active table in ascending or descending order based on specified key fields.

Sort creates a new table that has been physically reorganized.

Use the Index command to create an index file that allows direct access to the records of a table in a logical rather than physical order

Sort records in a table : Select Data|Sort Records.

Create an index for a table : Data|Create Index