Access scheme

Microsoft Access.

Topic	Tool	What We Use the Tool For	Practical
What is Microsoft Access?	Microsoft Access	To create, manage, and organize databases efficiently.	Open Microsoft Access and create a new blank database.
Microsoft Access Interface	Microsoft Access	To learn the Ribbon, Navigation Pane, Tables, Queries, Forms, and Reports.	Identify and explain the main parts of the Access interface.
Creating and Saving a Database	Microsoft Access	To create and manage database files.	Create and save a new database.
Tables	Microsoft Access	To store and organize data in rows and columns.	Create a Student Information table.
Fields and Data Types	Microsoft Access	To define the type of data each field can store.	Create fields using Text, Number, Date, Currency, and Yes/No data types.
Primary Keys	Microsoft Access	To uniquely identify every record in a table.	Create a primary key for a student table.
Entering and Editing Records	Microsoft Access	To add, update, and delete database records.	Enter 20 student records into a table.
Relationships	Microsoft Access	To connect multiple tables and reduce duplicate data.	Create a relationship between Students and Courses tables.
Queries	Microsoft Access	To search, filter, and retrieve specific information from a database.	Create a query to display students who scored above 70%.
Query Criteria	Microsoft Access	To filter records using conditions.	Create queries using AND, OR, Greater Than, and Less Than criteria.
Forms	Microsoft Access	To make data entry easier and more user-friendly.	Design a student registration form.
Form Controls	Microsoft Access	To add buttons, text boxes, combo boxes, and labels to forms.	Create a navigation form with command buttons.
Reports	Microsoft Access	To generate professional reports from database records.	Create a student results report.
Sorting and Filtering	Microsoft Access	To organize and locate records quickly.	Sort students by surname and filter by department.
Validation Rules	Microsoft Access	To prevent incorrect data entry.	Create a rule that allows only ages between 16 and 60.
Importing and Exporting Data	Microsoft Access	To exchange data with Excel, CSV, and other applications.	Import an Excel file into Access and export a report as PDF.
Database Security	Microsoft Access	To protect database files and control access.	Encrypt a database and set a password.
Database Backup and Recovery	Microsoft Access	To protect databases against accidental data loss.	Create a backup and restore a database.
Creating a Switchboard or Navigation Form	Microsoft Access	To make database navigation easier for users.	Create a menu that opens Forms, Reports, and Queries.
Database Maintenance	Microsoft Access	To improve database performance and fix database issues.	Compact and Repair a database.
Final Microsoft Access Project	Microsoft Access	To apply all database skills in one complete project.	Design a complete Student Management System with tables, relationships, forms, queries, reports, validation rules, navigation menu, and database security.