Notes
Exams
Schemes of Work
Q&A
Video Lessons
Question Papers
Colleges
Universities
Courses
Resources
Login
|
Register
|
Jobs
Get premium membership
and access revision papers, questions with answers as well as video lessons.
Got a question or eager to learn? Discover limitless learning on WhatsApp now -
Start Now!
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
Form 1 End Term 3
Form 1 End Term 2
Form 1 End Term 1
Form 2 End Term 3 Exams
Form 2 End Term 2 Exams
Form 2 End Term 1 Exams
Form 3 End Term 3
Form 3 End Term 2
Form 3 End Term 1
Form 4 End Term 2
Form 4 End Term 1
Grade 1 End Term 3
Grade 1 End Term 2
Grade 1 End Term 1
Grade 2 End Term 3
Grade 2 End Term 2
Grade 2 End Term 1
Grade 3 End Term 3 Exams
Grade 3 End Term 2 Exams
Grade 3 End Term 1 Exams
Grade 4 End Term 3
Grade 4 End Term 2
Grade 4 End Term 1
Grade 5 End Term 3 Exams
Grade 5 End Term 2 Exams
Class 6 End Term 3
Class 6 End Term 2
Class 6 End Term 1
Class 7 End Term 3
Class 7 End Term 2
Class 7 End Term 1
Class 8 Term 3
Class 8 End Term 2
Class 8 End Term 1
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