This past question from Armstrong Computers College has been specially designed to help students better understand the type of questions asked in Database Management for Level Two. The interactive format allows you to click on each question to reveal the answer instantly.
Our enhanced solution guide provides clear explanations for both theoretical concepts and practical tasks in MS Access. Whether you're preparing for exams or looking to strengthen your database skills, this resource offers valuable practice material.
Note: The downloadable PDF version contains only the questions – the answers are exclusively available on this interactive webpage.
Get the complete question paper for offline practice
THEORY QUESTIONS
A combo box is a drop-down list that allows users to select from a list or enter a new value. It can be found in a form object.
1. Open MS Access
2. Click on 'Create' tab
3. Choose 'Table Design'
4. Enter field names and data types
5. Save the table with a name
DBMS stands for Database Management System. It is software used to create, manage, and manipulate databases.
Auto Report is a feature in MS Access that automatically generates a basic report from a selected table or query.
An entity is an object or concept about which data is stored. Example: A student in a school database.
The table on the "one" side is called the Primary table. The table on the "many" side is called the Related table.
By creating a relationship using a common field (usually primary key and foreign key) between the two tables.
Select the column → Click on the 'Home' tab → Choose 'Sort Descending' from the Sort & Filter group.
Query Wizard helps users create queries easily by guiding them through a step-by-step process to select fields, set criteria, and define output.
Database View (Datasheet View): Used to view and enter data.
Design View: Used to define or modify table structure (fields, data types, etc.).
SECTION B – PRACTICALS
- Create a blank database and name it Address Book
- Create a table with the fields:
- FirstName
- LastName
- Address
- City
- State
- Postal Code
- Home Phone Number
- Enter 10 records of your own into the table
- Create a form using the table info and add 5 more records
- Create a query to extract the 5 records added from the form
- Save and print the query result and full table records
Practical Exam Tip: When performing database practical tasks, work methodically and save your work frequently. Practice these MS Access operations multiple times to build confidence and speed for your exam.
Get the complete question paper for offline practice
