Database design and MS Access elements
Answers are for parents and teachers.
1
Write the fields and types for the Readers table of the library design.
ReaderID – AutoNumber; FullName – Short Text; Class – Short Text.
2
Which type holds text of up to 255 characters?
Short Text
3
Name the types for a date of birth field and a yes/no (membership) field.
Date/Time and Yes/No
4
Make an Excel table of 6 invented books and write down its fields.
The answer is personal: for example BookID, Title, Author, Year.
5
Why are several linked tables used instead of putting all the data in one table?
Data are not repeated, mistakes decrease and a change is made in one place.