Lab 7
Database Management Systems (Access)
IT 231: IT and Applications (BBA) · 1 lab hour
Learning objectives
- Create tables with primary keys
- Enter sample data and run a select query
Task 1
Students and Enrolments tables with fictional data.
Task 2
Query FullName + Marks for IT231, sorted descending.
Task 3
Optional: simple data-entry form.
Deliverable
Database file + query datasheet screenshot.
Viva prompts
- What is a primary key?
- Why database over many Excel files?
- What does a query add beyond a table?
- Two DBMS functions besides storage?
End of Lab 7
Submit before you leave · ask questions now