Information System (Ms Access) Question Paper

Information System (Ms Access)

Course:

Exam Year:2012

You are administrative assistant working in Kenya Field Museum, which has a famous glass collection. You are responsible for the keeping an up-to-date record of the items in the collection. Please create a database file and call it “GLASS” which should contain the following.
1. Create a table and call it “GLASSCO” use it to enter the following information.
Field headings within each record:
Field name Type
TYPE CHARACTER
SHAPE CHARACTER
COLOUR CHARACTER
DESIGN CHARACTER
HEIGHT NUMERIC
DATE MAN. DATE
MANUFACTURER CHARACTER

Enter the following records in your table.

Record 1
Vase
Spherical
Light blue
Rose spray
19
31/12/1890
T Webb
Record 2
Vase
Conical
Red
Doughnut
18
15/6/1880
Sturbridge
Record 3
Bottle
Circular
Bermuda blue
Setting sun
14
21/8/1895
T Webb

Record 5
Gourd
Egg-shaped
Brown
Murzik plus
17
18/9/1963
Kipmilk

Record 4
Jug
Cylindrical
Maroon
Plain
15
11/2/1925
Stevens and Williams

Record 6
Bowel
Semicircular
Chocolate
Coastish
10
30/11/1978
Fatumina & Co.

2. Index all the records in your table according to date manufactured from the oldest to recent type.

3. The Kenya Field Museum received a letter from T. Webb Manufacturer which stated that they were bankrupt and would like to end their contract with your firm. Create a query indicating the updated active suppliers of your glass wares.

4. Create a query which shall indicate all records of containers whose height is less than 18.

5. Create a report to reflect all the records before the withdrawal of T. Webb. Customize your report well.
Print and hand in your work. (NB: Arrange your work in the order of tables, queries and reports respectively before stapling or binding).

📘 Access 10,000+ CBC Exams With Marking Schemes

Information System (Ms Access) Question Paper

More Question Papers

Exams With Marking Schemes

End Term 3 Exams

Mid Term Exams

End Term 1 Exams

Opener Exams

Full Set Exams