0% found this document useful (0 votes)
39 views61 pages

IT DigitalDocumentation

The document outlines a series of assignments related to digital documentation, electronic spreadsheets, and database management systems, detailing objectives, tasks, and solutions for each assignment. It includes practical exercises using LibreOffice Writer and Calc, focusing on skills such as creating styles, inserting images, consolidating data, and creating queries. Each section provides step-by-step instructions for completing the tasks effectively.

Uploaded by

ABHarikumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
39 views61 pages

IT DigitalDocumentation

The document outlines a series of assignments related to digital documentation, electronic spreadsheets, and database management systems, detailing objectives, tasks, and solutions for each assignment. It includes practical exercises using LibreOffice Writer and Calc, focusing on skills such as creating styles, inserting images, consolidating data, and creating queries. Each section provides step-by-step instructions for completing the tasks effectively.

Uploaded by

ABHarikumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 61

Name: Class:

Roll No: Exam No:


Institution

This is certified to be the bonafide work of the student in the

Laboratory during the academic year

20 / 20 .

No of practicals certified out of in the subject

of

Teacher In-charge

Examiner’s Signature Principal

Date: ------------------- Institution Rubber Stamp


S.NO LIST OF ASSIGNMENTS PAGE NO

1 Unit 1: Digital Documentation (Advanced)-


1
Create and apply styles in digital document.

2 Working with Images in digital document.


4

3 Create and use template.


6

4 Create Table of Contents.


8

5 Customize Table of contents.


9

6 Unit 2: Electronic Spreadsheet


10
(Advanced)- Consolidating
Data.
7 Subtotal.
12

8 Creating cell referencing in Spreadsheet. 14

9 Hyperlink in Spreadsheet. 16

10 Goal Seek. 18

11 Unit 3:Database Management System 19


Create and edit tables using wizard.

12 Retrieve data using query. 21

13 Query Using Criterion and Sorting 29

14 Create Forms and Reports using wizard. 31

15 Create report using wizard 35


Learning Outcome - Create and apply styles in digital document
Assignment 1
Objective: Using various commands to create customer styles and apply predefined styles in
LibreOffice Writer.
Task: Type a paragraph with at least 100 words and create below given styles as instructed:
1. Title
a. Font Name: Kristen ITC, Size:28, Colour: Magenta
b. Give Style Name: Title AI (Use create styles using drag and drop)
2. Headings
a. Font name: Times New Roman, Size: 24 , Colour: Red.
b. Give the style name: My Heading (Use create style from selection command)
3. Paragraph and Headings - My heading styles to all headings using Fill Format
4. Load Styles in New Document and Save the document
Solution:
⇨ Preparing document
1. Click on Start > All Apps > LibreOffice 24.2 > LibreOffice Writer.
2. Type required text.
Creating styles
⇨ Title (Using Drag and Drop)
1. Select the title “Generative Artificial Intelligence”.
2. Apply the desired formatting.
3. Now click on Styles > Manage Styles option.
4. Select the title “Generative Artificial Intelligence” and darg over the Styles pane present
on the screen.
5. New Style From Selection dialog box will appear with a prompt to enter New
Style Name. Type name as “Title AI”.
6. Click on OK button.
⇨ Headings (Create Style using New Style from Selection option)
1. Select first heading – “Introduction”.
2. Apply the desired formatting for style as per instructions given in the question.
3. Click on Styles > Manage Styles option. A styles pane will appear.
4. Click on Style Actions button and choose New Style From Selection option.
5. New Style from Selection dialog box appears. Type Style name as – “My Heading”.
6. Click on OK.
⇨ Applying Styles
⮚ Using double click
1. Select the heading “Technology”.
2. Now Find the newly created styles “My Heading”.
3. Double Click on it.
⮚ Using Fill Format
1. Click on Fill Format icon on Styles pane.
2. A fill format mode will be activated and mouse cursor changes to Fill Format mode icon.
3. Select “My Heading” style from Styles pane.
4. Drag it over to the headings to apply “My Heading” style.
5. Save the file as “Practical 1 – Create and apply styles”.
⇨ Load styles
1. Open new blank document.
2. Activate Styles pane from side bar or any other option.
3. Click on Style Actions button and choose “Load Styles from Template”.
4. Find the button From File and click on it.
5. Choose the previously saved file.
6. Click on Open button.
7. The styles from selected document will be added into the Style gallery.
8. Save the file.
Output Document:
Learning Outcome – Working with Images in digital document
Assignment 2
Objective: Inserting images and shapes and rearranging them
Task: Create a new document in LibreOffice prepare an advertisement using various shapes
and images.

