DATABASES – KAKURU BENARD
Twegatte Savings Group was established to promote savings and loans among
its members. Using the data in [Link], create a database in your names
and personal number and answer the following.
(a) Open your table in design view and perform the following
i. Add appropriate data types to the table
ii. Add a new field named “Sex” and populate the table using Lookup
wizard
iii. Add a “UGX” symbol to all currency fields
(b) Create the following queries
i. A calculated query to return loan balances. Save it as Calculated.
ii. Using the above query, filter out members who completed paying the
loan. Save it as Completed.
iii. Using calculated query, filter out members with out standing loan
balances and save it as Outstanding Loan.
iv. Using calculated query, add a new field named Age to compute for
Age of each member.
v. Of members born in February of Every Year. Save it as Born Feb.
vi. To return members born in the Year 2000. Save it as 2000’s.
(c) Create a form from the table and modify it as follows
i. Add a tile
ii. Add date and time
iii. Any Background color
iv. Footer of your names and personal number
v. Calculate the Loan Balance
vi. Save the form as Final Form.
(d) Create a report from the Outstanding Loan balance query and perform the
following
i. Add an appropriate title
ii. Any background color
iii. Red borders
iv. Footer of your personal number
v. Sort names in descending order
vi. Add an image “Twegatte” on your report to act as a logo
(e) Print all your work