This past question is developed to assist students in understanding the structure, concepts, and expectations of Database Management examinations, particularly for the Level Two category. The questions aim to guide students through essential terminologies, practical applications, and the usage of Microsoft Access to manage data effectively.
At Armstrong Computers, our mission is to bring ICT to your doorstep empowering students with the knowledge and tools needed to succeed in their digital careers. Whether you're at home, in class, or on the move, this blog offers accessible resources to help you study and grow. Remember, Armstrong Computers is where vision meets excellence.
SECTION A: THEORY (50 MARKS)
1. What is a Relational Database?
A relational database stores data in tables with rows and columns and allows relationships between tables through keys.
2. What is a Primary Key?
A unique field in a table used to identify each record uniquely.
3. What is a Secondary Key?
A non-unique field used for searching or sorting data.
4. Explain Column Width.
Column width determines how wide a column appears in a table, affecting data visibility.
5. Describe a Form in a Database System.
A form is a graphical interface in a database used to enter, view, and update data.
6. What is Design View?
A layout mode in MS Access used to design the structure of database tables or forms.
7. What is Print Preview?
A tool that shows how your document will appear when printed.
8. What is an Input Mask?
An input mask limits how data can be entered into a field (e.g., phone numbers).
9. What is Datasheet View?
It displays table data in a row-and-column format, allowing for easy data entry and viewing.
10. How do you insert a new field into a table?
Right-click in Datasheet View and select "Insert Field" to add a new column to your table.
SECTION B: PRACTICAL (50 MARKS)
Michelle's Catering Business – MS Access Project
- Open Microsoft Access and create a new blank database named Catering Business.
- Create a table named Customers with the following fields:
- ID – AutoNumber (Primary Key)
- Company – Short Text
- ContactAddress – Short Text
- PhoneNumber – Short Text
- Gender – Short Text
- FavoriteDish – Short Text
- Switch to Datasheet View and enter 25 sample records. The last record should contain your own name.
- Save the table and database.
- Print the table and then close the database.