Solution:
Add Page background
1. Open LibreOffice Writer and Background from Format > Page Style > Area > Gradient.
2. Choose Sundown gradient for page background and Click on Apply and OK.
Add Page border
1. Click on Format > Page Style > Borders.
2. Click on All four borders option.
3. Choose the line style from Style.
4. Click on Apply and OK button.
Add font work (Learn Coding)
1. Click on View > Toolbar > Drawing.
2. Click on Insert Font Text icon from the Drawing Toolbar.
3. Select Gold Wave style.
4. Type the text Learn Coding and change color.
5. Press enter when you finished.
Add font work (For 3 to 12 Class Students)
1. Click on Insert Font Text icon from the Drawing Toolbar.
2. Select relevant style for Font Text.
3. Type the desired text and change the color.
4. Press enter when you finished.
Insert Image
1. Place the cursor where image is required.
2. Click Insert > Image option. An Insert Image dialog box will appear.
3. Select the image from the dialog box.
4. Click on open button.
Applying border to image
1. Select an image to apply border.
2. Click on Borders icon on the Image toolbar and select Outer Border (Only).
Add Textbox to insert courses
1. Select rectangle box from Drawing toolbar.
2. Draw the rectangle in the document.
Applying background colour to box
1. Select the box.
2. Choose the Fill Colour icon from drawing properties toolbar.
3. Select Yellow color from the Fill Colour icon.
4. Add the desired text.
Similarly add remaining shapes, apply the desired formatting and text. Save the file.
Output:
Learning Outcome - Create and use template
Assignment 3
Objective: Creating templates in LibreOffice Writer and saving for distribution.
Task:
• Prepare a template for the class time table.
• Apply formatting as required.
• Set this template as a default template.
• Reset the default template as usual.

Solution:
1. Create a new document in LibreOffice Writer.
2. Click on Format > Page Style option.
3. A page style dialog box will appear.
4. Select Area > Image > Add/Import option.
5. Apply desired options for background and click on OK button.
6. Insert table for time table and format it as per your choice.
Saving file as template
1. Click on File > Templates > Save as Template option.
2. A Save As Template dialog box will appear.
3. “Time Table ” as Template Name in Enter Template Name dialog box.
4. Select Template Category as MyTemplate.
5. Click on Set as default template option.
6. Click on Save button.
Reset default template
1. Click on File > Templates > Manage Templates option.
2. A manage template dialog box will appear.
3. Click on Manage > Reset Default Text Document option.
4. Click on Close button.
Output
Learning Outcome – Create Table of Contents
Assignment 4

Objective: Create and Customize Table of Contents


Task: Prepare a document with different headings and apply a table of contents to it.

Solution:
1. Type the contents.
2. Apply appropriate level of headings from the Styles window.
3. Place the cursor at the beginning of document to insert Table of Content.
4. Click on Insert → Table of contents and index → Table of contents, index or Bibliography
option. The Table of contents, index or Bibliography will appear.
5. Select and apply the styles for the Table of Contents.

3. Click on OK.
Output
Learning Outcome – Customize Table of contents
Assignment 5

Objective: Customize the table of contents


Task: Apply customization following customization on above Table of contents:
1. Apply heading levels up to 3
2. Divide Table of contents into two parts vertically
3. Add a background colour of your choice

