new perspectives microsoft access 2013 tutorial 5 help

The data in a list can be summarized by adding.

The formatting to take place and what the

You specify the condition under which you want.

This kind of formatting is called conditional.

Or, you might want a value to be black if it is.

Red, if the data is more than six months old

For example, you might want data to appear in.

There are times when you will want data to have aĭifferent appearance if it meets some criteria.

More complex filters must be created using the.

Simple filters can be specified by clicking the.

Therefore, can be redisplayed by removing the

These records are not removed from the list and,.

When data in the list is filtered, records that.

That meet some criteria is called Filtering.

The processing of displaying only those records.Sometimes you will want to see a portion of the.Search for records, to modify records, and to You can use the data form to display records, to.A data form is a dialog box that you can use toĪrrange data to view one record at a time.Sometimes it is easier to view the data in a list.Use a data form to enter, search for, edit, and You may choose to sort the data on a single field.The field(s) selected on which to sort are called.Or descending order based on any field(s) in the Excel makes it easy to sort a list in ascending.Occurrence of ACCT and replace it with Accounting For example, you might want to find every.This procedure is called Find and Replace.Optionally, you can choose to replace the.The Find command allows you to search through theĭata in a worksheet for a particular character.Lines to indicate the rows and columns that are Excel will display dark vertical and horizontal.Selected cell, and the columns to the left of the Click Window on the menu bar, and then clickįreeze Panes to freeze the rows above the.The list so that it remains while the rest of the The screen at all times, such as the columnĪnd/or row headings, you can freeze a portion of If you prefer to have portions of data remain on.When you scroll through large amounts of data inĪ worksheet, you can move data off the screen.Name of the fields and is called a field header The first row of the list always contains the.In a worksheet, each column represents a field ofĭata and each row represents a record of data.An Excel list is a collection of rows and columns.Lists, telephone lists, inventory lists, and so

Maintain lists of information such as customer Excel provides features that allow you to.Title: New Perspectives on Microsoft Office Excel 2003, Second Edition- Tutorial 5

New perspectives microsoft access 2013 tutorial 5 help