Question: Details: In this assignment you will create an MS Access database with content of your choice. It is strongly recommended you use the latest MS

Details: In this assignment you will create an MS Access database with content of your choice. It is strongly recommended you use the latest MS Access 2016, but databases created in MS Access 2013 or MS Access 2010 will also be accepted (not earlier versions). Your database must meet the following qualitative and quantitative criteria: 1. The DB must contain at least 6 tables. (1 mark out of 7) 2. The tables must be consistent (i.e., it must represent a single entity, and all columns must be logical attributes of that entity). Each table must have a minimum of 4 attributes and a minimum of 4 records. (1 mark out of 7) 3. The DB must have at least four relationships between the tables. (1 mark out of 7) 4. You must use at least four different data types across all 6 tables. (0.5 mark out of 7) 5. You must have at least two examples of Input Mask. (0.5 mark out of 7) 6. You must have at least one example of Validation Rule and Validation text. (0.5 mark out of 7) 7. At least one lookup must be used with reference to another table. (0.5 mark out of 7) 8. One form must be created involving fields from at least two tables. (0.5 mark out of 7 8. One form must be created involving fields from at least two tables. (0.5 mark out of 7) 9. One report must be created involving fields from at least two tables. The report must present a subset of data answering a specific question regarding the data. (0.5 mark out of 7) 10. One query must be created involving fields from at least two tables; the query must present a subset of data answering a specific question regarding the data. (0.5 mark out of 7) 11. One parameterized query must be created. (0.5 mark out of 7)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
