Detailed Database Project Document
INTRODUCTION
A database is an organized collection of related data stored in a structured format so that
users can easily access, manage, update, and retrieve information. LibreOffice Base allows
users to create relational databases, design tables, build forms, run queries, and generate
reports.
CREATING TABLES USING DESIGN VIEW
Steps:
1. Open LibreOffice Base → Create new database → Save.
2. Go to Tables → Create Table in Design View.
3. Enter field names (Student_ID, Student_Name, Class, Contact_Number, Address,
Date_of_Birth).
4. Assign field types (Text, Integer, Date, etc.).
5. Set field properties (length, default value, input required).
6. Set a Primary Key by right-clicking Student_ID.
7. Save the table name as Student_Info.
8. Verify table by entering sample data.
9. Modify structure if needed.
FORMS
Steps:
1. Go to Forms → Use Wizard to Create Form.
2. Select table (Student_Info).
3. Choose fields to include.
4. Select layout (Columnar, Tabular, Block).
5. Allow adding, editing, deleting records.
6. Add subforms if needed.
7. Choose styles and layout spacing.
8. Save as Student_Entry_Form.
9. Edit form to add dropdowns, date pickers, buttons.
QUERIES
Steps:
1. Go to Queries → Use Wizard to Create Query.
2. Select table(s) and fields.
3. Set conditions (Class = '10', DOB > 2010).
4. Use AND/OR logic.
5. Sort results.
6. Group data if needed.
7. Choose output style.
8. Save query (Class10_Students_Query).
9. Run the query to view filtered data.
Examples:
• SELECT * FROM Student_Info WHERE Class = '12';
• SELECT Student_Name, Date_of_Birth FROM Student_Info WHERE Date_of_Birth >
'2010-01-01';
REPORTS
Steps:
1. Go to Reports → Use Wizard to Create Report.
2. Select table/query.
3. Choose fields.
4. Group data (by Class).
5. Sort results.
6. Select layout and style.
7. Add titles, headers, and page numbers.
8. Preview report.
9. Save as Student_Details_Report.
10. Export as PDF if required.
CONCLUSION
LibreOffice Base is a powerful tool for building relational databases with tables, forms,
queries, and reports. Following these steps ensures efficient and accurate data
management.