Working with databases/Create a database/Data types/Model answers
From WikiEducator
Working with Databases
Basic skills applicable to planning, creating and using an Access database.
An OP Online course from the National Certificate in Computing (Level 2) programme.
Choosing data-types
Here are our suggestions for the data-types of the fields in the Books database:
| Field | Data-type |
|---|---|
| Year published | Date/Time |
| Number of pages | Number |
| Paperback or hardback | Yes/No |
| Author | Text |
| ISBN number | Text |
| Item to be ordered | Yes/No |
| Price purchased for | Currency |
| Price sold for (retail price) | Currency |
| Book Title | Text |
Return to the Data types page.
