Some Facts about Databases

1
Some Facts about Databases
Key Words
Data Types
Coding
2
Key Words

• Field a single piece of information
• eg Gender, Surname
• Record the collection of fields stored about
  one person or thing
• Primary Key the field that uniquely
  identifies a record
• eg Student Number

Home
Data Types
Coding
Questions
3
Questions

• Which word best describes this?
• a) Field b) Record c) Primary key

X
X
?
Next Question
Key Words
4
Questions

• Which word best describes this?
• a) Field b) Record c) Primary key

X
?
X
Next Question
Key Words
5
Questions

• Which word best describes this?
• a) Field b) Record c) Primary key

?
?
X
Home
Data Types
Coding
Key Words
6
Data Types

• Each field stores data of a particular Data Type
  eg Number, Text, Date, Currency
• Some Key Facts
• Text Data Type can store Letters and Numbers
  Alphanumeric
• Alphabetic means letters only. Access does not
  have an alphabetic data type.

Home
More Data Types
Coding
Key Words
Data Types Questions
7
Data Types used in Access

• Text Letters and Numbers (Alphanumeric)
• Number Numbers
• Currency Numbers with 2 decimal places
• (for money)
• Date/Time For dates - prevents silly dates eg
  63 August

Home
Data Types Questions
Coding
Key Words
8
Questions

• Which word best describes this data?
• a) Alphabetic
• b) Alphanumeric
• c) Numeric

X
?
Data Types
Next Question
X
9
Questions

• Which word best describes this data?
• a) Alphabetic
• b) Alphanumeric
• c) Numeric

?
X
Data Types
Next Question
X
10
Questions

• Which word best describes this data?
• a) Alphabetic
• b) Alphanumeric
• c) Numeric

X
X
Data Types
Coding
?
11
All about Coding

• Coding means using a shortened form when entering
  data
• eg L Large M Medium S Small
• Coding means you dont have to type in so much
  data

Home