Solution:
1. Select the Table of Contents created in previous question.
2. Select Type tab.
3. Find the option include level upto and select 3.
4. Click on Columns tab.
5. Set 2 in the Columns.
6. Click on Background tab.
7. Click on Colour button.
8. Pick the desired colour to apply as background.
9. Click on OK button.
Output:
Learning Outcome Consolidating Data
Assignment 1

Objective: Applying Data Consolidation in LibreOffice Calc


Task: Prepare 3 worksheets for products sales and consolidate them

Solution:
Preparing sheets for Data Consolidation
1. Create a new file in spreadsheet software and enter data for 5 products.
2. Add two worksheets in the file and modify the data for all. Click on Sheet tab and + icon there,
3. Rename all worksheets like sheet1 - Ahmedabad, sheet2 - Surat and sheet3 - Rajkot. Select
the sheets respectively and do right click on Sheet tab > Rename Sheet option, Type the sheet
name and Click on OK button.
4. Now add one more worksheet at the end and rename as Consolidated as similar as step 2 and 3.
Perform Data Consolidation
1. Place the cursor in cell B2 in Consolidated sheet.
2. Click on Data > Consolidate option.
3. The Consolidate dialog box will appear.
4. Choose the Sum function.
5. Select Data Source ranges respectively and click on Add button.
6. Click on OK button.
Output:
Learning Outcome Subtotal
Assignment 2
Objective: Applying subtotal in LibreOffice Calc
Task: Prepare a worksheet as following

Apply subtotal and find the sum of days required for project name.
Solution:

1. Open spreadsheet software and enter the data.


2. Select the data.
3. Click on Data → Subtotal. The Subtotal dialog box appears.
4. Select column Project Name in Group By option.
5. Now mark the column to Days Required to count the no. of days required for each project.
6. Select the sum function sum from Use Function option.
7. Click on OK button.

12
Output:
e
Learning Outcome – Creating cell referencing in Spreadsheet
Assignment 3

Objective: Link data and Spreadsheet


Task: Prepare a worksheets as following:
1. Enter the data such as Roll no, GR NO, First Name, Last Name, Date of Birth,
Father Name, Mother Name. Enter records for at least 10 students.
2. Rename this worksheet as "Student Profile".
3. Insert 3 new worksheets and rename as "PT2", "PT2" and "PT3" respectively.
4. In the PT1 worksheet create a reference for Roll No, First Name, and Last Name
columns from Student Profile by using the keyboard.
5. In the PT2 worksheet create a reference for Roll No, First Name, and Last Name
columns from Student Profile by using the mouse.
6. In the PT3 worksheet create a reference for Roll No, First Name, and Last Name
columns from Student Profile as you wish.

