You are database designer and data analyst working for the hypothetical employer, Park University. The memo style response and further information provided among your peers really helped the CIO and the University Controls Department get a better understanding of how to manipulate and analyze data from queries that join multiple tables.
After further review and correspondence with the University Controls Department and you, the CIO is really excited as the updated Technology Asset Management System designed in Microsoft Access is coming together and all seems to be working well at this point; however, the CIO has realized that multiple users will use this database and wants to ensure the database is secured because when tracking assigned technology with the University, some tables may have sensitive personal information not to be readily shared with others when tracking and analysis reports are made.
In a memo style response to the Chief Information Officer (CIO), share based on your knowledge learned about databases using experience and research any suggestions and ideas you may have to keep the database and its contents secured in a multi-user environment that is supported by Microsoft Access. The CIO would also like ideas and suggestions on the types of personnel to have full internal access to the database and those that would not have access to the internal structure along with any suggested procedures to follow in cases when any updates to the design of the database and its tables and other objects are needed or requested.
Discussion Tip: For the nature of this discussion further research into types of information held in a Technology Asset Management System would be helpful. This is important for any database because the levels of security needed for a database would surly correlate to the sensitivity of the data held in the database. Also take into consideration of the possibility that other table data could be linked to this database from other more enterprise level databases used by Park University.
