Go to the FGCU Homepage navigation bar
    
Technology Skills Orientation
Access Titlebar
A-Z FGCU Index FGCU Calendar of Events Campus Tour Library Search FGCU Web FGCU Webmail Contact FGCU
« Table Relationships Managing Data Querying a Database »

Add Records to a Table
To add a new record to a table:

  • Open the table in Datasheet View
  • Click the New Cell
  • Type in your new record

New Field

Find and Replace
To find data:

  • Click the Find button on the Home tab

Find Button

To find and replace data:

  • Click the Replace button on the Home tab

Replace Button

When you are searching for data for a find, replace or go to, you have several options in the Find Dialog Box.  These options are:

Find What Text Box

Type the text you wish to find

Link in Drop Drop-Down List

Use the drop-down list to specify a table or a column to search

Match Drop-Down List

Use the drop-down list to narrow down the search to a field or the beginning of a field

Search Drop-Down List

Use this drop-down to specify the direction to search.

Match Case Check Box

Use this check box to specify whether to search by the same upper and lower case letters.

Find Dialog Box

Totals
The totals button provides you the opportunity to add a totals row to your database.  The total can be the sum, average, a count, minimum, maximum, standard deviation, or the variance.  To set up a totals row:

  • Click the Totals button on the Home tab

Totals Button

  • Click the down arrow of the cell where you want the totals
  • Click the appropriate choice

Totals Drop Down

Sort Records
You can sort records in a datasheet by a single column or by two adjacent columns.  To sort records by a single column:

  • Select the field you wish to sort
  • Click the Sort Ascending or Sort Descending button

Sort Buttons

To sort two columns:

  • Move the columns to they are adjacent to each other
  • Select the desired columns for sorting by holding the shift key and clicking the columns
  • Click the Sort Ascending or Sort Descending button

Sort Adjacent Columsn

To clear the sort:

  • Click the Clear Sort button

Clear Sort Button

Filter
You can filter records to include only records that you want to display.  To filter by a column:

  • Open the database in Datasheet View
  • Click the down arrow in the field label
  • Choose the appropriate filter criteria
  • Click OK

Filter

To remove a filter:

  • Click the filter button on the field label
  • Click Clear Filter
  • Click OK

Clear Filter Option

« Table Relationships Managing Data Querying a Database »


Office 2007 Tutorials · Word · Excel · PowerPoint · Access

FGCU does not provide personal support for Office 2007 programs to outside parties.


© FGCU 2007. This is an official FGCU web page.
Florida Gulf Coast University is an equal opportunity/affirmative action institution.

Contact the Webmaster | FGCU Directory