Solution:
1. Open Excel and create a new workbook.
2. In the first worksheet, enter the data.
3. Right-click on the sheet tab (usually named “Sheet1”).
4. Select “Rename” and change the name to “Student Profile”.
5. Insert three new worksheets by clicking the “+” icon at the bottom.
6. Rename them to “PT1”, “PT2”, and “PT3” respectively.
7. Go to the “PT1” worksheet.
8. In cell A1, type =Student Profile!A1 to reference the Roll No from the “Student Profile” sheet.
9. Drag the fill handle to copy the formula down for all 10 students.
10. Repeat the process for First Name and Last Name columns.
11. Go to the “PT2” worksheet.
12. Click on cell A1, type =, then navigate to the “Student Profile” sheet and click on cell A1.
13. Press Enter to create the reference.
14. Drag the fill handle to copy the formula down for all 10 students.
15. Repeat the process for First Name and Last Name columns.
16. Go to the “PT3” worksheet.
17. You can use either the keyboard or mouse method to create references for Roll No, First
Name, and Last Name columns from the “Student Profile” sheet.
Output:
Learning Outcome – Hyperlink in Spreadsheet
Assignment 4
Task:
1. Insert hyperlink from the internet.
2. Insert hyperlink email.
3. Insert hyperlink of existing file.
4. Insert hyperlink of new file.
Insert Hyperlink from the internet
1. Type the text – NCERT Solution IT Class 10.
2. Click on Insert > Hyperlink option. Hyperlink dialog box will open.
3. Click on Internet and type the URL.
4. Set the behaviour of link by selecting frame and target.
5. Click on OK button.
Insert Hyperlink Email
1. Type the text – Gmail in the cell.
2. Click on Insert > Hyperlink option.
3. Select Mail option.
4. Type the recipient mail id in Recipient box.
5. Type Subject in Subject box.
6. Set the behaviour of link by selecting Frame, Target and Name.
7. Click on Apply and OK button.
Insert hyperlink of existing file
1. Type the text: File – Document
2. Click on Insert > Hyperlink option.
3. Choose Document button.
4. Select the file from Path option. Either type the path or select the file using browse button.
5. Set target of link.
6. Apply settings required such as Frame, Name and Text.
7. Click on Apply and OK button.
Inserting Hyperlink of New Document
1. Type the Text – New Document.
2. Select option as Edit Now.
3. Type Filename in File box.
4. Select File Type as Text Document.
5. Apply settings such as Frame, Name etc.
6. Click Apply and OK button.
Output:
Learning Outcome – Goal Seek
Assignment 5
Objective: Goal seek Application
Task: Enter data to obtain total net profit and set the goal to achieve total net profit of ⮚ 23,000
by changing the August month gross profit.

Sample Data:
Month Gross Profit Net
April 20000 12% 2400
May 30000 14% 4200
June 40000 11% 4400
July 25000 15% 3750
August 35000 18% 6300
Total 21050
Solution:
1. Enter data and prepare the spreadsheet along with formula.
2. Place the cursor in D7 cell.
3. Click on Tools > Goal Seek option. The Goal Seek dialog box will appear.
4. Move the cursor in Target Value box and enter the value – 23000.
5. Now select the cell as a variable cell.
6. Click on OK.
7. It will display the value obtained by Goal seek. If you wish to insert it in the
spreadsheet click on Yes, otherwise No.
Output:
Learning Outcome – Create and edit tables using wizard
Assignment 1

Objective: Steps to create a table using table wizard


Task: Create a table using wizard and insert data.

Solution:
1. Click on Start → All Programs → LibreOffice 24.2 → LibreOffice Base. 24.2 LibreOffice
Base window will open with Database Wizard.
2. Click on Create a new database option.
3. Click on Next button.
4. Select the database Register option either Yes, or No.
5. Check on Open database for editing.
6. Click on Finish button.
7. It will prompt to save the database.
8. Type the desired name and save it. I have given db1.
9. Now click on Tables button from Left pane and choose the option - Use Wizard to Create
Table… from the tasks window.
10. The Table Wizard will open. Follow wizard steps to create a table.
11. In first step of wizard select the Category either Business or Personal,
12. Now choose a table from list of table. As I have selected Employees table.
13. Click on Next and select field types and all if you want to change it. Click on Next. I have
selected EmployeeID, Firstname, Lastname, Salary, Datehired.
14.Set a primary key for your table in this step. Click on Use an existing field as a Primary
Key. I have selected EmplyeeID as Primary key. Click on Next.
15.If you wish to change the table name then type new name for the table and click on Insert.
Data immediately, and click on Finish.
16. Enter data now.
Learning Outcome – Retrieve data using query
Assignment 2

Objective: Query creation using wizard


Task: Create table Marksheet (Using SQL Command) and perform the bellow given
queries using wizard and design view.

Field Name Data Type Size


