This blog article presents a detailed breakdown of the November/December 2015 Level 2 Database Management examination. It is curated by Armstrong Computers College to help ICT students practice real exam questions, understand Microsoft Access database concepts, and improve their query and table design skills.
At Armstrong Computers, our aim is to deliver high-quality ICT education at your doorstep, empowering students to build rewarding careers through practical skills.
Armstrong Computers – Where vision meets excellence.
SECTION A – Theory Questions
1. Explain the term Table under Database
A table is a collection of related data organized in rows and columns in a database. Each row is a record and each column is a field.
2. Define Query
A query is a database object used to ask a question in a database, based on given criteria.
3. Explain the purpose of Forms in a Database
Forms allow users to view, enter, and edit data in a structured and user-friendly interface within the database.
4. Explain the term Report
A report is a formatted and organized presentation of data from tables or queries, often used for printing or reviewing summaries.
5. Describe a dialog box
A dialog box is a pop-up window that prompts the user to enter information or select options in software applications like Access.
6. Explain Data Sheet View
Datasheet View displays the table data in rows and columns, allowing users to view and directly edit the records.
7. Differentiate between Append Query and Delete Query
Append Query adds new records to an existing table; Delete Query removes records that match specific criteria.
8. Describe Secondary Sort Key
A secondary sort key is used to sort records further within groups that have the same primary sort key value.
9. Describe Database Object
Database objects are the components used to store and manipulate data in a database, such as tables, queries, forms, and reports.
SECTION B – Practical (Microsoft Access)
Using Microsoft Access, perform the following database tasks:
| Employee ID | Pay Rate | Hours Worked |
|---|---|---|
| 015 | 1250 | 35 |
| 131 | 10.5 | 50 |
| 139 | 3.75 | 40 |
| 216 | 8.65 | 30 |
| 245 | 10.5 | 45 |
| 260 | 12.45 | 60 |
| 275 | 10.50 | 75 |
- Create a table named Employee and enter the data shown above.
- Add fields to calculate:
- Gross Pay = [Pay Rate] * [Hours Worked]
- Tax Pay = [Gross Pay] * 0.10
- Net Pay = [Gross Pay] - [Tax Pay]
- Create a query to calculate and display Gross Pay, Tax Pay, and Net Pay.
- Save the query with an appropriate name (e.g., SalaryQuery).
- Print the table and the query output.
