11th Class (HSSC-I) Computer SLO Based Key Point Notes

(National Book Foundation - As Federal Textbook Board, Islamabad 
Based on National Curriculum Pakistan 2023-2024 and Onward prescribed by Federal Board of Intermediate and Secondary Education, Islamabad, and All Pakistan Boards) 
(Contact WhatsApp # 03339719149 for a full book PDF Notes)

Unit 8:  Database Development 



Q1. Where is the Microsoft Office Button Located? Write the tasks performed by using the Microsoft Office Button?

Ans: 

Microsoft Office Button is located in the top left corner of the Access window. It is clicked to perform tasks such as Saving, Opening, New file creation, printing, etc.

Q2. Describe various ways of deleting records in a table?

Ans: 

Records can be deleted from a table using various ways i.e. directly in a table or using a delete query. After selecting the entire Row, the Record can be deleted by any of the following steps:
● Press the “Delete” Key from the Keyboard
● Right Click and use the “Delete” option from Pop-Up Menu
● Press the Delete Shortcut Icon from the Record group in the Home Tab

Q3. What are the advantages of using forms?

Ans: 

● Forms are user-friendly and do not require technical knowledge by the user.
● Forms are easy to use and are flexible.
●Forms are Graphical User Interface, different operations can be performed quickly.
● Advanced data types like Graphics, Audio, and Video can be displayed using Forms.

Q4. What is meant by referential integrity?

Ans: 

Referential Integrity is an important feature of MS Access, it prevents deleting and modifying values of records in the Primary table on which related records depend. It saves the database from becoming inconsistent.

Q5. Describe how records can be added and deleted using forms

Ans: 

Adding: Records can be added while using forms simply by using  the * button from the Navigation toolbar at the bottom of the form. Or click the “New” option from the Record group in the Home tab.

Deleting: Records can be deleted by clicking the “Delete” option from the Record group in the Home tab. Record once deleted cannot be reversed.

Q6. Describe columnar, tabular, and datasheet layouts of forms

Ans: 
● Columnar Form: Columnar form is the type of form that can display only one record at a time. All the fields are arranged vertically.
● Tabular Form: Tabular form is the type of form that can display multiple records at a time arranged in rows and columns.

Q7. What is the use of Query Design Grid?

Ans: 

A query design grid is used to create customized queries. It can be used to apply criteria on fields to search records and to create calculated fields.

Q8. What is OpenOffice Base

Ans: 

OpenOffice Base is an open-source Database Management System. It allows users to create and use databases and import data from other programs.

Q9. Define the query and its types.

Ans: 

A query is a short database command used to retrieve data from the database. These can be called the questions which are asked from the database and database replies in an answer table. The following are the types of queries:

Select Query: Select query is used to display selected records from one or more tables.
Update Query: The update query is used to change, add, or delete data in existing records.
Delete Query: Delete query is used to delete entire records from tables along with the primary keys.
Append Query: Append query is used to append the records of one table to the end of another table.
Make Table Query: Make table query is used to create a new table in a database.

Q10. Differentiate between update and append query.

Ans: 

Update Query

Append Query

Update Query is used to creating or edit a set of record

Append query is used to add the records of one table to the end of another table.

It can be applied to two or more tables at a time

It can be applied only on two tables

It cannot create new records but works on existing records

It can add new records in a table that have been imported from another table



Q11. Differentiate between columnar and tabular reports.

Ans: 

Columnar Form

Tabular Form

Columnar Form displays one record at a time

The tabular form displays multiple records at a time

Records are displayed in column

Records are displayed in a row

Fewer graphical controls are used in it

More graphical controls are used in it



Q12. Explain the following database objects.

Ans: 

Table: The table is the collection of rows and columns to hold data of specific subjects. It is the most important object of the database which is used first before any other object is used.
Form: A form is a database object that serves as the interface between the user and the database. It is a graphical user interface that allows even a non-technical user to interact with the database.
Query: Query is a short database command used to retrieve data from the database. These can be called the questions which are asked from the database and database replies in an answer table.
Report: A report is the output of a database based on a query or table. It is not editable and can be produced in hard copy.

Q13. Explain all the field data types used in MS ACCESS.

Ans: 

Text: Text is used to display short text in a field. It can support up to 255 characters.
Memo: Memo is used to display longer text in a field. It can support up to 65,535 characters.
Auto-number: Auto-number is used to generate a unique number which is normally in sequence.
It is generally used in primary keys.
Number: A number is used to save numeric values which can either be integer or real in nature.
Currency: Currency is used to store numeric values showing currency. Currency is displayed with a specific currency symbol e.g. $ or Rs. And its numeric part is not rounded off.
Date and Time: Date and Time are used to display date and time data.
Boolean Yes/No: Boolean Yes/No is used to process Boolean data in the form of option YES or NO. Yes is represented by -1 and No is by 0.

Q14. Differentiate between Form and Report.

Ans: 

FORM

REPORT

The form is an interface to the database

The report is the output of the database

Form exists logically on screen

Report exists physically

Form is editable

The report is not editable

The form can show advanced data types like audio and video

The report cannot support audio and video



************************************

************************************

Shortcut Links For 


1. Website for School and College Level Physics   
2. Website for School and College Level Mathematics  
3. Website for Single National Curriculum Pakistan - All Subjects Notes 

© 2023 Academic Skills and Knowledge (ASK)     

Note:  Write to me in the comments box below for any query and also Share this information with your class-fellows and friends.