Transcript
![Page 1: Software. Records Fields Each record is made up of fields – categories of information. The fields here are Name, Surname, Address, Telephone and Date](https://reader035.vdocuments.us/reader035/viewer/2022070410/56649ec65503460f94bd1273/html5/thumbnails/1.jpg)
Software
![Page 2: Software. Records Fields Each record is made up of fields – categories of information. The fields here are Name, Surname, Address, Telephone and Date](https://reader035.vdocuments.us/reader035/viewer/2022070410/56649ec65503460f94bd1273/html5/thumbnails/2.jpg)
Records
Fields
Each record is made up of fields – categories of information.
The fields here are Name, Surname, Address, Telephone and Date of birth.
File
![Page 3: Software. Records Fields Each record is made up of fields – categories of information. The fields here are Name, Surname, Address, Telephone and Date](https://reader035.vdocuments.us/reader035/viewer/2022070410/56649ec65503460f94bd1273/html5/thumbnails/3.jpg)
![Page 4: Software. Records Fields Each record is made up of fields – categories of information. The fields here are Name, Surname, Address, Telephone and Date](https://reader035.vdocuments.us/reader035/viewer/2022070410/56649ec65503460f94bd1273/html5/thumbnails/4.jpg)
Let’s get it right?
Here are some more field names and data types:
Fields are of a certain data type. For example, Name and Surname are text; Date of birth is not text but a date.
Data Types
text date
![Page 5: Software. Records Fields Each record is made up of fields – categories of information. The fields here are Name, Surname, Address, Telephone and Date](https://reader035.vdocuments.us/reader035/viewer/2022070410/56649ec65503460f94bd1273/html5/thumbnails/5.jpg)
![Page 6: Software. Records Fields Each record is made up of fields – categories of information. The fields here are Name, Surname, Address, Telephone and Date](https://reader035.vdocuments.us/reader035/viewer/2022070410/56649ec65503460f94bd1273/html5/thumbnails/6.jpg)
Can I have a go?
This database shows records of students joining a college. Can you match the data type to the field name?
![Page 7: Software. Records Fields Each record is made up of fields – categories of information. The fields here are Name, Surname, Address, Telephone and Date](https://reader035.vdocuments.us/reader035/viewer/2022070410/56649ec65503460f94bd1273/html5/thumbnails/7.jpg)
Forms and reports
Forms are designed to be viewed on screen. They make it easier for users to enter data into a database.
Reports are designed to be printed.