Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mis And Edp Auditing For Accountants And Auditors

Authors: Srv

1st Edition

9993730351, 978-9993730354

More Books

Students also viewed these Accounting questions

Question

Differentiate 3sin(9x+2x)

Answered: 1 week ago

Question

Compute the derivative f(x)=(x-a)(x-b)

Answered: 1 week ago