Process numerical and text data in a business environment – Unit Standard 14346

Lessons

Process numerical and text data in a business environment

Author: acoustic

Databases are designed to offer an organised mechanism for storing, managing and retrieving information. They do so through the use of tables. If you’re familiar with spreadsheets like Microsoft Excel, you’re probably already accustomed to storing data in tabular form. It’s not much of a stretch from spreadsheets to databases.

Original data

Author: acoustic

Exactly how to query and analyse the data will depend what you need to know. As the examples show, the queries can take data from many tables, you do not need to display all the fields, and you can search for different groups of records.