Week 2 Flashcards
(9 cards)
1
Q
What are the basic attribute data types for holding numbers
A
- Autonumber
- Integer
- Double
- Currency
- Calculated Field
2
Q
What are the basic attribute data types for holding TEXT and what are their sizes
A
Short Text (256 Characters)
Long Text (65 536 Characters)
3
Q
What are the basic attribute data types for holding DATE/TIME Data
A
Medium Date
Medium Time
4
Q
What is the Primary Key
A
It’s a unique identifier for each row
5
Q
What conditions is a PKEY subject to?
A
- Must be unique and not null
- Can be composed of 1 or more attributes
6
Q
What is NULL in a database
A
It is null, which means it holds no data. Not even a value of 0
7
Q
What is a Recommended field size for First Names or Last Names
A
20 Characters
8
Q
What is a Recommended field size for an email address
A
50 Characters
9
Q
What is the
A
