BUS 150 Study Guide - Midterm Guide: Relational Operator, Sorting, Universal Windows Platform Apps

70 views17 pages

Document Summary

3 primary techniques sorting (sequencing) putting things in numeric, alphabetical, or chronological order filter based on criteria calculate-use functions and formulas to do calculations. Table-organized preplanned area in which we store data data is stored on a single entity type made up of records. Each field is an attribute or characteristic of the entity. Each field can be considered unique or non-unique. When a field is unique, every record must have a different entry in the field. When a field is not unique duplicates are permitted. Things to keep in mind when making a table. You need to enter the date in its smallest useful unit. You need to enter data in a way that requires the least amount of maintenance. Numbers that won"t be used in calculations need to be entered as text. Select the area, go to number format, and format as text. Go in the first row of the table.