ICT Notes 1/22/09
Yeah, I could only post now. I couldn't last week. D: Sir didn't allow internet access.
More notes!!
Database Terminologies
field - space designed to accept and store a certain type of data
field name - like a label that describes what data should be entered into the field
record - contains a group of related fields
data file - table, collection of related records
Group Fields into Tables
Guidelines
- what sort of data they expect the database to contain
- what kinds of reports they require
- what types of summary information they would like to see
- it should hold information on only one subject
Field and Table Names
- no more than 64 characters
- cannot include . ! ' [ ] "
- cannot have a leading space
- brief but descriptive
Data Types
- text
- memo
- number
- date/time
- currency
- atounumber
- yes/no