database. computer-based filing systems information in computer-based filing systems are stored in...
TRANSCRIPT
![Page 1: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/1.jpg)
DATABASE
![Page 2: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/2.jpg)
Computer-based filing systems
Information in computer-based filing systems are stored in DATA FILES.
A FILE is a collection of RELATED RECORDS.Related records means that one field in a
table will contain the same sort of information as a field in each of the other tables.
![Page 3: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/3.jpg)
ISBN Title Author Publisher
1-2456-98-09 Complete Cat Care
Claudia Heiniken
Stones
1-6789-098 Build your own home
Brian Deacon Taylor
1-87890-098-87 Better homes Jula Stones Taylor
File
![Page 4: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/4.jpg)
ISBN Title Author Publisher
1-2456-98-09 Complete Cat Care
Claudia Heiniken
Stones
1-6789-098 Build your own home
Brian Deacon Taylor
1-87890-098-87 Better homes Jula Stones Taylor
Fields
![Page 5: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/5.jpg)
ISBN Title Author Publisher
1-2456-98-09 Complete Cat Care
Claudia Heiniken
Stones
1-6789-098 Build your own home
Brian Deacon Taylor
1-87890-098-87 Better homes Jula Stones Taylor
Record
![Page 6: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/6.jpg)
ISBN Title Author Publisher
1-2456-98-09 Complete Cat Care
Claudia Heiniken
Stones
1-6789-098 Build your own home
Brian Deacon Taylor
1-87890-098-87 Better homes Jula Stones Taylor
Key Field
![Page 7: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/7.jpg)
ISBN Title Author Publisher
1-2456-98-09 Complete Cat Care
Claudia Heiniken
Stones
1-6789-098 Build your own home
Brian Deacon Taylor
1-87890-098-87 Better homes Jula Stones Taylor
Key Field uniquely identifies an
individual record
![Page 8: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/8.jpg)
DATA TYPES
• ALPHANUMERIC/TEXT
• NUMERIC (NUMBER)
• LOGICAL/BOOLEAN
• DATE
![Page 9: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/9.jpg)
ALPHANUMERIC/TEXT
Can hold any character such as a letter, number, symbol or space.
Mixture of letters and numbers.
![Page 10: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/10.jpg)
DATA TYPES
• ALPHANUMERIC/TEXT
• NUMERIC (NUMBER)
• LOGICAL/BOOLEAN
• DATE
![Page 11: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/11.jpg)
NUMERIC (number)
For integers (whole numbers) or real numbers (decimals)
Fields that hold numbers only eg. 27 or 0.24, not numbers and text
![Page 12: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/12.jpg)
DATA TYPES
• ALPHANUMERIC/TEXT
• NUMERIC (NUMBER)
• LOGICAL/BOOLEAN
• DATE
![Page 13: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/13.jpg)
LOGICAL/BOOLEAN
Can only hold two values – usually yes/no or true/false.
Fields such as a Member? Paid? Where the answer is yes or no.
Access shown this as a box that is ticked yes or not ticked no.
![Page 14: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/14.jpg)
DATA TYPES
• ALPHANUMERIC/TEXT
• NUMERIC (NUMBER)
• LOGICAL/BOOLEAN
• DATE
![Page 15: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/15.jpg)
DATE
For dates or times.Storing dates in many different formats.
![Page 16: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/16.jpg)
VALIDATION
Use validation rules to make sure the data you enter is REASONABLE.
A validation rule does not stop you entering the wrong data, it stops you entering UNREASONABLE data.
![Page 17: DATABASE. Computer-based filing systems Information in computer-based filing systems are stored in DATA FILES. A FILE is a collection of RELATED RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062518/56649e9e5503460f94ba024b/html5/thumbnails/17.jpg)
VERIFICATION
Two methods, visual checking and double entry.