Schemes of Work
Lesson Plans
Notes
Exams
Holiday Assignments
Tests
Forum
Q&A
Lessons
Past Papers
Colleges
Courses
Login
|
Register
|
Jobs
Get premium membership
and access revision papers, questions with answers as well as video lessons.
Information System (Ms Access) Question Paper
Information System (Ms Access)
Course:
Institution:
question papers
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).
Subscribe to View Content
Subscribe to View Content
More Question Papers
Probability And Statistics (Exam 1/P)
,Him 011: Food Production 1,2013
Advanced Certificate In Counselling/Chaplaincy Exam
Aeb 302: Crop Protection
Ansc 352: Non Ruminant Animal Production
Association Of Chartered Certified Accountants(Acca)
Business
Business Communication And Management
Business Research Methods
Buss 100: Principles And Practice Of Management
Core Technical 1 Financial Mathematics
Core Technical 1 Financial Mathematics [Including Examiners Report(2005-2011)]
Crd 232: Plant Growth And Development
Crop 531: Plant Breeding
Cuu 100: Communication Skills (Day Class)
Dis302
Dis302
Dit 407: Network Design &Amp; Implementation.
Dom 102
Ece Cotemporary In Early Childhoold Development
Economics
Economics Including Examiners Report
Ect 300:Educational Technology
Food Legislation
Gpr 205: Sale Of Goods And Agency Module Ii
Hcb2103-Mathematics For Business Cat
Industrial Management
Information System Development
Internet Technology
Introduction To Information Technology
Introduction To Law(Kasneb)
Introduction To Philosophy
Language In Broadcasting
Macro Economic Theory
Principles Of Marketing
Principles Of Marketing (Cat)
Operations Management
Principles Of Wildlife Management
Principles Of Crop Protection
Principles Of Data Communications
Refrigeration Paper
Marketing Channels (Sunday)
Management Information System
Word Processing
Probability And Mathematical Statistics (Exam 1/P)
Probability And Mathematical Statistics (Exam 1/P)
Probability And Mathematical Statistics (Exam 1/P)
Enhance your teaching with our comprehensive Schemes of Work and Notes!
Popular Exams
Grade 1 End of Term 2
Grade 2 End of Term 2
Grade 3 End of Term 2
Grade 4 End of Term 2
Grade 5 End of Term 2
Grade 6 End of Term 2
Grade 7 End of Term 2
Grade 8 End of Term 2
PP1 End of Term 2
PP2 End of Term 2
Playgroup End of Term 2
Form 1 End of Term 2
Form 2 End Term of Term 2
Form 3 End of Term 2
Form 4 End of Term 2
Mid Term Exams
Playgroup Mid Term 2
PP1 Mid Term 2
PP2 Mid Term 2
Grade 1 Mid Term 2
Grade 2 Mid Term 2
Grade 3 Mid Term 2
Grade 4 Mid Term 2
Grade 5 Mid Term 2
Grade 6 Mid Term 2
Grade 7 Mid Term 2
Grade 8 Mid Term 2
Form 1 Mid Term Exams
Form 2 Mid Term Exams
Form 3 Mid Term
Form 4 Mid Term
CBC Assessment Tests
End Term 1 Exams
PP1 End Term 1
PP2 End Term 1
Grade 1 End of Term 1
Grade 2 End of Term 1
Grade 3 End of Term 1
Grade 4 End of Term 1
Grade 5 End of Term 1
Grade 6 End of Term 1
Grade 7 End of Term 1
Grade 8 End of Term 1
Form 1 End of Term 1
Form 2 End Term of Term 1
Form 3 End of Term 1
Form 1 End of Term 3
Form 4 End of Term 1
End Term 3 Exams
Form 2 End Term of Term 3
Form 3 End of Term 3
Form 3 Mid Term Exams
Form 4 Mid Term Exams
Form 4 Term 2 Mock Exams
PP1 End Term 3
Grade 1 End of Term 3
Grade 2 End of Term 3
Grade 3 End of Term 3
Grade 4 End of Term 3
Grade 5 End of Term 3
Opener Exams
Grade 1 Opener
Grade 2 Opener Exams
Grade 3 Opener Exams
Grade 4 Opener Exams
Grade 5 Opener Exams
Grade 6 Opener Exams
Grade 7 Opener Exams
Grade 8 Opener Exams
Form 1 Opener
Form 2 Opener
Form 3 Opener
Form 4 Opener
PP1 Opener
PP2 Opener
Form 3 Opener
Form 4 Opener
Full Set Exams
Playgroup End Term 2
PP1 End Term 2
PP2 End Term 2
Grade 1 End Term 2
Grade 2 End Term 2
Grade 3 End Term 2
Grade 4 End Term 2
Grade 5 End Term 2
Grade 6 End Term 2
Grade 7 End Term 2
Grade 8 End Term 2
Form 1 End Term 2
Form 2 End Term 2
Form 3 End Term 2
Form 4 End Term 2
Form 1 Term 2 Opener Exams
Form 2 Term 2 Opener Exams
Form 3 Term 2 Opener Exams
Form 4 Term 2 Opener Exams
Playgroup Mid Term 2
PP1 Mid Term 2
PP2 Mid Term 2
Grade 1 Mid Term 2
Grade 2 Mid Term 2
Grade 3 Mid Term 2
Grade 4 Mid Term 2
Grade 5 Mid Term 2
Grade 6 Mid Term 2
Grade 7 Mid Term 2
Grade 8 Mid Term 2
Form 1 Mid Term 2 Exams
Form 2 Mid Term 2 Exams
Form 3 Mid Term 2 Exams
Form 4 Mid Term 2 Exams
Playgroup Term 2 Opener
PP1 Term 2 Opener
PP2 Term 2 Opener
Grade 1 Term 2 Opener
Grade 2 Term 2 Opener
Grade 3 Term 2 Opener
Grade 4 Term 2 Opener
Grade 5 Term 2 Opener
Grade 6 Term 2 Opener
Grade 7 Term 2 Opener Exams
Grade 8 Term 2 Opener
Grade 1 End of Term 1
Grade 2 End of Term 1
Grade 3 End of Term 1
Grade 4 End of Term 1
Grade 5 End of Term 1
Grade 6 End of Term 1
Grade 7 End of Term 1
Grade 8 End of Term 1
Form 1 End Term 1 Exams
Form 2 End Term 1 Exams
Form 3 End Term 1 Exams
Form 4 Paper 1 and 2 End Term 1 Exams
Form 4 Paper 3 End Term 1 Exams
Return to Question Papers
 
Quick Links
Buy Primary and High School Exams
PP1 Schemes of Work
PP2 Schemes of Work
Grade 1 Schemes of Work
Grade 2 Schemes of Work
Grade 3 Schemes of Work
Grade 4 Schemes of Work
Grade 5 Schemes of Work
Class 6 Schemes of Work
Grade 7 Schemes of Work
Grade 8 Schemes of Work
Form 1 Schemes of Work
Form 2 Schemes of Work
Form 3 Schemes of Work
Form 4 Schemes of Work
Browse all past papers
Search for courses
Search for a college
Search for a university
Search for a school
Schemes of Work
New CBC Report Cards
Class Notes
Lecture Notes
Study Guides