Question
QUESTION ONE: MS ACCESS [70 Marks] MomoJombo Commercial Bank (MCB) has grown from being a rural bank to a commercial bank. It now has 5
QUESTION ONE: MS ACCESS [70 Marks] MomoJombo Commercial Bank (MCB) has grown from being a rural bank to a commercial bank. It now has 5 branches with each branch been headed by a manager who is an employee of the bank. The bank has 220 employees and each employee belongs to a particular department. It serves over 5000 customers for which each customer has at least an account with the bank. Currently the bank keeps all these records using a file system which comes with its own challenges. The management of MCB has contracted your company to help design a new database system for them. INSTRUCTIONS Using the statement above, perform the following instructions 1. Using MS Access, create a database for MomoJombo Commercial Bank (MCB) and save it as dB_Identification plus your surname [2 Mark] 2. Identify and create the various tables and save the tables using the appropriate names [3 Marks] 3. Analyze the tables identified and design it be stating the necessary fields [3 Marks] and 4. Set Appropriate data types of the fields [4 Marks] 5. Set the primary key for each table [3 Marks]. 6. Set the following properties: Field Size, Caption and Description [3 Marks) 7. Establish relationships between the various tables that youve created [3 Marks]. 8. Perform the following validation rule and set the appropriate validation text for each validation rule a. A rule to ensure that the Customer ID start with CO, Branch ID with BR and Employee ID with EMP followed by three characters. Example, a table may have a valid table ID as CO001, CO002, BR102, BR103, EMP110, EMP111 respectively. [2 Marks each] 9. Populate your tables with not less than 10 records. [10 Marks] 10.Design forms for the tables: a. Design a form for Customers that shows the Customer Full name, Telephone Number and city with Record operation buttons. The form should be captioned Customer Directory Form and saved as CustomerForm plus your Initials [ 4 Marks]
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started