Practical Database Applications

Answers and Descriptions:

1. Answer: Set properties like “read-only” or “maximum length” to limit what users can enter or edit in a form.
   Description: A “Grade” field can be set to accept only numbers between 0-100, preventing invalid entries like “ABC.”
2. Answer: Use criteria “Age > 15” AND “Grade > 80” in the query tool, sorting by name.
   Description: This filters the database to show only high-performing older students, useful for identifying scholarship candidates.
3. Answer: In the wizard, select “Group By” and choose a field (e.g., “Class”) to organize data into sections.
   Description: Grouping by “Class” in a student report separates results by classroom, making it easier to analyze class performance.
4. Answer: Create a “Products” table (Product ID, Name, Stock) and a “Sales” table (Sale ID, Product ID, Date). Use forms for stock updates, queries to find low-stock items, and reports for monthly sales.
   Description: This system tracks stock levels, identifies reorder needs with queries (e.g., “Stock < 10"), and summarizes sales in reports.
5. Answer: Integrity ensures data accuracy and consistency (e.g., no duplicate records). It’s enforced in a DBMS with primary keys and relationship rules.
   Description: A primary key like “Order ID” prevents duplicate orders, and linking tables ensures a sale references a valid product, avoiding errors.