Resources » .NET programming » ASP.NET/Web Applications

Foreign key in access 2003


Posted Date: 14-Nov-2009  Last Updated:   Category: ASP.NET/Web Applications    
Author: Member Level: Gold    Points: 4



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

Open the table in Data sheet View
Click the New Cell
Type in your new record



Find and Replace
To find data:

Click the Find button on the Home tab


To find and replace data:

Click the Replace button on the Home tab


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.


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

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


Sort Records
You can sort records in a data sheet 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


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


To clear the sort:

Click the 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 Data sheet View
Click the down arrow in the field label
Choose the appropriate filter criteria
Click OK


To remove a filter:

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


Did you like this resource? Share it with your friends and show your love!

Responses to "Foreign key in access 2003"

No responses found. Be the first to respond...

Feedbacks      

Post Comment:




  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:   Sign In to fill automatically.
    Email: (Will not be published, but required to validate comment)



    Type the numbers and letters shown on the left.


    Submit Article     Return to Article Index

    Subscribe to Subscribers
    Active Members
    TodayLast 7 Daysmore...

    Awards & Gifts
    Talk to Webmaster Tony John

    Online Members

    Priya jain
    More...
    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India