Scribd
Upload
6 views1 page

Module 7.2

The document outlines the advantages of data processing, including efficiency and the ability to perform statistical functions. It explains the concepts of exporting and importing data, the importance of avoiding blank records, and the use of delimiters in data files. Additionally, it describes the functions CountIF and SumIF for analyzing data in databases.

Uploaded by

Natalia Makalane
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
6 views1 page

Module 7.2

The document outlines the advantages of data processing, including efficiency and the ability to perform statistical functions. It explains the concepts of exporting and importing data, the importance of avoiding blank records, and the use of delimiters in data files. Additionally, it describes the functions CountIF and SumIF for analyzing data in databases.

Uploaded by

Natalia Makalane
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Module 7.

2
Written module activity, Page 324 (Answers)
1. Advantages include:
• • They allow us to work with large amounts of data and information.
• • We can process data much more quickly (and more accurately).
• • One can easily perform statistical functions and queries on the data.
• • You can present the data and information in the most appropriate format, e.g. a table or
chart.

2. Exporting refers to the process of transferring data from one program (file type) to another, e.g.
from Access to Excel, while importing means bring the data into the file from an external source, e.g.
from Excel into Access.
3. So no blank records or fields are imported into the database.
4. Yes, if the records are going to be added in a new table in the database; but it is not necessary to
have labels if the records are being imported into an existing table. 104
5. A delimiter is a character such as comma, space or tab character used to separate pieces of data
(each field) in a line in a text file.
6. A CSV (Comma Separated Values) file is a file format which uses commas to separate the values in
each line. They are commonly used to import and export data from one program to another.
7. Appending records means adding records to an existing table in the database.
8. CountIF counts the cells in a specified range that meet a specified criterion. SumIF totals the
values in specified range of cells if a specified criterion is met.
9. It counts the number of records in the report which have values entered for that specific field.

You might also like