Database Project

Create a database product using MS Access that can be used to solve a unique clients problem in your community. The task will be done individually but you can consult widely from peers, database experts and from online tutorials. 

Your database should;

• address unique problem (example; Train ticketing database).
• have at least two related tables.
• at least four queries with some complex calculations applied.
• a well designed switchboard that loads first when the database opened.
• include a logo in the switchboard with appealing colors used in the different forms.
• have at least three forms.
• use macros where possible.
• have at least two well designed reports.
• At least 5 min screencast of how the product functions should be uploaded on managebac.

ONLY A screencast explaining how the product functions and what techniques were used,
 will be uploaded on managebac.


Assessment Rubric

Level	Descriptors
1-4	Simple product developed that does not capture effectively the details of some limited requirement for the product listed. The use of database techniques in the software of choice is limited in the development of the product. The product does not solve a specific practical problem. The product fails to function as required. The screen cast fails to show how parts of the product function.
5-9	Good quality product developed that captures effectively some of the details for the database product as listed. Some of the database techniques are used appropriately in the development of the product. The product solves to some extent a practical problem. Product functions as required. The screen cast shows how some parts of the product function.
10-14	Excellent quality product developed that captures effectively most the details of most database product. Most of the techniques in the software of choice are competently and appropriately used in the development of the product. The product solves effectively a practical problem. Most of the section of the product function effectively. The screen cast shows in detail how most of the product functions and how it was designed