Computer Science Study Guide: IT Tools and Business Systems Chapter 07 Database Notes Set 01
Explore structured advanced study materials through the IT Tools and Business Systems Chapter 07 Database Notes Set 01. Tailored for learners, utilizing these Computer Science resources ensures thorough preparation and strengthens foundational knowledge before final evaluations.
Download Database Study Material PDF
Access the complete useful resource PDF for Computer Science below. Regular practice with these targeted academic notes builds familiarity with complex topics and helps secure higher marks in final school evaluations.
These notes introduce databases, DBMS and the relational model, then the three kinds of data integrity. They also cover Microsoft Access objects, creating and importing tables, dropping fields, records and tables, and building queries, forms and reports step by step.
Objectives
At the end of the chapter the user will be able to:
1. understand data manipulation concept in database.
2. know about the relational database.
3. understand the concept of integrity.
4. know the database operations such as creating, dropping and manipulating table structure.
5. understand the concept of manipulating data in query, forms and reports.
Introduction to Database
About Data
1. The term data can be defined as set of isolated and unrelated raw facts with an implicit meaning.
2. Data can be anything such as name of person, a number, images, sound etc.
About Database
1. A database is an organized collection of related data from which user can efficiently retrieve the desired information.
2. Traditional databases are organized by fields, records and files. A field is a single piece of information. A record is one complete set of fields and a file is a collection of records.
3. In addition to the storage and retrieval of data, certain other operations can be performed on a database and the operations include addition, alteration, updating and deletion of data.
4. It is back-end of an application.
About Database Management System (DBMS)
1. A Database Management System (DBMS) is an integrated set of programs used to create and maintain a database.
2. The operations such as adding, updating and deleting data on a database are performed using Database Management System (DBMS).
3. The main objective of DBMS is to provide a convenient and effective method of defining, storing, retrieving and manipulating data contained in the database.
4. The database and the DBMS software are collectively known as database system.
5. Database Management Systems (DBMSs) are especially designed for software applications that interact with the user and other applications.
6. Examples of DBMS are Microsoft Access, SQL Server, MySQL etc.
Relational Database
1. A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables.
2. The relational database was invented by E. F. Codd at IBM in 1970.
3. The standard user and application program interface to a relational database is the structured query language (SQL).
4. SQL statements are used for both interactive queries for information from a relational database and for gathering data for reports.
5. A relational database is a set of tables containing data fitted into predefined categories.
6. Each table (which is sometimes called a relation) contains one or more data categories in columns. Each row contains a unique instance of data for the categories defined by the columns.
The following intuitive correspondence can be made:
1. A relation is a file.
2. Each file contains only one record type.
3. The records have no particular order.
4. Every field is single-valued.
5. The records have a unique identifying field or composite field, called the primary key field.
1. With a relational database, user can quickly compare information because of the arrangement of data in columns.
2. The relational database model takes advantage of this uniformity to build completely new tables out of required information from existing tables.
3. In other words, it uses the relationship of similar data to increase the speed and versatility of the database.
Integrity
1. Data integrity refers to the overall completeness, accuracy and consistency of data.
2. The concept of data integrity ensures that all data in a database can be traced and connected to other data which ensures that the data is recoverable and searchable.
Types of Integrity
There are three types of integrity: 1. Entity Integrity, 2. Referential Integrity, 3. Domain Integrity.
Entity Integrity
1. The Entity Integrity states that in a base relation, primary key column values cannot be null. (Null values are defined as "empty or containing no values").
2. A primary key is a minimal identifier that is used to identify rows uniquely.
3. A DBMS product such as Microsoft Access automatically enforces entity integrity by prohibiting null values in the primary key fields.
Referential Integrity
The referential integrity states that, if R2 (Child table) includes a foreign key FK matching the primary key PK of some R1 (Parent table) then every value of FK in R2 must either:
1. be equal to the value of PK in some rows of R1, or
2. be wholly null, i.e. each column in that FK must be null.
For example, when adding a new row to a table containing FK, the table containing the referenced PK must have matching values.
Domain Integrity
Domain integrity states that the values in a table are legal according to the physical and the logical domain definition. For instance, the StudentID column domain might be:
Physical : data type "numeric" ; Length "4 characters"
Logical : "The range of the number between 1000 and 4999"
Therefore, the field would only accept input of four-digit number between 1000 and 4999.
What is Microsoft Access?
1. Microsoft Access is a database software package.
2. A database is an organized collection of records. Example for paper database are telephone and address book.
3. With MS-Access, user can create a computerized database. After creation of MS-Access database, user can search it, manipulate it and extract information from it.
Working with MS-Access
1. Open Microsoft Access 2010, click on Sample Templates. The Northwind icon appears in the center of the window.
2. Click the Northwind icon.
3. Click the Browse button. The File New Database dialog box appears.
4. Locate the folder in which user wants to save the Northwind database.
5. Click OK. The File New Database window closes.
6. Click Create. MS-Access creates the Northwind database and opens it.
7. It shows the warning message to open the database in trusted location. To enable database click the Enable Content button.
8. MS-Access enables the content. If user enables the Northwind database, the Login dialog box appears.
9. Click Login. MS-Access opens the Northwind database.
The Navigation Pane
The MS-Access database consists of the following objects: 1. Tables, 2. Queries, 3. Forms, 4. Reports, 5. Macros, 6. Modules. The Navigation pane displays these objects in a database.
Creation of Database and Table
Creation of Database
1. A blank database is a database with nothing in it. User must create all the tables, forms, reports, queries and so on.
2. If user cannot find a template that suits their needs, they can create a blank database.
3. Creating tables is the first step in building a database.
Follow these steps to create a blank database:
1. Start MS-Access, click Blank Database.
2. Type the database name in the File Name field. MS-Access will automatically append .accdb to the name.
3. Click the Browse button. The File New Database window appears.
4. Locate the folder in where user wants to store the database.
5. Click OK, then click Create button.
6. MS-Access creates the database and opens a datasheet with the Table Tools available.
Creation of Tables
1. Tables are the foundation of an MS-Access database.
2. MS-Access stores data in tables. A table is a set of columns and rows. Each column is called field and each row is called record.
3. Each field must be given a name and no two fields can have the same name.
4. Each value in a field represents a single category of data.
5. Each row is called record.
Follow the steps to add fields to a table:
1. Click in the 'Click to Add' text box, it shows drop down list, select any data type from the list.
2. Type the next field name, MS-Access creates the field. User can continue this process until all the fields in the table are created.
3. Press Enter without entering a field name to end their entries.
Follow the steps to name and save a table:
1. Click the Save button on the Quick Access toolbar. The Save As dialog box appears.
2. Type the name of the table.
3. Then click OK.
Follow the steps to use Design view to create a new table:
1. Activate the Create tab.
2. Click Table Design in the Tables group. MS-Access changes to Design view and the Table Tools become available.
3. Type the first field name in the Field Name field.
4. Press the Tab key.
5. Click the down-arrow that appears when user click in the Data Type field and then select a data type.
6. Click Primary Key option if the created column is primary key. A small key appears next to the field name.
Manipulating Table Structure
After creation of MS-Access table user can modify it, enter data into it manually or import data from different application such as Excel. To manipulate table structure user can:
1. Enter records into the table
2. Modify a table
3. Select columns and rows
4. Delete a record
5. Resize a column or row
6. Import a table into MS-Access from Excel
Enter Records
To enter data into an AutoNumber field: Press the Tab key when the user makes an entry into another field in the record, MS-Access will automatically make an entry into the AutoNumber field.
To enter data into fields that have a lookup list: 1. Click the down-arrow that appears when user click in the field. 2. Click to select the entry that user want. 3. Press the Tab key.
To enter data into Yes/No field: Click the checkbox for Yes, then leave the checkbox for No.
To enter data into a date field: Type the date. Or select the date from the calendar that appears to the left of the field. Use the left-arrow at the top of the calendar to move to the previous month. Use the right-arrow at the top of the calendar to move to the next month. When user reaches the proper month, click the proper date.
Modify a Table
To insert column (the insert option inserts a column before the selected column): 1. Click the column head of the column before which user wants to insert a column. 2. Right-click the column head. A menu appears. 3. Click Insert Field.
To move a column (user can use Move option to move a column from one place to another): 1. Move mouse pointer over the horizontal line under the column label. Users mouse pointer turns into a four sided arrow. 2. Press left mouse button. 3. Click and drag the field to the new location. A dark line appears at the new location. 4. Release left mouse button. MS-Access moves the column.
To delete columns (the Delete option permanently deletes columns and all the data contained in them; user cannot undo a column after deleting): 1. Right-click the column head that user wants to delete. A menu appears. 2. Click Delete Field. 3. A warning dialog box will appear because delete option permanently deletes the records. Click Yes to delete.
Select Columns and Rows
1. To perform any operation on a column or row user must select it.
2. To select a column, click the column head.
3. To select several columns, click a column head and then drag.
4. To select a row, click the blank area to the left of the row.
5. To select several rows, click the blank area to the left of a row and then drag.
6. To select the entire table, click the Select All button in the upper-left corner of the table.
Delete a Record
1. Select the record that user wants to delete.
2. Activate the Home tab.
3. Click Delete in the Records group. Or click Delete option from right-click. A prompt appears.
4. Click the Yes button.
Resize a Column or Row
User can make the column or row larger or smaller, if the information in a column or row does not display or want to fit more information on the screen. User can click and drag to increase or decrease column width or row height. To resize a column or row:
1. Place the cursor over the line that separates two columns or two rows. The cursor turns into a double-sided arrow.
2. Hold down the left mouse button and drag to increase or decrease width of a column or the height of all of the rows.
Import a Table into MS-Access from MS-Excel
User can import data from Excel into MS-Access by using the Excel Spreadsheet Wizard. To import data from Excel:
1. Activate the External Data tab.
2. Click the Excel button in the Import group. The Get External Data - Excel Spreadsheet Wizard appears.
3. Click the Browse button, the File Open window appears.
4. Locate the spreadsheet that user want to import.
5. Click the Open button. The path to the selected file appears in the File Name field.
6. Click OK. MS-Access moves to the next page.
7. Select Show Worksheets to import a worksheet or select Show Named Ranges to import a named range.
8. Click the worksheet or named range that user wants to import.
9. Click Next. MS-Access moves to the next page.
10. Select First Row Contains Column Headings if the first row of user's Excel spreadsheet contains column headings.
11. Click Next. MS-Access moves to the next page.
12. Click a column heading to select a column. Type the MS-Access table's column heading in the Field Name field. Choose a Data type. Indicate if the field should be indexed and if so, select the type of index. Check the Do Not Import Field box for any column that user do not want to import.
13. Click Next. MS-Access moves to the next page.
14. Click to choose the proper radio button: if user wants MS-Access to add the primary key, click Let MS-Access add Primary key option; if user want to add the primary key, click Choose My Own Primary Key and then click the down-arrow and select the field that user want to use as the key; if user do not want to add a primary key, click No Primary Key option.
15. Click Next. MS-Access moves to the next page.
16. Type the name of the imported table.
17. Click Finish. MS-Access moves to the next page.
18. Finally click Close to import the table. Now MS-Access imports the Excel worksheet into the Access table.
Dropping
Delete a Field in Datasheet View
1. In the Navigation Pane, double-click the table from which you want to delete the field. The table is opened in Datasheet view.
2. Select the field (the column) that user want to delete.
3. Press Delete Field option from right click. Or on the Fields tab, in the Add & Delete group, click Delete button. Then click Yes to delete the column permanently.
Delete a Record in Datasheet View
1. Same method need to be followed to delete a record in datasheet view.
2. Select the record (the row) that user want to delete.
3. Press Delete Record option from right click. Or press DELETE key. Then click Yes to delete the record permanently.
Delete a Table
1. If the tables that participate in the table relationship are open, close them. User cannot delete a table relationship between open tables.
2. Then right click over the table name in the navigation pane and click Delete option.
3. Click Yes in the warning dialog box to delete a table.
4. Thus MS-Access deletes that table permanently.
Query
1. User can use a query to view a subset of data or to answer questions about user data.
2. For example, if user wants to view a list of student names and email address, but user do not want to see addresses and other data, user can create a query that displays the student's first name, last name and email address only.
Open Tables or Queries in Query Design View
1. Activate the Create tab.
2. Click the Query Design button in the Queries group. The Show Table dialog box appears.
3. Activate the Tables tab if user wants to base their query on tables, activate the Queries tab if user want base their query on queries or activate the Both tab if user want to base their query on both tables and queries.
4. Click to choose the table or query on which user want to base their query.
5. Click Add. The table appears in the window.
6. Click to choose the next table or query on which user want to base their query. Continue clicking tables or queries until user have all the tables and queries they plan to use.
7. Click Close. MS-Access changes to Query Design view.
Display All Records and All Fields
In Query Design view, each table has an option that allows user to display all of the fields and all of the records in a table. This option appears on the field line on the drop-down menu as the table name followed by a period and an asterisk (tablename.*). To display all records and all fields:
1. Open a table or query in Query Design view.
2. Click the down-arrow in the first field on the Field row and then select the tablename.* option. The table name appears on the table line.
3. Click the Run button. MS-Access retrieves all of the fields and records for the table and displays them in Datasheet view.
Sort a Query
While creating a query, user can sort the rows that they retrieve in ascending or descending order by choosing the option of their need on the Sort row in Query Design view. Follow the steps to perform a sort:
1. Open a table or query in Query Design view.
2. Choose the field names to retrieve them.
3. Under the field click the down-arrow and then choose Ascending or Descending.
4. Click the Run button. MS-Access retrieves the selected columns and displays the rows in the order that user specified.
Save a Query
User can save and return a saved query at any time. To save a query:
1. Click the Save button on the Quick Access toolbar. Access saves the query unless it is saving for first time.
2. Type the name of the query in Save As dialog box.
3. Click OK. MS-Access saves the query. User can now open the query by using the Navigation pane.
Data Entry Forms
1. MS-Access forms are much like paper forms. User can use them to enter, edit, or display data.
2. They are based on tables. When using a form, user can choose the format, the arrangement, and which fields to display.
Using the Form Button
1. MS-Access can automatically create several types of forms.
2. For example, when user click the Form button on the Create tab, MS-Access places all fields in the selected table on a form.
3. If the table has a one-to-many relationship with other table or query, MS-Access creates a stacked form (the records are displayed in a column) for the primary table and a datasheet for the related table.
4. If there are several tables with a one-to-many relationship, MS-Access does not create the datasheet.
Follow the steps to create a form:
1. Open the Navigation pane.
2. Click the table or query on which user want to base their form.
3. Activate the Create tab.
4. Click Form in the Forms group. MS-Access creates a form.
User can use the Navigation bar to move through the records on a form. The buttons are, in order: 1. Go to First Record, 2. Go to Previous Record, 3. The Current Record, 4. Go to Next Record, 5. Go to Last Record, 6. Create a New (Blank) Record.
To save a form:
1. Click the Save button on the Quick Access toolbar. MS-Access saves the form unless user is saving for the first time. If user is saving for the first time, the Save As dialog box appears.
2. Type the name user want to give the form.
3. Click OK. MS-Access saves the form. User can now access the form by using the Navigation pane.
Modify a Form
After user creates a form, it opens in Layout view, where user can modify it.
To change the size of a field: Click a side of the field and drag to change the width of the field. Click the top or bottom of a field and drag to change the height of a field.
To move a datasheet: Click the datasheet to select it. Click and drag the four-sided arrow in the upper-right corner to move the datasheet.
To resize a datasheet: Click the datasheet to select it. Click a side of the datasheet and drag to change the width. Click the top or bottom of the datasheet and drag to change the height.
To apply an AutoFormat: Activate the Format tab. Click Shape Fill button and choose any color for background color. User can also insert background image from gallery. To change the font color, style, size click Select All button then choose the appropriate changes. Then navigate to Form view to see the full structure of the form.
To change a Form title: While user create a form, by default, MS-Access uses the form name as the title. User can change the title. Activate the Format tab. Click the Title button. Type the new title.
To add the date and time: User can easily add the date and time in their form. Activate the Format tab. Click the Date and Time button. The Date and Time dialog box appears. Select the date and time to appear on the Form.
Reports
1. Reports organize and summarize data for viewing online or for printing.
2. A detail report displays all of the selected records.
Creating Reports
1. User can include summary data such as totals, counts, and percentages in a detail report.
2. A summary report does not list the selected records but instead summarizes the data and presents totals, counts, percentages, or other summary data only.
3. MS-Access has several report generation tools that user can use to create both detail and summary reports quickly.
Use of Report Button
The Report button creates a simple report that lists the records in the selected table or query in a column format. To use the Report button:
1. Open the Navigation pane.
2. Click the table or query on which user want to base their report.
3. Activate the Create tab.
4. Click the Report button in the Reports group. MS-Access creates report and displays report in Layout view. User can modify the report.
Use the Report Wizard
1. User can also use the Report Wizard to create a report.
2. The Report Wizard provides more flexibility than using the Report button.
3. User can choose the tables and fields, group the data, sort the data, summarize the data, choose a layout and orientation, apply a style, and title their report.
4. To create a report by using the Report Wizard: activate the Create tab, then click Report Wizard in the Reports group. The Report Wizard appears.
Select tables, queries and fields. When using the Report Wizard, user can use fields from multiple tables and/or queries if the tables/queries have a relationship.
1. Click the down-arrow next to the Table/Queries field and then click the table from which user want to select fields.
2. Click a field and then click the single-right arrow to select a single field, click the double-right arrows to select all fields, click a field and then click the single-left arrow to deselect a single field, or click the double-left arrow to deselect all fields.
3. Click Next. The Report Wizard moves to the next page.
Group. User can group data by using Report Wizard. Grouping puts all of the values in a field into a group based on the field's value.
1. Click to select the field which user want to group their data. User may not see this page of the wizard if they are selecting data from a single table.
2. Click Next. The Report Wizard moves to the next page.
3. Click a field user want to group by.
4. Click the right-arrow to select a field; click a field and then click the left arrow to deselect a field. Use the up and down arrows to change the order of the groupings.
5. Click Next. The Report Wizard moves to the next page.
Sort and summarize. User can create up to four levels of sort by using the Report Wizard.
1. Click the down-arrow and then select the field user want to sort by.
2. Click the button to choose ascending or descending order. Clicking the button toggles between Ascending and Descending. User can sort up to four levels.
3. Click the Summary Options button. The Summary Options window appears.
4. Click to select the summary data user want.
5. Click to select whether user want detail and summary data or if user want summary data only.
6. Click if user want to calculate the percent to the total for sums.
7. Click OK. The Summary Options window closes.
8. Click Next. The Report Wizard moves to the next page.
Layout and orientation. User can choose the layout and orientation of their report. The layout determines where each field appears on the page. MS-Access provides three options for layout to choose: Stepped, Block and Outline. Orientation determines whether MS-Access creates the report in portrait or landscape.
1. Click to select a layout.
2. Click to select a page orientation.
3. Choose the Adjust The Field Width So All Fields Fit On A Page option if user want all fields to fit on a single page.
4. Click Next. The Report Wizard moves to the next page.
Style. MS-Access supplies predesigned styles that format titles, labels, and more. When user choose a style, the left side of the window displays a preview.
1. Click to select a style.
2. Click Next. The Report Wizard moves to the next page.
Create a title. On the final page of the Report Wizard, user can title their report. The title appears at the top of the report and on the Navigation pane.
1. Type the title user want to give the report.
2. Click Finish. MS-Access creates, saves, and opens their report in Layout view.
Modify a Report
After creation of a report, user can modify it by adding groups or sorting, adding fields, change labels and can perform many other tasks. User can view a report in Report view, Layout view, Design view and Print Preview.
Change to Layout view: Open the report. Activate the Home tab. Click the View button. A menu appears. Click Layout View. MS-Access changes to Layout view.
To change the size of a field or label: Click the field or label. A border appears around it. Click a side of the border and drag outward to increase the width. Click a side of the border and drag inward to decrease the width.
Add a group or sort: Use Group & Sort button on the Design tab to create a group or sort. Click Add a Group and then select the field by which user want to group. MS-Access groups and sorts the field. Click Add a Sort and then select the field on which user want to sort. MS-Access sorts the field.
To add a field: Open the report in Layout view. Activate the Design tab. Click the Add Existing Fields button in the Tools group. The Field List pane appears. Click Show All Tables if the field that user want to add does not appear. Click the field user want to add and drag it onto their report. A thick line appears on the report. MS-Access places the field before the line. If user want the field to appear in the detail area, be sure to drag it to the detail area.
To delete a field: Open the report in Layout view. Click the field user want to delete. Press the Delete key. MS-Access deletes the field.
To move a column: Open the report in Layout view. Click the column label. Drag the column to the new location. MS-Access moves the column to the new location.
To change a title: Open the report in Layout view. Double-click in the Title field. Click and drag to select the current title. Type a new title. Click anywhere outside the Title field. MS-Access changes the title.
To change a field label: Open the report in Layout view. Double-click the field label. Click and drag to select the label name. Type the new label name. Click anywhere outside the label. MS-Access changes the field label.
To add page numbers: Open the report in Layout view. Activate the Design tab. Click the Insert Page Number button. The Page Numbers dialog box appears. Click a radio button to choose a format. Click a radio button to choose a position. Click the down-arrow in the Alignment field and then choose an alignment. Deselect Show Number On First Page if user do not want the page number to appear on the first page. Click OK. MS-Access places the page number in their report.
Summary
In this chapter, we have learnt about:
1. data manipulation concept in database.
2. the relational database.
3. the concept of integrity.
4. the database operations such as creation, dropping and manipulating table structure.
5. the concept of manipulating data in query, forms and reports.
Free study material for Computer Science
CBSE Computer Science Study Material: Database
Comprehensive Study Resources for Database
Explore essential learning tools for Computer Science Database. This curated collection features in-depth notes and targeted practice questions built around the active 2026 curriculum to streamline your daily revision.
Understanding Marking Schemes
Built using official NCERT guidelines for Computer Science, these materials provide reliable academic support. Integrating past examination questions and step-by-step solutions helps students understand official CBSE grading criteria.
Complete Revision for Computer Science
Maximize your grade potential by utilizing Computer Science practice papers in tandem with these structured notes. All printable assignments and interactive mock tests on our platform are updated for the 2026 session and available free of charge.
FAQs
The latest 2026-27 advanced study resources for Computer Science are available for free on StudiesToday.com which includes NCERT Exemplars, high-order thinking skills (HOTS) questions, and deep-dive concept summaries.
Our exhaustive Computer Science package includes chapter wise revision notes, solved practice sheets, important formulas and Concept Maps to help in better understanding of all topics.
Yes. For , our resources have been developed to help you get better marks in school exams and also build fundamental strength needed for entrance tests including Competency Based learning.
in , students should use Active Recall method, read the concept summary, then solve the Important Questions section without looking at the answers and then check your answers.
All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.
Yes, our team has ensured that all Computer Science materials for are strictly aligned with the National Education Policy (NEP) 2020 and the latest 2026-27 syllabus.