Question: information trchnology test need help Question 2 You work as an IT manager of a company and as part of your new reasonability management request
Question 2 You work as an IT manager of a company and as part of your new reasonability management request that you design a simple Database using Microsoft Access to capture details of the company. (Choose any organization of your choice). 2 Consider the following in the design of your database. (a) i. The database should have a login page ii. It should contain at least three different tables iii. Establish relationships between the tables AP (10) (b) Design a Form and a Report for the database AP (5) C) Create a simple query for the database. AP (5) NB: ii. Attach the soft copy of your database when submitting your documents Discuss the summary of your database on your answer sheet for this question. The discussion should focus on the tables, the relationships, the query, report and form. [TOTAL: 20 MARKS] Question 2 You work as an IT manager of a company and as part of your new reasonability management request that you design a simple Database using Microsoft Access to capture details of the company. (Choose any organization of your choice). 2 Consider the following in the design of your database. (a) i. The database should have a login page ii. It should contain at least three different tables iii. Establish relationships between the tables AP (10) (b) Design a Form and a Report for the database AP (5) C) Create a simple query for the database. AP (5) NB: ii. Attach the soft copy of your database when submitting your documents Discuss the summary of your database on your answer sheet for this question. The discussion should focus on the tables, the relationships, the query, report and form. [TOTAL: 20 MARKS]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
