Introduction
Welcome to Armstrong Computers College’s resource center! As part of our commitment to ensuring student success, we provide past questions to help you prepare effectively for your upcoming examinations. Today, we present the November/December 2012 Level 3 Database Management Past Questions. This guide is designed to familiarize students with the type of questions they can expect and equip them with the confidence to excel in their exams.
Why Use This Resource?
Familiarity with Exam Format Get accustomed to how questions are framed and what examiners expect in terms of answers.
- Enhanced Preparation Practice with real past questions to test your knowledge and improve your problem-solving skills.
- Practical Solutions Our team has solved Section B of this past question practically, with a detailed video walkthrough for better understanding.
- Downloadable Resource Access and download the full question set to practice offline and prepare at your own pace.
How to Use This Resource
- Step 1: Review the questions in this post.
- Step 2: Click on each question to reveal the solution and understand the approach to answering it.
- Step 3: Watch the practical demonstration video for Section B to gain a hands-on understanding of the tasks.
- Step 4: Download the full set of questions and try solving them independently to test your knowledge.
SECTION A
Answer all the questions.
- .mdb: Used in Access 2003 and earlier versions.
- .accdb: Introduced in Access 2007 with advanced features.
- .accde: A compiled format for distributing applications.
Filter by Selection: Filters records based on the selected value in a field.
- Tabular: Data in rows and columns like a spreadsheet.
- Justified: Fields aligned with minimal white space.
- Columnar: Records displayed vertically.
Foreign Key: Links tables by referencing a primary key.
Primary Key: Unique identifier for table records.
Entity Relationship: Logical connection between entities.
SECTION B PRATICAL
a. Open a database package that you are familiar with and create a database file called “June 2014”.
b. Create a table within this database and use the following structure and data.
| INDEX | COST NO |
PRODUCT | QUANTITY | UNIT COST |
DISCOUNT (8%) |
TOTAL COST |
|---|---|---|---|---|---|---|
| 3 | 54 | BEANS | 245 | 13 | ||
| 2 | 56 | MATEMBA | 678 | 8 | ||
| 1 | 58 | NZUNGU | 453 | 7 | ||
| 4 | 60 | NYMO | 176 | 8 | ||
| 5 | 62 | YAM | 258 | 8 | ||
| 6 | 64 | ORANGES | 999 | 9 | ||
| 7 | 66 | POTATOES | 776 | 5 | ||
| 8 | 68 | CASSAVA | 894 | 6 | ||
| 9 | 70 | TOMATOES | 366 | 7 | ||
| 10 | 72 | FRYTOL | 387 | 7 | ||
| 12 | 56 | GEISHA | 435 | 8 | ||
| 14 | 89 | REXONA | 207 | 2 | ||
| 16 | 65 | OMO | 400 | 5 | ||
| 17 | 99 | MALT | 444 | 3 | ||
| 15 | 90 | COKE | 626 | 2 | ||
| 13 | 91 | FANTA | 508 | 2 | ||
| 11 | 94 | PEPSI | 367 | 2 |
C. Save the table as PROMOTION
Using an Update query:
1. Calculate the DISCOUNT column which is 8% of the quantity column multiplied by the UNIT COST
2. Using an Updata query, calculate the TOTAL column which is the product of the QUANTITY column and the Unit cost column less the DISCOUNT column.
3. Sort the PROMOTION table by INDEX column in ascending order.
Watch How to calculate the DISCOUNT And TOTAL column
Download Full Question Set
Click here to downloadthe full November/December 2012 Level 3 Database Management Past Questions. Print it out and practice at your convenience!
Conclusion
Preparing for exams has never been easier with Armstrong Computers College. Take advantage of these resources to boost your confidence and knowledge. Remember, consistent practice and understanding of the concepts are key to success.
For further assistance or more past questions, feel free to reach out to us. Armstrong Computers College – Bringing ICT to your doorstep.
