Skip to content

GoConqr has a new look! Let us know what you think.

Sign up free

Mind map

Database - Tools and Techniques

BenPenn English

Map content

Database - Tools and Techniques

Table characteristics
- Rows and columns
  - Rows = Records
  - Columns = Fields
    - Alphabetic
      - Text
      - Memo
    - Numeric
    - Boolean/Logical
    - Web
    - Look up wizard
    - Field size
    - Field size
    - Field format
    - Web
      - Hyperlink
Validation
- To check for errors
- Applies to a range
- Correct format
  - postcode
    - input mask
- Correct field size
- Correct data size
Indexing
- Primary key
- foreign key
Relationships
- One to many
- One to one
- Many to many

Information

Description: Mind Map on Database - Tools and Techniques, created by BenPenn on 04/11/2014.
Created by: BenPenn
Views: 4
Rating