Stud_No Integer 2
Name Text 15
RollNo Integer 3
Sub101 Decimal 3,2
Sub102 Decimal 3,2
Sub103 Decimal 3,2
1. In the Database file Add these Fields: (Total: Datatype- Number 3 digits, Percentage: Datatype
- Number 3 digits with 2 decimal places, Grade: Datatype- Char with 2 letters)
2. Insert more 3 records in MARKSHEET using SQL mode.
3. Display name, rollno, marks of 3 subjects, total and percentage using design view.
4. Display name, rollno, grades from the marksheet table using query wizard.
5. Display the maximum marks for Sub101 and minimum marks for Sub102 using design view.
6. Display the rollno, name and percentage whose percentage are more than 70 using design view.
7. Display all the record in ascending order of names using design view.
Solution:
create table “marksheet”
(“Stud_no” tinyint primary key,
“Name” varchar(15),
“RollNo” tinyint,
“Sub101” decimal(5,2),
“Sub102” decimal(5,2),
“Sub103” decimal(5,2)) ;
Output:

Queries

⇨ Add Columns

1. Click on Tools ⮚SQL option.

2. Add column Total → alter table "marksheet" add column "Total" tinyint

3. Add column Percentage → alter table "marksheet" add column "Percentage" decimal(5,2)

4. Add column grade → alter table "marksheet" add column "Grade" char(2)

5. Click on Execute button.

6. Click on Close button.


Output:
Command Screen

Table Preview
⇨ Insert records
1. Click on Tools > SQL option.
2. insert into "marksheet" values (101, 'Sagar', 105, 27, 25, 28, 80 , 88 , 'B1')
3. Click on Execute button.
4. Close the window.
5. Click on View > Refresh Tables option to update data into the table.
Output:
SQL Command:
Table Preview:

⇨ Steps to perform a query using design view


1. Click Queries → Create Query in Design View….
2. The query design window will open.
3. Select the marksheet table and click on Add button.
4. Now select fields given in the question like name, rollno, marks,Sub101, Sub102, Sub103,
Total and Percentage.
5. Save the query.
Output:
Query Result:

⇨ Query Wizard Steps


1. Click on Queries → Use Wizard to Create Query…

2. Query Wizard opens.


3. Select the table marksheet and select the fields given the question.

4. Click on finish.
⇨ Design View
⮚Display maximum marks and minimum marks for the fields given in the question, using
design view.
1. Click Queries → Create Query in Design View….
2. The query design window will open.
3. Select the marksheet table and click on Add button.
4. Now select the field Sub101 and Sub102.
5. Choose the function maximum under Sub101 and Minimum under Sub102.
6. Save the query and check the result.
Query Design:

Output:
Assignment 3 (Query using criterion and sorting)
⮚Display the rollno, name and percentage whose percentage are more than 70 using design
view
1. Click Queries → Create Query in Design View….
2. The query design window will open.
3. Select the marksheet table and click on Add button.
4. Select columns given in the question i.e. Rollno, Name and Percentage.
5. Type >70 in the front of criterion under the percentage field.
6. Save the query and check the result.
Query Design:

Output:
⮚Display all the record in ascending order of names using design view.
1. Click Queries → Create Query in Design View….
2. The query design window will open.
3. Select the marksheet table and click on Add button.
4. Select markesheet.* and name in the column list.
5. Select sort → ascending under name field.
6. Now click on Visible checkbox to hide the name column in result.
7. Save the query and check the result.
Query Design View

Output:
Learning Outcome – Create Forms and Reports using wizard
Assignment 4
Objective: Creating form using wizard
Task: Create table a form using wizard by selecting all the fields for the table - Marksheet

Solution
Steps to create a form using wizard
1. Click on Forms → Use Wizard to Create Form…

2. A Form Wizard appears.


3. Select the table from Tables or Queries then add all the fields.

4. Click on Next button. Ignore step 3 and step 4 from wizard.


5. Select the first option i.e. Columnar – Labels Left then click on the next button.
6. Now set data entry step will be there. Ignore this step and click on Next. Choose the styles for
the form interface and click on next.

7. Type new name for the form and click on work with the form. Click on Finish
Form Output:
Assignment 5

Solution
1. Click on Reports → Use Wizard to Create report. The report wizard will open in the
new window.

2. Select the table and add fields.


3. Now change the label text that you want in the report. I have changed the label
Stud_no into Adm. No. Click on Next.

