This is my database plan. Just a small table to represent the fields I want on my actual database.
Forms:
In order to transfer data into the database, we first need to get the information from the books before we stack them into the library. There will be a form provided that needs to be filled in so that we can transfer the information into the database. This form will include:
Forms:
In order to transfer data into the database, we first need to get the information from the books before we stack them into the library. There will be a form provided that needs to be filled in so that we can transfer the information into the database. This form will include:
- Name of book
- Name of author of the book
- Country originated in
- Genre
Validation rules:
When I create this database on MS Access, I will need to use specific validation rules to make sure that the fields hold the correct information. An example of a validation rule I might use can be:
- >=10000 and <=99999
This rule makes sure that there's numbers between 10000 and 99999, including those two numbers. I would probably use this rule for the "Book code" to make sure that the numbers are correct.
