Managing Information Systems: MS Access Database Homework Solution

This document presents a solution to an MS Access database assignment for a Master of Business Administration (MBA) course. The assignment focuses on creating and querying a customer database, named 'Customer,' with two tables: CustInfo and CustBal. The solution includes entering data for 20 customers and generating reports based on specific criteria. The queries involve filtering and displaying data based on conditions such as gender, age, marital status, and account balances. The assignment requires students to demonstrate their understanding of database design, data types, and query construction to extract relevant information and generate reports. The document also includes a bibliography with relevant database systems and data management resources.

Running head: MS ACCESS DATABASE
MS Access Database
Name of the Student
Name of the University
Author’s Note:

2MS ACCESS DATABASE
Question 1:
a)
b)
c)

3MS ACCESS DATABASE
d)
e)
f)

4MS ACCESS DATABASE
Question 2:
a)
b)

5MS ACCESS DATABASE
c)
d)

6MS ACCESS DATABASE
e)

7MS ACCESS DATABASE
Bibliography:
Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management.
Cengage Learning.
Liu, C., Springer, D., Li, Q., Moody, B., Juan, R.A., Chorro, F.J., Castells, F., Roig, J.M., Silva,
I., Johnson, A.E. and Syed, Z., 2016. An open access database for the evaluation of heart
sound algorithms. Physiological Measurement, 37(12), p.2181.
McNally, M.R., Patton, C.L. and Fremouw, W.J., 2016. Mining for murder‐suicide: An approach
to identifying cases of murder‐suicide in the national violent death reporting system
restricted access database. Journal of forensic sciences, 61(1), pp.245-248.
Pławińska-Czarnak, J., Ochnio, J.Z., Zarzyńska, J., Bogdan, J., Kaba, J., Majewska, A. and
Bagnicka, E., 2018. Design and implementation of a database enhancing the collection,
management and analysis of data in an animal sciences project. Animal Science Papers
and Reports, 36(2), pp.159-170.
Ray, K., 2015. Design and Implementation of Database Independent Auto Sequence
Numbers. arXiv preprint arXiv:1503.04385.