4. I have skipped groping and sorting options by click on Next button.


5. Now choose the layout. I have selected Columnar, Single Column as Layout of Data,
Landscape Orientation and Click on Next.
6. Now type the title of the report and select dynamic report → Create report now option.

7. Now click on finish.


Output:
VELS GLOBAL SCHOOL
Branch:

PROJECT REPORT
ON
STUDENT’S RESULT MANAGEMENT
SYSTEM
(SESSION 2025 - 2026)

Submitted TO: Submitted By:


Subject Teacher Name: Name:
Designation Class: X
Roll No:
Subject: Information Technology (402)
Session: 2025-2026
This is to certify that the project entitled „STUDENT‟S
RESULT MANAGEMENT SYSTEM‟ is a Bonafide
work done by of Class – X,
Session 2025 -26 in the partial fulfilment of CBSE
AISSE Examination, 2024 and has been carried out
under my direct supervision and guidance.

……………………………………

Mr./MS. Name of the Subject Teacher


Designation
I would like to express my special thanks of gratitude to my teacher
Mr./Ms. as well as our principal
Mr. /Ms. , who gave me the golden
opportunity to do this wonderful project on the topic „STUDENT‟S
RESULT MANAGEMENT SYSTEM‟, which also helped me in doing
a lot of research and I came to know about so many new things I am
really thankful to them.

Secondly, I would also like to thank my parents and friends who helped
me a lot in finalizing this project within the limited time frame.

Last but not least, I would like to thank all those who had helped
(directly or indirectly) towards the completion of this project.

Class – X
INDEX
S.No Contents Page Teacher‟s

No. Signature

1. Introduction of the 1

project

2. Objectives of the project 2

3. Hardware and Software 3

Requirements

4. Steps in Creating a 4

Project
⮚Creating a Database
and Creating a Table 5
⮚Creating a Form 7
⮚Inserting Data in the
tables 8
⮚Creating the
Relationship 9
between Tables.
⮚Creating Queries 10
⮚Generating Reports 12
The impact of computers and internet, on our lives today is
probably much more than we really know. Getting information
and quickly turning it into a product that consumers want is the
essential key to staying in business and all of this is done
nowadays using computers and applications or information
systems. And the information systems will continue to change
businesses and the way we live. Many corporate leaders are
using technology to manage every aspect of their organization,
from product creation to customer service. It has brought
evolution in almost every field it changed the ways of teaching,
administration of activities such as e-learning, e-library and
online portals where teachers and students communicate, and
sharing of information has never been better.

Student result declaration and management are amongst the


most important activities within a school or any educational
institution, since all other activities depend on it. Hence
implementing an information system can be declared a
significance result.
LibreOffice Base Project: Student Result Management
System
The main objective of this research is to enhance and
automate the management and declaration of students‟ results
using a computerized system. It provides the examination result
to the student in a simple way. This project is useful for
institution for getting the results in simple manner.
Hardware:
Processor: Pentium R G2030 @ 4.70 GHz Processor
Speed: 533 MHZ
RAM: 2GB or more Hard
Disk: 2.00 GB
RAM: - 256 Mbytes RAM [512 MB RAM recommended]

Software:

At least 650 Mbytes available disk space for a default install [including a
JRE] via download. After installation and deletion of temporary
installation files,
OS: - Microsoft windows [Windows XP, Windows 2003, Windows
Vista, Windows 7, Windows 8*]
Libre Office will use approximately 440 Mbytes disk space. Libre
office.
MAIN COMPONENTS OF STUDENTS
MANAGEMENT SYSTEM
The student Result Management system will have the following

components.

⮚ Marks Table: - This table will store the result of the students of

each class.

⮚ Student’s _Details Table: - This table will store the address

and contact details of all the students of a school.

⮚ Relationship: - Both the tables (Marks_ Tables and student‟s

Details) will be linked to each other using Relationships.

⮚ Form: - Form is created to input the records in the table.

