Search
Left Quote    Maybe this world is another planet's Hell.
- Aldous Huxley    
Right Quote
 
[login] | [Register]
 

Databases and Access

by: bs0d
Page: 6 of 6
(View All)

RELATIONSHIPS:


FORMATTING A CALCULATED FIELD

  1. Click on the PROPERTIES icon on the tool bar.
  2. Click on FORMAT tab.

RELATIONSHIP - a common field between two files.

TYPES OF RELATIONSHIPS...

  • ONE TO ONE -one group of data can be related to one and only one other group of data. When creating a one-to-one relationship, you are going from the key field of one table to the key-field of another table. An example of a one-to-one relationship would be student to student-id.
  • ONE TO MANY - one group of data can be related to one or more other groups of data but the reverse is not true. When creating a one-to-many relationship, you are going from the key field of one table to a corresponding field in the second table where the field in the second table is not a primary key. An example of a one-to-many relationship is a mother to her children.
  • MANY TO MANY -one group of data can be related to one or more other groups of data and vice versa. When creating a many-to-many relationship, it takes two one-to-many relationships put together. An example of a many-to-many relationship would be uncles to nephews.
  • REFERENTIAL INTEGRITY -A system of rules in Access that ensures that relationships between records in related tables are valid and that you don

    1  |  2  |  3  |  4  |  5  |  6  |  


    No Comments for this page.

    You Must be logged in or a member to comment.


Tutorial Stats

Tutorial Stats

18,307 Views
0 Total Comments
3 Rating of 5 (1 Votes)

Options

Tutorial Options

· Login to Rate This Article
· Login to Post a Comment
· Read more by this author
Digg This Article! Del.icio.us: Bookmark This Article Reddit: Bookmark This Article BlinkList: Blink This Article! YahooMyWeb BlogMarks: Add This Mark! Furl: Save This Article Spurl: Mark This Article

Articles

Related    

· Getting Started with Excel
Your Article Here



"AllSyntax.com" Copyright © 2002-2018; All rights lefted, all lefts righted.
Privacy Policy  |  Internet Rank