5 Excel - Computer Application in Management Yosi Wiesel Exploring Microsoft Excel From Data to Information Database Concepts Lists can be used as

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Computer Application in Management Yosi Wiesel Exploring Microsoft Excel From Data to Information Database Concepts ± Lists can be used as simple databases ± Record: individual information contained in a row ² First row contains field names ± Field: unique information contained in a column for a record ² Fields are the same for each record (row) ± Key is used to determine the sequence in which the rows appear
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Computer Application in Management Yosi Wiesel Creating a List There must be a blank row and a blank column between the list and the rest of the worksheet The Data Form Command ± Data form: provides easy way to add, edit, and delete records in a list ± Select the Form command on the Data menu ² Displays a dialog box based on the fields in the list ² You need to enter the field names and one row manually to use the form
Background image of page 2
Computer Application in Management Yosi Wiesel A Data Form Sort Command ± Arranges records in a list according to the value in designated fields ² Can sort on text, numeric, or date fields ² Can sort in ascending or descending order ² Can sort on up to three fields ± When sorting on more than one field, choose most important field as the primary sort key ± If you sort, then add names to the list, you need to re-sort the list
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Computer Application in Management Yosi Wiesel Sorting Primary sort by location, ascending order
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/25/2009 for the course BUSINESS 772 taught by Professor Sadeh during the Spring '07 term at Interdisciplinary Center Herzliya.

Page1 / 13

5 Excel - Computer Application in Management Yosi Wiesel Exploring Microsoft Excel From Data to Information Database Concepts Lists can be used as

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online