⮚ Query: - various types of Queries will be performed on the

table according to the requirements.

⮚ Report: - Report of each class will be generated.


Creating a Database

Creating Tables
Perform the steps for creating Marks_ Tab table.
Step 1: - Open STUDENTS_RESULT DATABASE by click on file menu open
option and locate STUDENTS_ RESULT. odb file.
Step 2: - Click on Tables tab, click on the create table in Design view option under
the Tasks pane.
Step 3: - A blank table opens in the Design View, type the field names and data
types as shown.
Step 4: - Set Admn _ No as primary key.
Step 5: - Click on save button from standard toolbar, save As dialog box will
open, save the table as Marks_ Table.
Perform the steps for Student _ Contact Table.
Step 1: - Open STUDENTS _ RESULT Database by click on file menu open
option and locate STUDENTS _ RESULT. odb file.
Step 2: - Click on Table tab Click on the Create table in Design View option
under the Task pane.
Step 3: - A blank table opens in the Design view, type the Field names and data
types as shown.
Step 4: - Set Admn _ No as primary key.
Step 5: - Click on save button from standard toolbar, Save As dialog box will
open, save the table as Student‟s Details table.
Creating a Form and Insert the records in a Table
Perform the steps for Creating a Form and Inserting Records in a Table.
Step 1: - Go to the Forms section in the database file.
Step 2: - Click create Form in Design view or use the Form Wizard to create a
form quickly.
● Select the table or query where the form will insert data.
● Add the required fields to the form.
Step 3: - Use the design tools to rearrange fields, add labels, and format the
form for easier input.
Step 4: - Save the form by giving it a meaningful name.
Step 5: - In the Form section, double – click the saved form to open it for
data entry.
Step 6: - Enter the data into the fields in form. Press Enter or click the Next
Record button to save the record and add another.
Step 7: - Repeat for all records, and then save and close the form.
Creating a Relationship between Tables
Perform the steps for create the Relationships between both tables.

Step1: - Click on the Relationships option in the Tools menu. Add Table dialog
box will appear.
Step 2: - Select the Marks _ Table and student‟s Details table.
Click on the Add button to add the tables one by one. Close the Add Table dialog
box after adding both the tables by clicking on the Close button on the Add Table
dialog box.
Step 3: - Drag the primary key field Admn _No from the Marks _ Table table to
similar field of Student‟s Details Table that is primary key field Admn _No of it.
Step 4: - A Relationship will be created.
Creating Queries
Perform the step s for create the Queries between both tables.

Step 1: - Click on the Queries option in the database pane and then click on the
create query in Design view option in the tasks pane.
Step 2: - The Add Tables or Query dialog box will appear. Ensure that Table tab is
selected by default on that.
Step 3: - Select both the tables.
Step 4: - Click on the Add button to add the tables. After adding close Add Tables
or query dialog box.
Displaying Records of those students who are in Class 9
Generating Reports
Perform the steps for create the Report
Step 1: - Click on the Report option in the database pane.
Step2: - Click on the use Wizard to create report option under the tasks pane.
The report wizard will appear.
Step 3: - Select desire query under the tables or queries option.
Step 4: - Select all the field in this step and specify the field labels in the next
step.
Step 5: - Click on the Next button to move on to the next step.
Step 6: - Specify a title for the report and click on the finish button. Step
7: - The report will be created and will appear.
● There seem to be issues using this app in Windows 10. It worked fine when

we used it on Windows 7, but after we upgraded the network with NEW

Win 10 computers, it takes a very long time to process commands.

● It will not allow any upgrades.

● Not the best solution for larger or complex documents.

● Doesn‟t integrate well with third-party software and applications.

● Not as good as MS Office for document sharing and collaboration.

● Project works smoothly with less volume of data, but once increase data it

will slow in process.

● Poor User Interface.

● Project Creation takes times.

Future Scope and Enhancement

● Listed limitations will overcomes in upcoming versions.

● Working on User Interface.

● Able to deal with large volume of data.

13

You might also like